cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How to change streaming table/column description in DLT

surajitDE
New Contributor III

Hi folks,
How to change streaming table/column description in DLT during run time like we do for delta tables because ALTER STREAMING table isn't working.

eg:
COMMENT ON COLUMN ops_catalog_gld_dev.schema_silver.table_name.property_sid IS 'The key of the property of the message_2';

OR 

ALTER TABLE main.telemetry_db.table_name SET TBLPROPERTIES ('comment' = 'Telemetry latency aggregation metrics across pipelines');

1 ACCEPTED SOLUTION

Accepted Solutions

Walter_C
Databricks Employee
Databricks Employee

Modifying streaming table column descriptions should be done via pipeline configuration instead of runtime SQL commands, as DLT does not retain such runtime alterations during pipeline refreshes.

View solution in original post

2 REPLIES 2

Walter_C
Databricks Employee
Databricks Employee

Modifying streaming table column descriptions should be done via pipeline configuration instead of runtime SQL commands, as DLT does not retain such runtime alterations during pipeline refreshes.

DanV
New Contributor II

How do we do this? The only documentation I can see shows how to add a comment for the streaming table but not comments for column level.