Creating a configured table – Amazon Athena data source - AWS Clean Rooms

Creating a configured table – Amazon Athena data source

The Amazon Athena datasource option allows you to query data stored in Amazon S3, cataloged in the AWS Glue data catalog, and access controlled via AWS Lake Formation. Both tables and AWS Glue Data Catalog Views are supported. Lake Formation resource links can be used to share tables and views across AWS accounts and across AWS Regions to the AWS Clean Rooms member account that joins them to an AWS Clean Rooms collaboration.

Note

Only Amazon S3-based datasets can be queried via the Athena data source integration.

In this procedure, the member does the following tasks:

  • Configures an existing table or view in the AWS Glue Data Catalog for use the AWS Clean Rooms

  • Names the configured table and chooses which columns to use in the collaboration.

The following procedure assumes that:

  • The collaboration member has already created the AWS Glue Data Catalog database and table or GDC view.

To create a configured table – Athena data source

  1. Sign in to the AWS Management Console and open the AWS Clean Rooms console at https://console.aws.amazon.com/cleanrooms.

  2. In the left navigation pane, choose Tables.

  3. In the upper right corner, choose Configure new table.

  4. For Data source, under AWS data sources, choose Amazon Athena.

  5. Under Amazon Athena table:

    1. Choose the Database from the dropdown list.

    2. Choose the Table that you want to configure from the dropdown list.

    Note

    To verify that this is the correct table, do either one of the following:

    • Choose View in AWS Glue.

    • Turn on View schema from AWS Glue to view the schema.

  6. For Amazon Athena configurations,

    1. Choose a Workgroup from the dropdown list.

    2. For S3 output location, choose a recommended action, based on one of the following scenarios.

      Scenario Recommended action
      Your Workgroup doesn’t have a default output location.

      Enter the S3 output location or choose Browse S3.
      Your Workgroup enforces your default output location. The S3 output location is automatically chosen and you can't change it.
      Your Workgroup doesn’t enforce your default output location.

      Enter the S3 output location or choose Browse S3.

  7. For Columns allowed in collaborations, choose an option based on your goal.

    Your goal Recommended option
    Allow all columns for use in AWS Clean Rooms (subject to analysis rules) All columns
    Allow one or more columns from the Specify allowed columns dropdown list Custom list

  8. For Configured table details,

    1. Enter a Name for the configured table.

      You can use the default name or rename this table.

    2. Enter a Description of the table.

      The description helps differentiate between other configured tables with similar names.

    3. If you want to enable Tags for the configured table resource, choose Add new tag and then enter the Key and Value pair.

  9. Choose Configure new table.

Now that you have created a configured table, you are ready to: