--- title: "Discover Managed Data Visualizations With AWS Grafana" description: "Learn how to leverage a managed data visualization tool and observability platform with AWS Grafana in this ATA Learning tutorial!" canonical: "https://adamtheautomator.com/aws-grafana/" --- # Discover Managed Data Visualizations With AWS Grafana > Learn how to leverage a managed data visualization tool and observability platform with AWS Grafana in this ATA Learning tutorial! Source: https://adamtheautomator.com/aws-grafana/ --- ATA Learning Tap to hide [ ATA Learning ](/) * [Home](/) * [Tutorials](/tutorials/) * [Instructors](/author/) * [Advertising](/advertising/) * [Recommended Resources](/resources/) * [About Adam](/about-adam/) Search for: * [](https://twitter.com/adbertram) * [](https://github.com/Adam-the-Automator) * [](https://www.linkedin.com/company/adam-the-automator-llc) * [](/feed/) ![Discover Managed Data Visualizations With AWS Grafana](https://adamtheautomator.com/wp-content/uploads/2022/12/aws-grafana.jpg) # Discover Managed Data Visualizations With AWS Grafana [![](https://secure.gravatar.com/avatar/c02a87a988a9d9204661e4b1c96f2f0e9193275efcd87103d6a6624ff1d38294?s=192&d=mm&r=g)Sophia Iroegbu](https://adamtheautomator.com/author/sophia-iroegbu/)19 December 20226 min. read Categories: [IT Ops](/category/it-ops/) Tags:[AWS](/tag/aws/)[Grafana](/tag/grafana/) Table of Contents * [Prerequisites](#prerequisites) * [Creating a Workspace in AWS Grafana](#creating-a-workspace-in-aws-grafana) * [Assigning User to Workspace](#assigning-user-to-workspace) * [Creating an AWS Grafana Dashboard](#creating-an-aws-grafana-dashboard) * [Adding a Data Source to the Workspace](#adding-a-data-source-to-the-workspace) * [Visualizing Data in AWS Grafana Dashboard](#visualizing-data-in-aws-grafana-dashboard) * [Conclusion](#conclusion) 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](https://aws.amazon.com/free/). ## 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](https://console.aws.amazon.com/console/home). 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-141.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-142.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-143.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-144.png) Enabling an authentication method 6\. Fill in the required information for the new user, and click **Create User.** ![Providing user details](https://adamtheautomator.com/wp-content/uploads/2022/12/image-145.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-146.png) 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. Related:[Helpful Guide to IAM in AWS Through Examples](https://adamtheautomator.com/iam-aws/) ![Choosing permission access](https://adamtheautomator.com/wp-content/uploads/2022/12/image-147.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-148.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-149.png) Selecting notification channels 11\. Finally, review your selected settings, and click **Create Workspace** to finalize creating your workspace. ![Reviewing and creating a workspace ](https://adamtheautomator.com/wp-content/uploads/2022/12/image-150.png) Reviewing and creating a workspace Once created, your browser redirects to your new workspace, as shown below. ![Overviewing the newly-created workspace](https://adamtheautomator.com/wp-content/uploads/2022/12/image-151.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-152.png) 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 ](https://adamtheautomator.com/wp-content/uploads/2022/12/image-153.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-154.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-155.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-156.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-157.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-158.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-159.png) Accessing the dashboard settings 5\. Now, configure your dashboard settings as you prefer, and click **Save dashboard**. ![Configuring the dashboard settings](https://adamtheautomator.com/wp-content/uploads/2022/12/image-160.png) Configuring the dashboard settings 6\. When prompted, leave the **General** folder selected, or choose your own and click **Save**. ![Saving the configured dashboard ](https://adamtheautomator.com/wp-content/uploads/2022/12/image-161.png) Saving the configured dashboard Once done, your dashboard should look like the one below. ![AWS Dashboard](https://adamtheautomator.com/wp-content/uploads/2022/12/image-162.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-163.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-164.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-165.png) Choosing Google Sheets as a data source 4\. Now, generate a [Google API key](https://console.cloud.google.com/apis/credentials) following the instructions as shown below. > 💡 _If you are new to the Google Cloud Platform (GCP), you must [create a project](https://support.google.com/googleapi/answer/6158862?hl=en) before generating an API key._ ![Configuring Google Sheets as a data source](https://adamtheautomator.com/wp-content/uploads/2022/12/image-166.png) Configuring Google Sheets as a data source 5\. Once you have your API key, navigate to the [API library](https://console.cloud.google.com/apis/library) in a new browser tab, and search for **google sheet api.** ![Searching for Google Sheets API](https://adamtheautomator.com/wp-content/uploads/2022/12/image-167.png) 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 ](https://adamtheautomator.com/wp-content/uploads/2022/12/image-168.png) Enabling Google sheets API Once enabled, your browser redirects to the page shown below. ![Confirming Google Sheets API is enabled.](https://adamtheautomator.com/wp-content/uploads/2022/12/image-169.png) 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 ](https://adamtheautomator.com/wp-content/uploads/2022/12/image-170.png) Setting Google Sheets data source on AWS Grafana You should see a green **Success** message confirming the data source has been added. ![Success Message](https://adamtheautomator.com/wp-content/uploads/2022/12/image-171.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-172.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-173.png) 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](https://developers.google.com/sheets/api/guides/concepts). 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-174.png) 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 ](https://adamtheautomator.com/wp-content/uploads/2022/12/image-175.png) 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 ](https://adamtheautomator.com/wp-content/uploads/2022/12/image-176.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-177.png) 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)](https://adamtheautomator.com/wp-content/uploads/2022/12/image-178.png) 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 ](https://adamtheautomator.com/wp-content/uploads/2022/12/image-179.png) Visualizing data from Google Spreadsheet If you choose to open the visualization suggestions, you will see the following options. ![Viewing visualization options](https://adamtheautomator.com/wp-content/uploads/2022/12/image-180.png) 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](https://adamtheautomator.com/wp-content/uploads/2022/12/image-181.png) Visualizing data from Google Sheets data source in table format 7\. Lastly, add a note for saving the dashboard, and click **Sav**e. ![Saving Grafana dashboard ](https://adamtheautomator.com/wp-content/uploads/2022/12/image-182.png) 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](https://docs.aws.amazon.com/grafana/latest/userguide/upgrade-to-Grafana-Enterprise.html) and explore more features that can help your business?_ ![Visualizing the Grafana dashboard panel](https://adamtheautomator.com/wp-content/uploads/2022/12/image-183.png) 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! Share this article [Share on X](https://twitter.com/intent/tweet?url=https%3A%2F%2Fadamtheautomator.com%2Faws-grafana%2F&text=Discover%20Managed%20Data%20Visualizations%20With%20AWS%20Grafana)[Share on Facebook](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fadamtheautomator.com%2Faws-grafana%2F)[Share on LinkedIn](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fadamtheautomator.com%2Faws-grafana%2F) ## Related Posts ![](https://adamtheautomator.com/wp-content/uploads/2022/05/HMaster-Your-Data-with-AWS-Quicksight.jpg) ### [Make Data-Driven Decisions with AWS QuickSight Analytics](/aws-quicksight/) Struggling to make sense of your data? Discover how AWS QuickSight transforms data into actionable insights for smarter decision-making. ![](https://adamtheautomator.com/wp-content/uploads/2023/11/aws-network-access-analyzer-2.jpg) ### [Getting Started with AWS Network Access Analyzer](/aws-network-access-analyzer/) Unlock the power of AWS Network Access Analyzer. Master network security with step-by-step guidance in this tutorial today! ![](https://adamtheautomator.com/wp-content/uploads/2023/11/ngrok-remote.jpg) ### [Hosting an Ngrok Remote Web App on AWS](/ngrok-remote/) Learn how to run the Ngrok remote web application on AWS with the FastAPI Python endpoint in Linux through this ATA Learning tutorial! ## Categories * [IT Ops](/category/it-ops/) * [Cloud](/category/cloud/) * [DevOps](/category/devops/) * [Home Ops](/category/home-ops/) * [Information Security](/category/infosec/) * [Software Development](/category/software-development/) ## Site * [Home](/) * [Tutorials](/tutorials/) * [Instructors](/author/) * [Advertising](/advertising/) * [Recommended Resources](/resources/) * [About Adam](/about-adam/) Copyright 2026© ATA Learning | [Privacy Policy](/privacy/)