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

[Takuya-Omi · Accepted solution]

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

[ashraf1395 · Accepted solution]

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.