Preparing data tables in Amazon Athena
You can query data tables that have been created as AWS Glue Data Catalog (GDC) Views in Amazon Athena.
A GDC View is a virtual table, created from one or more underlying AWS Glue tables. It
must be created using Athena SQL in the Athena AwsGlueCatalog catalog.
Note
Complex (nested) data types—ARRAY, MAP, and STRUCT—are not supported for Amazon Athena data sources in AWS Clean Rooms. If an underlying AWS Glue table or GDC View contains a column of a complex data type, queries fail during table setup. This occurs even when the query doesn't reference that column. To work around this limitation, create a GDC View that excludes the complex-typed columns, or cast them to a supported type such as STRING.
Preparing your data tables in Amazon Athena involves the following steps:
Step 1: Complete the prerequisites
To prepare your data tables for use with AWS Clean Rooms, you must complete the following prerequisites:
-
Your data tables are saved as one of the supported data formats for AWS Clean Rooms.
-
Your data tables use the supported data types for AWS Clean Rooms.
-
You have created a GDC View on your AWS Glue table using Athena SQL in the Athena
AwsDataCatalogcatalog.The view will appear in:
-
The Athena console (under the
AwsDataCatalog) as a View: https://console.aws.amazon.com/athena/ -
The AWS Glue console as a AWS Glue table: https://console.aws.amazon.com/glue/
For more information, see Use Data Catalog views in Athena in the Amazon Athena User Guide.
Note
You need appropriate permissions to create Views in Athena and AWS Glue. Also, ensure that you have access to the underlying tables referenced in your View definition.
AWS Clean Rooms only supports the AWS Glue Catalog Type for Athena, not Lambda or Hive Catalog Types.
-
-
Your data tables or GDC Views are cataloged in AWS Glue and are registered with AWS Lake Formation.
-
You have created a separate output bucket in Amazon S3 to receive the Athena results.
-
You have set up a service role to read the data from Amazon Athena. For more information, see Create a service role to read data from Amazon Athena.
-
The service role has Lake Formation Select and Describe access permissions on the GDC View or table.
-
Step 2: Next steps
Now that you have prepared your data tables in Amazon Athena, you are ready to:
The tables can be queried after:
-
The collaboration creator has set up a collaboration in AWS Clean Rooms. For more information, see Creating a collaboration.
-
The collaboration creator has sent the collaboration ID to you as a participant in the collaboration.
