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

6 responses to “Week 47 – Basic”

  1. ChrisHastie avatar
    ChrisHastie

    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
  2. jamesweakley avatar
    jamesweakley

    No excuse for skipping this one!

    • Solution URL – https://github.com/jamesweakley/frosty_friday/blob/main/Plugin%20packaging.csv
    1. canonicalized avatar

      One excuse could be no Enterprise version

    2. canonicalized avatar

      Thanks for the challenge!

      • Solution URL – https://github.com/canonicalized/FrostyFriday/blob/main/WEEK47.csv
    3. Non-deterministicNorman avatar
      Non-deterministicNorman

      “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
    4. Chris B avatar
      Chris B

      Never done this in the UI before

      • Solution URL – https://github.com/ChrisBo94/FrostyFriday/tree/main

    Leave a Reply