applying column tags

ashraf1395
Honored Contributor
Can anyone tell me the correct syntax for applying a column tag to a specific table
These are what I tried
 

 

 ALTER TABLE accounts_and_customer.bronze.BB1123_loans ALTER/CHANGE COLUMN loan_number SET TAGS ('classification' = 'confidential')<p>I got this error<li-code lang="markup">Column 'loan_number' not found in table accounts_and_customer.bronze.loan_number

This the error I got

Column 'loan_number' not found in table accounts_and_customer.bronze.loan_number

 

Takuya-Omi
Valued Contributor III

Hi, @ashraf1395 

I tried the following code, and it worked well for me. Does this align with what you’re trying to achieve?

%sql
ALTER TABLE accounts_and_customer.bronze.BB1123_loans ALTER COLUMN loan_number SET TAGS ('classification' = 'confidential');

TakuyaOmi_0-1733145906172.png

 

--------------------------
Takuya Omi (尾美拓哉)

View solution in original post

ashraf1395
Honored Contributor

Hi there @Takuya-Omi ,
I agree. The syntax was correct. I was facing some completely different problems with schemas and I solved it. Thanks though. Or I would have spent hours banging my head to find the reason for error.

View solution in original post