Error in Column level tags creation in views via SQL

[souravroy1990]

Hi,

I'm trying to run this query using SQL and using DBR 17.3 cluster. But I get a syntax error.

ALTER VIEW catalog.schema.view

ALTER COLUMN column_name

SET TAGS (`METADATA` = `xyz`);

But below query works-

SET TAG ON COLUMN catalog.schema.view.column_name

`METADATA` = `xyz`;

Is the first format not supported in databricks SQL or there is any problem with the syntax.

[szymon_dybczak]

Hi @souravroy1990 ,

This syntax is just unsupported. Using ALTER VIEW you can set tag for an entire view:

If you need to set tag on a column you've already found a proper way which is to use SET TAG command:

SET TAG - Azure Databricks - Databricks SQL | Microsoft Learn

[souravroy1990]

Thanks for the clarification @szymon_dybczak. I have a follow-up qn, if I have attached tag to a view column and the same view is associated with a SHARE, will the recipient see the tag in the view i.e. whether view column tags associated to shares are propagated to recipient end?

If metadata such as tag is not propagated to share recipient, does comment propagates to recipient?