View a markdown version of this page

ALTER TABLE UNSET TBLPROPERTIES - Amazon Athena

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')