applying column tags

[ashraf1395]

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

[TakuyaOmi]

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