SET PROPERTIES sets persistent properties on data objects (tables, schemas, workspaces). Properties are written to metadata and take effect permanently until explicitly removed.
Different from SET (session parameters): SET PROPERTIES modifies the persistent configuration of an object, not a temporary session-level parameter.
SET PROPERTIES
Syntax
ALTER TABLE [schema_name.]table_name SET PROPERTIES ('key1'='value1' [, 'key2'='value2' ...]);
ALTER SCHEMA schema_name SET PROPERTIES ('key1'='value1' [, ...]);
ALTER WORKSPACE workspace_name SET PROPERTIES ('key1'='value1' [, ...]);
Examples
-- Set compression and auto-refresh properties on a table
ALTER TABLE sales_records SET PROPERTIES ('compression'='zstd', 'auto_refresh'='true');
-- Set data retention period on a schema
ALTER SCHEMA reporting SET PROPERTIES ('data_retention_days'='90');
-- Set a property on a workspace
ALTER WORKSPACE analytics_ws SET PROPERTIES ('aa'='bb');
UNSET PROPERTIES
Removes properties that have been set on a data object, restoring the system default configuration.
Syntax
ALTER TABLE [schema_name.]table_name UNSET PROPERTIES (key1 [, key2 ...]);
ALTER SCHEMA schema_name UNSET PROPERTIES (key1 [, ...]);
ALTER WORKSPACE workspace_name UNSET PROPERTIES (key1 [, ...]);
Examples
-- Remove a single property from a table
ALTER TABLE sales_records UNSET PROPERTIES ('compression');
-- Remove multiple properties at once
ALTER TABLE customer_feedback UNSET PROPERTIES ('auto_refresh', 'compression');
-- Remove a schema property
ALTER SCHEMA reporting UNSET PROPERTIES ('data_retention_days');
⚠️ Note: Removing a property that does not exist succeeds silently without an error.
SHOW PROPERTIES
View all properties currently set on a data object.
Syntax
SHOW PROPERTIES IN TABLE [schema_name.]table_name;
SHOW PROPERTIES IN SCHEMA schema_name;
SHOW PROPERTIES IN WORKSPACE workspace_name;
Examples
SHOW PROPERTIES IN TABLE sales_data;
SHOW PROPERTIES IN SCHEMA reporting;
SHOW PROPERTIES IN WORKSPACE data_science;
