1

A quick question please -

Is there a good way of storing classification tags in Snowflake at table/column level? For example, tag a column with PII flag.

I then like to read these tags through JDBC API.

Appreciate your thoughts.

Noor Basha Shaik
  • 35
  • 5
  • To my knowledge there is no built-in tagging with Snowflake. You could build the metadata yourself in your own table structure, or perhaps take advantage of [comments](https://docs.snowflake.com/en/sql-reference/sql/comment.html) (Comments are a SQL ANSI standard). Depending on how you are planning on using this metadata after it's stored would determine which direction you want to go. If you wanted to obfuscate to certain users in the future, then your own metadata tables would be the way to go. – JNevill Jul 06 '21 at 21:32
  • Hi, Can you please let me know how I can specify that a column is of PII type in the table structure itself without using the COMMENT keyword? I would be reading comments & the PII tags through JDBC API and store them in Collibra for Data Governance purposes. Currently, I am able to store comments. Now, PII tags are essential to protect the data through masking policies in Immuta. – Noor Basha Shaik Jul 07 '21 at 06:53

2 Answers2

0

Object tagging is one of the new features announced at the Snowflake Summit in June. It is currently in Private Preview.

Eda Johnson
  • 91
  • 1
0

I think Currently we have only one option of using the COMMENT for such need but this is also not that much flexible. We may need to wait for snowflake to enable the classification and tagging feature for Public preview to solve this c

user16539337
  • 1