Tables - Amazon Simple Storage Service

Tables

An S3 table represents a structured dataset consisting of underlying table data and related metadata. This data is stored inside a table bucket as a subresource. All tables in a table bucket are stored in the Apache Iceberg table format. Through integration with AWS Glue Data Catalog, you can interact with your tables using AWS analytics services, such as Amazon Athena and Amazon Redshift. Amazon S3 manages maintenance of your tables through automatic file compaction and snapshot management. For more information, see S3 Tables maintenance.

Note

The integration with AWS analytics services for table buckets is in preview release and is subject to change.

When you create a table, Amazon S3 automatically generates a warehouse location for the table. This is a unique S3 location stores objects associated with the table. The following example shows the format of a warehouse location: 

s3://63a8e430-6e0b-46f5-k833abtwr6s8tmtsycedn8s4yc3xhuse1b--table-s3

Within your table bucket, you can organize tables into logical groupings called namespaces. For more information, see Table namespaces.

You can rename tables, but each table has its own unique ARN and unique table ID. Each table also has a resource policy attached to it. You can use this policy to manage access to the table.

Table ARNs use the following format:

arn:aws:s3tables:Region:OwnerAccountID:bucket/bucket-name/table/tableID

By default, you can create up to 100 tables in a table bucket. To request a quota increase for table buckets or tables, contact AWS Support.

Amazon S3 supports the following types of tables in table buckets:

Customer (self-managed) tables

Customer tables are tables that you can read and write to. You can retrieve data from these tables using integrated query engines. You can insert, update, or delete data within them by using S3 API operations or integrated query engines.

S3 managed tables

AWS tables are read-only tables that are generated by an AWS service on your behalf. These tables are managed by Amazon S3 and can't be modified by any IAM principal outside of Amazon S3 itself. You can retrieve information from these tables, but you can't modify the data in them. AWS tables include S3 Metadata tables, which contain metadata that's captured from the objects within an S3 general purpose bucket. For more information, see Accelerating data discovery with S3 Metadata.

Note

The S3 Metadata feature is in preview release for Amazon S3 and is subject to change.

Topics