Week 84 - Data Loading & Staging

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_stageURL = '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!