View column comments

isabelgontijo
New Contributor II

‎07-05-2023 08:46 AM

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.

Labels:
0 Kudos

luck_az
Databricks Partner

‎10-09-2023 11:34 PM

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.
0 Kudos

DavidThomasDBX
Databricks Employee
Databricks Employee

‎10-17-2025 11:08 AM

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

0 Kudos