Home icon
Simplify external object access in Amazon Redshift using automatic mounting of the AWS Glue Data Catalog

Blog



This article explains how Amazon Redshift now automatically mounts the AWS Glue Data Catalog, eliminating the need to create external schemas to query data lake tables.

  • Redshift automatically mounts Glue Data Catalog as "awsdatacatalog" database without manual schema creation
  • Supports multiple authentication methods: IAM Identity Center, IAM credentials, federated users, and IAM roles
  • Works with Redshift RA3, Redshift Serverless, and all AWS commercial and US Gov Cloud regions
  • Enables querying Apache Hudi, Delta Lake, and Apache Iceberg table formats directly from Redshift
  • Two implementation scenarios: IAM Identity Center authentication and non-IDC methods
  • Integrates with AWS Lake Formation for fine-grained access control and data governance
  • Supports Query Editor v2 and third-party SQL clients for data discovery and querying
  • Uses three-part notation to reference tables: awsdatacatalog.glue_database.glue_table

This feature simplifies data lake access for analysts by automating catalog mounting while maintaining security through Lake Formation permissions and IAM policies.



Go to article

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

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.