struct, list, or map, use schemaV2 instead.
- `fields` SchemaField[], required — The schema fields for the table
- `id` integer — An optional unique identifier for the schema field. Field IDs are used by Apache Iceberg to track schema evolution and maintain compatibility across schema changes. If not specified, S3 Tables automatically assigns field IDs.
- `name` string, required — The name of the field.
- `type` string, required — The field type. S3 Tables supports all Apache Iceberg primitive types. For more information, see the Apache Iceberg documentation.
- `required` boolean — A Boolean value that specifies whether values are required for each row in this field. By default, this is false and null values are allowed in the field. If this is true the field does not allow null values.
- `schemaV2` object — The schema for an Iceberg table using the V2 format. Use this property to define table schemas that include nested or complex data types such as struct, list, or map, in addition to primitive types. For schemas with only primitive types, you can use either schema or schemaV2.
- `type` 'struct', required — The type of the top-level schema, which is always a struct type as defined in the Apache Iceberg specification. This value must be struct.
- `fields` SchemaV2Field[], required — The schema fields for the table. Each field defines a column in the table, including its name, type, and whether it is required.
- `id` integer, required — The unique identifier for the schema field. Field IDs are used by Apache Iceberg to track schema evolution and maintain compatibility across schema changes.
- `name` string, required — The name of the field.
- `type` object, required — The data type of the field. This can be a primitive type string such as boolean, int, long, float, double, string, binary, date, timestamp, or timestamptz, or a complex type represented as a JSON object for nested types such as struct, list, or map. For more information, see the Apache Iceberg schemas and data types documentation.
- `required` boolean, required — A Boolean value that specifies whether values are required for each row in this field. If this is true, the field does not allow null values.
- `doc` string — An optional description of the field.
- `schemaId` integer — An optional unique identifier for the schema. Schema IDs are used by Apache Iceberg to track schema evolution.
- `identifierFieldIds` Integer[] — A list of field IDs that are used as the identifier fields for the table. Identifier fields uniquely identify a row in the table.
- `partitionSpec` object — The partition specification for the Iceberg table. Partitioning organizes data into separate files based on the values of one or more fields, which can improve query performance by reducing the amount of data scanned. Each partition field applies a transform (such as identity, year, month, or bucket) to a single field.
- `fields` IcebergPartitionField[], required — The list of partition fields that define how the table data is partitioned. Each field specifies a source field and a transform to apply. This field is required if partitionSpec is provided.
- `sourceId` integer, required — The ID of the source schema field to partition by. This must reference a valid field ID from the table schema.
- `transform` string, required — The partition transform to apply to the source field. Supported transforms include identity, year, month, day, hour, bucket, and truncate. For more information, see the Apache Iceberg partition transforms documentation.
- `name` string, required — The name for this partition field. This name is used in the partitioned file paths.
- `fieldId` integer — An optional unique identifier for this partition field. If not specified, S3 Tables automatically assigns a field ID.
- `specId` integer — The unique identifier for this partition specification. If not specified, defaults to 0.
- `writeOrder` object — The sort order for the Iceberg table. Sort order defines how data is sorted within data files, which can improve query performance by enabling more efficient data skipping and filtering.
- `orderId` integer, required — The unique identifier for this sort order. If not specified, defaults to 1. The order ID is used by Apache Iceberg to track sort order evolution.
- `fields` IcebergSortField[], required — The list of sort fields that define how data is sorted within files. Each field specifies a source field, sort direction, and null ordering. This field is required if writeOrder is provided.
- `sourceId` integer, required — The ID of the source schema field to sort by. This must reference a valid field ID from the table schema.
- `transform` string, required — The transform to apply to the source field before sorting. Use identity to sort by the field value directly, or specify other transforms as needed.
- `direction` 'asc' | 'desc', required — The sort direction. Valid values are asc for ascending order or desc for descending order.
- `nullOrder` 'nulls-first' | 'nulls-last', required — Specifies how null values are ordered. Valid values are nulls-first to place nulls before non-null values, or nulls-last to place nulls after non-null values.
- `properties` unknown
- `encryptionConfiguration` object — Configuration specifying how data should be encrypted. This structure defines the encryption algorithm and optional KMS key to be used for server-side encryption.
- `sseAlgorithm` 'AES256' | 'aws:kms' — The server-side encryption algorithm to use. Valid values are AES256 for S3-managed encryption keys, or aws:kms for Amazon Web Services KMS-managed encryption keys. If you choose SSE-KMS encryption you must grant the S3 Tables maintenance principal access to your KMS key. For more information, see Permissions requirements for S3 Tables SSE-KMS encryption.
- `kmsKeyArn` string — The Amazon Resource Name (ARN) of the KMS key to use for encryption. This field is required only when sseAlgorithm is set to aws:kms.
- `storageClassConfiguration` object — The configuration details for the storage class of tables or table buckets. This allows you to optimize storage costs by selecting the appropriate storage class based on your access patterns and performance requirements.
- `storageClass` 'STANDARD' | 'INTELLIGENT_TIERING' — The storage class for the table or table bucket. Valid values include storage classes optimized for different access patterns and cost profiles.
- `tags` object — A map of user-defined tags that you would like to apply to the table that you are creating. A tag is a key-value pair that you apply to your resources. Tags can help you organize, track costs for, and control access to resources. For more information, see Tagging for cost allocation or attribute-based access control (ABAC).
You must have the s3tables:TagResource permission in addition to s3tables:CreateTable permission to create a table with tags.