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