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:
Another week, another fun challenge. Thanks for keeping these coming!
As usual, more to this than meets the eye, and a few new skills picked up.
This time with the right link!
Thanks for keeping these up! Not using external tables often at the moment, so this was useful 🙂