Saritha_S
Databricks Employee
Databricks Employee

Hi @Nexusss7 

You can add a comment in the delta live tables, either the MV or the streaming table, in the tag -

 @Dlt.table()

@Dlt.table(

   comment = "Delta live tables comment"

)

Here is the syntax for SQL: https://docs.databricks.com/aws/en/dlt-ref/dlt-sql-ref-create-materialized-view#syntax
Here is the syntax for Python: https://docs.databricks.com/aws/en/dlt-ref/dlt-python-ref-table#syntax

 It is not currently supported to update comments or constraints for Delta Live Tables (DLT)-managed streaming tables outside the pipeline definition code. Any attempt to use standard SQL commands (COMMENT ON TABLEALTER TABLE ADD CONSTRAINT, etc.) on DLT streaming tables results in errors, as Databricks restricts altering DLT streaming tables this way for metadata integrity and pipeline management reasons.

View solution in original post