topic applying column tags in Data Engineering

applying column tags

ashraf1395 — Mon, 02 Dec 2024 12:02:28 GMT

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

Re: applying column tags

Takuya-Omi — Mon, 02 Dec 2024 13:25:13 GMT

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

Re: applying column tags

ashraf1395 — Tue, 03 Dec 2024 08:02:12 GMT

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.