Visualizing table data with Amazon QuickSight - Amazon Simple Storage Service
Configure permissions for Amazon QuickSight to access tablesUsing table data in Amazon QuickSight

Visualizing table data with Amazon QuickSight

Note

The integration with AWS analytics services for table buckets is in preview release and is subject to change.

Amazon QuickSight is a fast business analytics service to build visualizations, perform ad hoc analysis, and quickly get business insights from your data. QuickSight seamlessly discovers AWS data sources, enables organizations to scale to hundreds of thousands of users, and delivers fast and responsive query performance by using the Amazon QuickSight Super-fast, Parallel, In-Memory, Calculation Engine (SPICE). For more information, see What is Amazon QuickSight? in the Amazon QuickSight user guide.

After you Integrate your table buckets with AWS analytics services, you can create data sets from your tables and work with them in Amazon QuickSight using SPICE or direct SQL queries from your query engine. QuickSight supports Athena as a data source for S3 tables.

Configure permissions for Amazon QuickSight to access tables

Before working with S3 table data in Amazon QuickSight you must grant permissions to the Amazon QuickSight service role, the Amazon QuickSight admin user, and grant Lake Formation permissions on the tables you want to access.

Grant permissions to the Amazon QuickSight service role

When set up Amazon QuickSight for the first time in your account, AWS creates a service role that allows Amazon QuickSight to access data sources in other AWS services, such as Athena or Amazon Redshift. The default role name is aws-quicksight-service-role-v0.

  1. Open the IAM console at https://console.aws.amazon.com/iam/.

  2. Choose Roles and select the Amazon QuickSight service role. The default name is aws-quicksight-service-role-v0

  3. Choose Add permissions and then Create inline policy.

  4. Select JSON to open the JSON policy editor, then add the following policy.

    {
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "VisualEditor0",
      "Effect": "Allow",
      "Action": "glue:GetCatalog",
      "Resource": "*"
    }
  ]
}

  5. Choose Next, enter a Policy name and then Create policy.

To configure permissions for the Amazon QuickSight admin user

  1. Run the following AWS CLI command to find the ARN of your Amazon QuickSight admin user.

    aws quicksight list-users --aws-account-id 111122223333 --namespace default --region Region

  2. Grant Lake Formation permissions to this ARN. For details, see Grant Lake Formation permissions on your table resources.

Using table data in Amazon QuickSight

You can connect to table data using Athena as a data source.

Prerequisites

  1. Open Amazon QuickSight from the AWS Management Console. You can find it under Analytics or by searching for Amazon QuickSight.

  2. In the dashboard, choose New analysis.

  3. Choose New dataset.

  4. Select Athena.

  5. Enter a Data source name, then choose Create data source.

  6. Choose Use custom SQL. You will not be able to select your table from the Choose your table pane.

  7. Enter an Athena SQL query that captures the columns you want to visualize, then choose Confirm query. For example, use the following query to select all columns:

    SELECT * FROM "s3tablescatalog/<table-bucket-name>".<namespace>.<table-name>

  8. Choose Visualize to analyze data and start building dashboards. For more information, see Visualizing data in Amazon QuickSight and Exploring interactive dashboards in Amazon QuickSight