CREATE SINK my_s3_tables_sink FROM my_mv
WITH (
connector = 'iceberg',
type = 'upsert',
primary_key = 'id',
warehouse.path = 'arn:aws:s3tables:<your-region>:<account-id>:bucket/<bucket-name>',
s3.access.key = '...',
s3.secret.key = '...',
s3.region = '<your-region>',
catalog.type = 'rest',
catalog.uri = 'https://s3tables.<your-region>.amazonaws.com/iceberg',
catalog.rest.signing_region = '<your-region>',
catalog.rest.sigv4_enabled = true,
catalog.rest.signing_name = 's3tables',
database.name = '<your-database-name>',
table.name = '<your-table-name>'
);