How to Load data into a Snowflake Database from AWS S3 | Learning Snowflake

In this video, I show you how to load data from a stage that holds data in AWS S3 into a table in Snowflake. This is an end-to-end tutorial, including the troubleshooting I had to do to get my SQL working.

Resources I mention in the video: Link to GitHub with the SQL https://bit.ly/3OeANzy Create table https://bit.ly/3tEJ6eu Create stage https://bit.ly/3XnBAmb Querying data stored in staged files https://bit.ly/3V0zE1n Copy into https://bit.ly/3EFWfdG File format https://bit.ly/3AqPQka

Timestamps: 0:00 Intro 0:29 Setting up 0:44 Comments and overview 1:48 Create a database in Snowflake 3:34 Create a schema in Snowflake 5:17 Create a stage in Snowflake 9:45 View metadata of your stage 11:22 View the files in your stage 12:42 How to query the data in your stage 19:50 File formats in Snowflake 24:33 Preview with a transformation 28:39 Create Table in Snowflake 33:11 Copy data into the table in Snowflake 36:04 A long spell of troubleshooting 42:25 The other way to copy into in Snowflake 45:30 Query our data in Snowflake 46:51 Outro

Join this channel to get access to perks: https://bit.ly/join-tableautim

#snowflakedatabase #analytics #data

Follow me on Twitter: https://twitter.com/TableauTim My recording gear & what's on my desk. https://kit.co/TableauTim/desk-setup My website: https://www.tableautim.com/

My Screen Annotation Tool: https://j.mp/3HWc4Mj My technology Channel: https://j.mp/3F0d28f Share feedback and Suggestions: https://tableautim.canny.io/suggestions ... https://www.youtube.com/watch?v=DV8EbD9s_CM