Discover Managed Data Visualizations With AWS Grafana

Published:19 December 2022 - 6 min. read

Azure Cloud Labs: these FREE, on‑demand Azure Cloud Labs will get you into a real‑world environment and account, walking you through step‑by‑step how to best protect, secure, and recover Azure data.

Collecting, and analyzing data about usage, uptime, response time, etc., can be tedious and confusing. How could all these things be visualized? Visualizing data through the AWS Grafana dashboard is one of the most exciting ways to use AWS services for monitoring your organization.

In this tutorial, you will explore and learn to connect data sources with Grafana and give tips on visualizing data even better with some tweaks here and there.

Feel excited yet? Dive in and start visualizing data like never before!

Prerequisites

This tutorial will be a hands-on demonstration. To follow along, be sure you have an active AWS account.

Creating a Workspace in AWS Grafana

AWS Grafana is a data visualization tool with more than thirty (30) data sources available on the AWS Marketplace. AWS Grafana offers a workspace for users to maintain team members’ permissions.

In this example, you will create and set up a workspace by assigning users to the workspace in AWS Grafana.

1. Open your favorite web browser, and sign in to the AWS console.

2. Once signed in, search for AWS Grafana, and click Amazon Grafana from the search result to access the service.

Searching for the AWS Grafana service
Searching for the AWS Grafana service

3. Next, click on Create Workspace in the Amazon Managed Grafana to initiate creating a workspace.

Initiating creating a workspace on AWS Grafana
Initiating creating a workspace on AWS Grafana

4. Now, configure your workspace details, such as the Workspace name, description (optional), and so on, and click Next.

Note that tags are also optional, but for the sake of this tutorial, tags are added. Tags are labels assigned to AWS resource groups and stored in a key-value state. Adding tags helps search and filter your resources or track your AWS costs.

Specifying workspace details
Specifying workspace details

5. Tick the AWS IAM Identity Center box to enable a way to authenticate users accessing your Grafana workspace, and click Create user to add a user to the service. A pop-up window appears where you will provide the user details (step six).

Enabling an authentication method
Enabling an authentication method

6. Fill in the required information for the new user, and click Create User.

Providing user details
Providing user details

7. Next, leave the Permission type as is, and click Next once you see the authentication access method is Enabled.

Confirming configuration settings
Confirming configuration settings

8. Next, select an IAM permission access. For a personal workspace, leave the Current Account option selected. Otherwise, select the Organization option.

Choosing permission access
Choosing permission access

9. Scroll down to the Data sources section, and select a data source. But for this tutorial, select all available data sources since your focus is not on a particular data source.

Selecting data source for the workspace
Selecting data source for the workspace

10. Under the Notification channels, select how you want to be notified about related information on your workspace, and click Next.

Selecting notification channels
Selecting notification channels

11. Finally, review your selected settings, and click Create Workspace to finalize creating your workspace.

Reviewing and creating a workspace
Reviewing and creating a workspace

Once created, your browser redirects to your new workspace, as shown below.

Overviewing the newly-created workspace
Overviewing the newly-created workspace

Assigning User to Workspace

Remember the user you created to enable the AWS IAM Identity Center? You must assign that user to your workspace since it does not have access to your workspace by default.

To assign a user to your workspace:

1. Under the Authentication tab, click Assign new user or group to initiate assigning a new user.

Initiating assigning a new user
Initiating assigning a new user

2. Select your target user, and click Assign users and groups to assign the user to your workspace.

Selecting a user to assign access to the Grafana workspace
Selecting a user to assign access to the Grafana workspace

Once assigned, you will see the user gets viewer rights or access to your workspace. Confirming assigned user has rights to view Grafana console

Confirming assigned user has rights to view Grafana console
Confirming assigned user has rights to view Grafana console

3. Now, click on the Actions dropdown to grant admin or editor access to the user.

Viewing permission type for the assigned user
Viewing permission type for the assigned user

Creating an AWS Grafana Dashboard

Now that the configuration and permission settings are out of the way, it is time to work on your AWS Grafana dashboard. This dashboard is where you can manage your data visualizations.

To create an AWS Grafana Dashboard:

1. Navigate to your workspace, and click on the Grafana workspace URL, as shown below, to access your Grafana home page.

Accessing the Grafana home page
Accessing the Grafana home page

2. Next, click Create your first dashboard on the Grafana home page to create a new dashboard

Creating a dashboard on the AWS Grafana workspace
Creating a dashboard on the AWS Grafana workspace

3. On your new dashboard, click Add a new panel to a new panel that lets you add a data source from a Query tab.

Creating a new panel in the dashboard
Creating a new panel in the dashboard

4. On the new panel, click the settings icon (upper-right) to access your dashboard settings.

Accessing the dashboard settings
Accessing the dashboard settings

5. Now, configure your dashboard settings as you prefer, and click Save dashboard.

Configuring the dashboard settings
Configuring the dashboard settings

6. When prompted, leave the General folder selected, or choose your own and click Save.

Saving the configured dashboard
Saving the configured dashboard

Once done, your dashboard should look like the one below.

AWS Dashboard
AWS Dashboard

Adding a Data Source to the Workspace

What you currently have on your dashboard is only a generic panel with no data. You must connect a data source to the workspace and visualize the data.

To add a data source to your workspace:

1. On your dashboard, click the settings icon (left panel) and click Data sources to initiate adding data sources.

Accessing data sources configuration
Accessing data sources configuration

2. Next, click on Add data source to view the list of data sources you can configure for your dashboard.

Accessing a list of available data sources
Accessing a list of available data sources

3. Search for sheets and select Google Sheets to demonstrate how to add visual data through a data source.

Choosing Google Sheets as a data source
Choosing Google Sheets as a data source

4. Now, generate a Google API key following the instructions as shown below.

💡 If you are new to the Google Cloud Platform (GCP), you must create a project before generating an API key.

Configuring Google Sheets as a data source
Configuring Google Sheets as a data source

5. Once you have your API key, navigate to the API library in a new browser tab, and search for google sheet api.

Searching for Google Sheets API
Searching for Google Sheets API

6. Next, click ENABLE to start using Google Sheets API. This API enables you to access Google Sheets from your Grafana dashboard.

Enabling Google sheets API
Enabling Google sheets API

Once enabled, your browser redirects to the page shown below.

Confirming Google Sheets API is enabled.
Confirming Google Sheets API is enabled.

7. Switch to Grafana, input your API key, and click Save & Test to test the API connection

Setting Google Sheets data source on AWS Grafana
Setting Google Sheets data source on AWS Grafana

You should see a green Success message confirming the data source has been added.

Success Message
Success Message

8. Navigate to the Permissions tab, and click Enable to enable permissions for your data source. Doing so lets your teammates query your dashboard or data source.

Enabling permissions for Google Sheets API
Enabling permissions for Google Sheets API

9. Now, click on Add a permission to set permissions for anyone in your team or organization as an admin. But to revoke permission access, click Disable permissions instead.

Adding/Revoking permissions
Adding/Revoking permissions

Visualizing Data in AWS Grafana Dashboard

With the Google Sheet API and permissions in place, it is time to visualize your data. But first, you will need your Spreadsheet ID to identify which spreadsheet is to be accessed or altered.

1. Open one of your Google Spreadsheets, and get your Spreadsheet ID. You can find a Google Spreadsheet ID in the URL below:

https://docs.google.com/spreadsheets/d/SpreadsheetID/edit#gid=0

2. Next, navigate to your data source Settings, and click Explore to explore your Google Sheet.

Exploring Google Sheets API as a data source
Exploring Google Sheets API as a data source

3. Input your Spreadsheet ID, and click Run Query to query the data from your Google Spreadsheet.

Querying Google Spreadsheet data
Querying Google Spreadsheet data

If successful, your data should be shown like the one below. In this example, a single-column data sheet is used.

Viewing data from Google Sheets
Viewing data from Google Sheets

💡 Just so you know, you can specify the range of data to query, as shown below, to filter the data you need.

Specifying the range of data to query
Specifying the range of data to query

4. Now, head to your AWS Grafana dashboard panel and press E on your keyboard to open the query editor (step five).

AWS Grafana dashboard panel (Empty)
AWS Grafana dashboard panel (Empty)

5. Under the Query tab, fill up the query editor with your Spreadsheet ID, the Range of data to query, and so on.

Once filled, choose any of the following options:

Visualization OptionDescription
Open visualization suggestionsLets you view suggestions on how to visualize your data.
Switch to tableVisualizes data from your Google Spreadsheet to a table.

But this tutorial visualizes the data in a table for simplicity.

Visualizing data from Google Spreadsheet
Visualizing data from Google Spreadsheet

If you choose to open the visualization suggestions, you will see the following options.

Viewing visualization options
Viewing visualization options

6. Click Save (upper-right) once satisfied with the data and visualization option to save the dashboard and data.

Visualizing data from Google Sheets data source in table format
Visualizing data from Google Sheets data source in table format

7. Lastly, add a note for saving the dashboard, and click Save.

Saving Grafana dashboard
Saving Grafana dashboard

Once saved, you will see your data on your AWS Grafana dashboard panel, as shown below.

💡 Liking AWS Grafana so far? Why not upgrade to Grafana Enterprise and explore more features that can help your business?

Visualizing the Grafana dashboard panel
Visualizing the Grafana dashboard panel

Conclusion

One of the essential data management tasks is visualizing your data. And in this tutorial, you have learned that the AWS Grafana dashboard allows you to collect, organize, and distribute data in the form of dashboards, infographics, and maps.

Grafana’s pluggable architecture eases the extension and integration of functionality into your organization’s data infrastructure.

A well-designed dashboard lets you gain insights about your business to improve decision-making, increase revenue, and optimize business operations. So why not integrate the AWS Grafana dashboard into your company’s existing workflows and mobile applications? Start providing a unified look across applications and devices!

Hate ads? Want to support the writer? Get many of our tutorials packaged as an ATA Guidebook.

Explore ATA Guidebooks

Looks like you're offline!