Register and use data catalogs in Athena - Amazon Athena
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Register and use data catalogs in Athena

Athena supports mounting and connecting to multiple data catalogs.

  • You can mount Amazon Redshift data in the Amazon Glue Data Catalog and query it from Athena without having to copy or move data. For more information, see Bringing Amazon Redshift data into the Amazon Glue Data Catalog.

  • Connect the Amazon Glue Data Catalog to external data sources using Amazon Glue connections, and create federated catalogs to centrally manage permissions to the data with fine-grained access control using Lake Formation. For more information, see Register your connection as a Glue Data Catalog.

  • Create catalogs from Amazon S3 table buckets, and use Lake Formation to centrally manage access permissions and restrict user access to objects within the table bucket. For more information, see Working with Amazon S3 Tables and table buckets in the Amazon S3 User Guide.

Note

For any Glue catalog, you can only register a multi-level catalog like 123412341234:my_catalog/my_child. You cannot register a single-level catalog like 123412341234:linkcontainer or my_catalog. Single-level catalogs can only be queried by using the Glue data catalog directly in the Athena query. For more information, see Query Amazon Glue data catalogs in Athena.

Topics