Creating a dataset using Amazon Athena data - Amazon QuickSight

Creating a dataset using Amazon Athena data

Use the following procedure to create a new dataset that connects to Amazon Athena data or to Athena Federated Query data.

To connect to Amazon Athena

  1. Begin by creating a new dataset. Choose Datasets from the navigation pane at left, then choose New dataset.

    1. To use an existing Athena connection profile (common), scroll down to the FROM EXISTING DATA SOURCES section, and choose the card for the existing data source that you want to use. Choose Create dataset.

      Cards are labeled with the Athena data source icon and the name provided by the person who created the connection.

    2. To create a new Athena connection profile (less common), use the following steps:

      1. In the FROM NEW DATA SOURCES section, choose the Athena data source card.

      2. For Data source name, enter a descriptive name.

      3. For Athena workgroup, choose your workgroup.

      4. Choose Validate connection to test the connection.

      5. Choose Create data source.

  2. On the Choose your table screen, do the following:

    1. For Catalog, choose one of the following:

      • If you are using Athena Federated Query, choose the catalog you want to use.

      • Otherwise, choose AwsDataCatalog.

    2. Choose one of the following:

      • To write a SQL query, choose Use custom SQL.

      • To choose a database and table, choose your catalog that contains your databases from the dropdown under Catalog. Then, choose a database from the dropdown under Database and choose a table from the Tables list that appears for your database.

    If you don't have the right permissions, you receive the following error message: "You don't have sufficient permissions to connect to this dataset or run this query." Contact your QuickSight administrator for assistance. For more information, see Authorizing connections to Amazon Athena.

  3. Choose Edit/preview data.

  4. Create a dataset and analyze the data using the table by choosing Visualize. For more information, see Visualizing data in Amazon QuickSight.