Frosty Friday

Snowflake Weekly Challenges

You are here: Home / Uncategorized / Week 84 – Basic

by on 4 Comments

Week 84 – Basic

You might not have noticed that Snowflake released a sneaky new preview feature that lets you do file movement operation between Snowflake stages.

How?

You better find out.

Here’s your start up code:

CREATE STAGE frosty_aws_stage
  URL = 's3://frostyfridaychallenges/';

LIST @FROSTY_AWS_STAGE/challenge_84/;

CREATE STAGE WEEK84;

You need to run a SQL command that will produce:

Good luck figuring it out!

Reader Interactions

Comments

  2. Nice little challenge to show off the new functionality

    • Solution URL - https://github.com/ChrisHastieIW/Frosty-Friday

  3. As far as I can get the regex expression to work:

    • Solution URL - https://github.com/EmoktayrE/Frosty_Friday_Challenges/blob/main/ffchallenge84.sql

  4. I couldn’t go past this:

    challenge_84/_copy__these__very_specific.txt
    …

    • Solution URL - https://github.com/darko-nimbus/FROSTYFRIDAYCHALLENGES/blob/main/84%20-%20Basic%20-%20Staging.sql

Leave a Reply