Querying metadata tables - Amazon Simple Storage Service
Query pricing considerations
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).

Querying metadata tables

Amazon S3 Metadata lets you analyze your S3 managed metadata tables with any query engine that supports the Apache Iceberg format. When you integrate your S3 table buckets with Amazon analytics services, you can use services like Amazon Athena, Amazon Redshift, and others to help you do the following with your metadata tables:

  • Discover storage usage patterns and trends

  • Audit Amazon Key Management Service (Amazon KMS) encryption key usage across your objects

  • Search for objects by user-defined metadata and object tags

  • Understand object metadata changes over time

  • Learn when objects are updated or deleted, including the Amazon Web Services account ID or IP address that made the request

After your table buckets are integrated with Amazon analytics services, you can query your metadata tables. This includes joining S3 managed metadata tables and custom metadata tables, allowing you to query across multiple datasets as long as the metadata tables are stored in the same table bucket.

From there, you can create interactive dashboards with your query data by using Amazon QuickSight.

Query pricing considerations

Additional pricing applies for running queries on your metadata tables. For more information, see pricing information for the query engine that you're using.

For information on making your queries more cost effective, see Optimizing metadata table query performance.

Topics