TBLPROPERTIES is an optional clause in create MOTF table syntax.
| TBLPROPERTIES | Optional Values | Default Value |
|---|---|---|
| write.format.default | parquet | parquet |
| write.parquet.compression-codec | snappy / gzip / zstd | snappy |
| write.delete.mode | merge-on-read / copy-on-write | merge-on-read |
| write.update.mode | merge-on-read / copy-on-write | merge-on-read |
| write.merge.mode | merge-on-read / copy-on-write | merge-on-read |
| format-version | 2 | 2 |
| catalog_database_name | Name of the database in catalog where you want to create table. | same as TD database name |
| catalog_table_name | Name of the table in catalog | same as TD table name |
All write operations - DELETE, UPDATE, and MERGE - must use the same write mode, either merge-on-read or copy-on-write.