ALTER TABLE UNSET TBLPROPERTIES - Amazon Athena
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

ALTER TABLE UNSET TBLPROPERTIES

Drops existing properties from an Iceberg table.

Synopsis

ALTER TABLE [db_name.]table_name UNSET TBLPROPERTIES ('property_name' [ , ... ])

Example

ALTER TABLE iceberg_table UNSET TBLPROPERTIES ('write_compression')

The following example removes the write.data.path property from an Iceberg table.

ALTER TABLE iceberg_table UNSET TBLPROPERTIES ('write.data.path')