topic Re: View column comments in Data Governance

View column comments

isabelgontijo — Wed, 05 Jul 2023 15:46:07 GMT

As a way to minimize storage costs, my team and I want to create views instead of tables in the Gold layer.
We always try to improve the experience of our users by adding comments to the columns. the problem is that views do not inherit comments from their source columns and it is not allowed to add comments to them.

Re: View column comments

luck_az — Tue, 10 Oct 2023 06:34:56 GMT

Hi @isabelgontijo ,had you found any workaround this?You can use create view statement as mentioned below

In addition to this,i am not able to add comment on column which is encrypted and in views we are decrypting that column. I am using create view statement to add comment,

create or replace view catalog_name.schema.table_name (column1 comment 'adfsds',column2 comment 'sdcbhbsjdcjs') comment 'bjsjcds' as select aesdecrypt_function(column1),aesdecrypt_function(column2) from table.

Re: View column comments

DavidThomasDBX — Fri, 17 Oct 2025 18:08:04 GMT

you can use COMMENT ON to set or update the comment on an view

-- View-level comment (use TABLE for views)
COMMENT ON TABLE catalog.schema.my_view IS 'View for user info';

-- Column-level comment on a view
COMMENT ON COLUMN catalog.schema.my_view.name IS 'User display name';

Docs: https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-comment