Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2024 04:02 AM
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_numberThis the error I got
Column 'loan_number' not found in table accounts_and_customer.bronze.loan_number
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2024 05:25 AM
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');
--------------------------
Takuya Omi (尾美拓哉)
Takuya Omi (尾美拓哉)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-03-2024 12:02 AM
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.