by 
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 frosty_tag_table to purpose with the value FrostyFriday
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:
- Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘
- Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
- Post the URL in the comments of the challenge
6 responses to “Week 47 – Basic”
-
It may be an easy challenge, but it’s still a great way to demonstrate new functionality in the platform. Thanks!
- Solution URL – https://github.com/ChrisHastieIW/Frosty-Friday
-
No excuse for skipping this one!
- Solution URL – https://github.com/jamesweakley/frosty_friday/blob/main/Plugin%20packaging.csv
-
Thanks for the challenge!
- Solution URL – https://github.com/canonicalized/FrostyFriday/blob/main/WEEK47.csv
-
“One excuse could be no Enterprise version” or a reason to upgrade from Standard edition
- Solution URL – https://github.com/NMangera/frosty_friday/blob/main/week%2047%20-%20basic/ff_wk47%20-tags%20(1).csv
-
Never done this in the UI before
- Solution URL – https://github.com/ChrisBo94/FrostyFriday/tree/main
Leave a Reply
You must be logged in to post a comment.