Menu
Amazon QuickSight
User Guide

Creating a Data Set Using Amazon Athena Data

You can connect to Amazon Athena data sources and use Athena data to create Amazon QuickSight data sets.

Before you try to read files from Amazon S3 buckets, make sure that you grant Amazon QuickSight access to them. For more information, see Managing Amazon QuickSight Permissions to AWS Resources.

To create an Athena data set

  1. Check Data Source Limits to make sure that your target table or query doesn't exceed data source limits.

  2. On the Amazon QuickSight start page, choose Manage data.

  3. On the Your Data Sets page, choose New data set.

  4. In the FROM NEW DATA SOURCES section of the Create a Data Set page, choose the Athena icon.

  5. For Data source name, type a name for the data source.

  6. Choose Validate connection to validate the connection. If validation fails, make sure Amazon QuickSight has permission to access Athena resources. Then, try validating again. For more information on setting Amazon QuickSight permissions to AWS resources, see Managing User Access in Amazon QuickSight

  7. Choose Create data source.

    Note

    Amazon QuickSight automatically secures connections to Athena instances by using Secure Sockets Layer (SSL). You don't need to do anything to enable this.

  8. For Database: contain sets of tables., choose Select, and then choose your Athena database.

    Note

    If you want to create a custom SQL query, click Edit/Preview data to edit a query. If you do this without selecting a table, you will see an error in the data preview area. You can safely ignore this. The error is saying that there is no data to display until your query is created.

  9. Choose one of the following options:

    • To prepare the data before creating an analysis, choose Edit/Preview data to begin data preparation. Choose to prepare data at this point if you are planning on writing a SQL query, rather than selecting data from a single table. For more information about data preparation, see Preparing Data Sets.

    • Otherwise, choose a table, and then choose Select to confirm.

  10. If you did not choose to prepare the data in the previous step, you will see the following screen.

    To load your data into SPICE, choose Import to SPICE. The green indicator shows whether or not you have space available.

    Alternately, you can choose to query your data without using SPICE. To do this, choose Directly query your data

  11. After choosing how to query your data, choose one of the following options:

    • To prepare the data before creating an analysis, choose Edit/Preview data to begin data preparation for the selected table. For more information about data preparation, see Preparing Data Sets.

    • To create a data set and analyze the data using the table as-is, choose Visualize.