Week 53 - Data Loading & Staging

One of the quieter releases into public preview is that we can now infer schemas for CSVs. To test this follow the following instructions:

1. Create an internal stage
   
   create stage frosty_stage;
   
2. Create a csv file format
   create or replace file format frosty_csv
field_optionally_enclosed_by = '"'
skip_header = 1;
   
3. PUT the following csv file into that internal stage. Download Here

Now you need to infer the schema and produce the following:

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