This might be one of our easiest challenges, yet, but we’re always keen to highlight new functionality as it comes into public preview.
As of May 2023, Snowflake has introduced more data governance functionality into Snowsight in public preview. This means stuff like tags, masking policies and row access policies can be done from the console, without any SQL.
This week’s challenge is about tags and involves no code-writing!! (Did you ever think you’d see this day come?)
Start Up Code
CREATE OR REPLACE TABLE frosty_tag_table ( key int, value string ); CREATE TAG purpose;
Your job is to navigate the Snowsight interface and set the tag for
purpose with the value
Run the below code:
SELECT SYSTEM$GET_TAG('purpose', 'frosty_tag_table', 'table');
And you should see the below:
Download the result, and pop the CSV into the GitHub repo as your submission!
Remember, if you want to participate:
It may be an easy challenge, but it’s still a great way to demonstrate new functionality in the platform. Thanks!
No excuse for skipping this one!
One excuse could be no Enterprise version
Thanks for the challenge!