- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2023 07:28 AM
Hi @Kaniz Fatma , Thank you for your response.
Are you saying that "attribute" is nothing but a column name in a table?
I was under impression that attribute is like a tag which we should create before using it against a table's column(s). Sharing my reference below -
https://blog.cellenza.com/en/data/row-and-column-level-security-with-databricks/
In either way, I am confused. I have tried to execute below command as per above databricks documentation, hoping it will create attribute, but its failing. Can you pls give an example how can we create a PII tag/attribute on a set of columns in databricks table?
[In below c_phone is a column containing sensitive data in customers table]
SQL> ALTER TABLE customers ADD ATTRIBUTE pii ON c_phone
Output:
ParseException:
[PARSE_SYNTAX_ERROR] Syntax error at or near 'ATTRIBUTE'(line 1, pos 48)
== SQL ==
ALTER TABLE iotsamples.tpch.customer_events ADD ATTRIBUTE pii ON c_phone
------------------------------------------------^^^