topic Re: How to change streaming table/column description in DLT in Data Engineering

How to change streaming table/column description in DLT

surajitDE — Wed, 28 May 2025 12:37:30 GMT

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

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

Re: How to change streaming table/column description in DLT

Walter_C — Wed, 28 May 2025 12:41:08 GMT

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.

Re: How to change streaming table/column description in DLT

DanV — Fri, 13 Jun 2025 15:10:12 GMT

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.