Frosty Friday

Snowflake Weekly Challenges

You are here: Home / Uncategorized / Week 35 – Intermediate

by on 4 Comments

Week 35 – Intermediate

Want to learn how to create external tables? Or if you already know, want to show off the fact?

Take the below code:

Code

create stage external_table_stage
	url = 's3://frostyfridaychallenges/challenge_35/';

Create an external table called frosty_et from the above stage and when you run the following query:

select sale_month,
	id,
        drug_name,
        amount_sold
from frosty_et
order by amount_sold;

It should look like the below:

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

Reader Interactions

Comments

  1. Another week, another fun challenge. Thanks for keeping these coming!

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

  2. As usual, more to this than meets the eye, and a few new skills picked up.

    • Solution URL - https://frostyfriday.org/2023/02/24/week-35-intermediate/

    • This time with the right link!

      • Solution URL - https://github.com/apd-jlaird/frosty-friday/blob/main/week_35/ff_week_35.sql

  3. Thanks for keeping these up! Not using external tables often at the moment, so this was useful 🙂

    • Solution URL - https://github.com/dsmdavid/frostyfridays-sf/blob/main/macros/init_for_challenge_35.sql

Leave a Reply