You can query your S3 managed metadata tables with AWS analytics services such as Amazon Athena, Amazon Redshift, and Amazon EMR.
Before you can run queries, you must first integrate the S3 table buckets in your AWS account and Region with AWS analytics services.
Querying metadata tables with
Amazon Athena
After you integrate your S3 table
buckets with AWS analytics services, you can start querying your metadata tables
in Athena. In your queries, specify your catalog as s3tablescatalog and your
database as aws_s3_metadata (which is the namespace for your metadata tables).
For more information, see Querying Amazon S3 tables
with Athena.
Querying metadata tables with
Amazon Redshift
After you integrate your S3 table
buckets with AWS analytics services, you create
a resource link to your metadata table namespace (aws_s3_metadata).
Once that's done, you can start querying your metadata tables in the Amazon Redshift console. For
more information, see Accessing Amazon S3 tables
with Amazon Redshift.
Querying metadata tables with
Amazon EMR
To query your metadata tables by using Amazon EMR, you create an Amazon EMR cluster configured for Apache Iceberg and connect to your metadata tables using Apache Spark. You can set this up by integrating your S3 table buckets with AWS analytics services or using the open-source Amazon S3 Tables Catalog for Iceberg client catalog.
For more information, see Accessing Amazon S3 tables with Amazon EMR.
