Query AWS Glue Data Catalog views using Amazon Athena and Amazon Redshift
Big Data Blog
This article discusses how to query AWS Glue Data Catalog views using Amazon Athena and Amazon Redshift. Data Catalog views allow defining a common view schema and metadata container that can hold view definitions in different dialects across engines like Redshift and Athena.
Specifically, the article covers:
- Setting up the solution using an Example Corp use case scenario
- Creating a Data Catalog view and adding Athena and Redshift engine dialects to it
- Granting permissions to query the view using AWS Lake Formation
- Querying the Data Catalog view from Athena and Redshift without needing access to underlying databases and tables
- Potential use cases for Data Catalog views such as data access control, data governance, and data mesh patterns
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Aug 8
2024
2024
AWS Glue Data Catalog views are now GA with Amazon Athena and Amazon Redshift
May 9
2024
2024
Use AWS Glue Data Catalog views to analyze data
Oct 1
2024
2024
Accelerate Amazon Redshift Data Lake queries with AWS Glue Data Catalog Column Statistics
Dec 3
2024
2024
Introducing AWS Glue Data Catalog automation for table statistics collection for improved query performance on Amazon Redshift and Amazon Athena
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.