Week 35 - External Connectivity

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

Take the below code:

create stage external_table_stageurl = '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_soldfrom frosty_etorder 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