Connect to AWS S3. Supports two modes:

1. Credentials mode (private buckets): provide aws_access_key_id + aws_secret_access_key + region_name.

2. Public S3 mode (no credentials): provide account_id + s3_bucket_url. Region is auto-detected from the URL when possible.

Creates an S3 table bucket. Permissions: You must have the s3tables:CreateTableBucket permission.

List all S3 table buckets for your AWS account. Permissions: You must have the s3tables:ListTableBuckets permission.

Creates a namespace. A namespace is a logical grouping of tables within your S3 table bucket. Permissions: You must have the s3tables:CreateNamespace permission.

List all namespaces across all S3 table buckets. Permissions: You must have the s3tables:ListNamespaces permission.

Creates a new S3 table associated with the given S3 namespace in an S3 table bucket. The S3 table can be configured with specific format and metadata settings. Permissions: You must have the s3tables:CreateTable permission.

List all S3 tables across all table buckets and namespaces. Permissions: You must have the s3tables:ListTables permission.

Renames an S3 table or moves it to a different S3 namespace within the same S3 table bucket. Permissions: You must have the s3tables:RenameTable permission.

Gets the S3 URI location of the table metadata, which contains the schema and other table configuration information. Permissions: You must have the s3tables:GetTableMetadataLocation permission.

Updates the metadata location for an S3 table. Permissions: You must have the s3tables:UpdateTableMetadataLocation permission.

Retrieves the metadata table configuration for a regular general purpose bucket in S3. Permissions: You must have the s3:GetBucketMetadataConfiguration permission.

Gets details about the maintenance configuration of a table. Permissions: You must have the s3tables:GetTableMaintenanceConfiguration permission.

Gets the status of a maintenance job for a table. Permissions: You must have the s3tables:GetTableMaintenanceJobStatus permission.

Execute SQL queries against S3 Tables using PyIceberg/Daft engine. This tool provides a secure interface to run read-only SQL queries.

Append rows to an Iceberg table using PyIceberg engine. The rows parameter must be a list of dictionaries, each representing a row.

Reads data from a CSV file stored in S3 and imports it into an S3 table. If the table doesn't exist, it will be created with a schema inferred from the CSV.

Reads data from a Parquet file stored in S3 and imports it into an existing S3 table. The table must already exist. The Parquet file schema must be compatible with the table's schema.