Week 47 – Basic

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?)

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:

1. Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘
2. Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
3. Post the URL in the comments of the challenge