Error in Column level tags creation in views via SQL

souravroy1990
New Contributor II

‎01-22-2026 05:15 AM

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.

 

Labels:
0 Kudos

szymon_dybczak
Esteemed Contributor III

‎01-22-2026 05:22 AM

Hi @souravroy1990 ,

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

szymon_dybczak_0-1769088068471.png

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
New Contributor II

‎01-23-2026 05:03 AM - edited ‎01-23-2026 05:10 AM

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?

0 Kudos