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

Resources I mention in the video:

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:

#snowflakedatabase #analytics #data

(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.

[SanteAllegrini]

Hi @Tableau Tim, thank you for the great work you are doing on your channel. During the last week I just started to work my way out on snowflake. As for the file fomats at min 40:00, those are not listed under the schema, you can retrieve them by querying the information schema's view file_formats.

[DrakeCarson-nfgg]

@Tableau Tim do you think you'll ever cover Matillion or any other ETL?

[shashankm]

how can i configure a snowpipe to grab the same filename from an s3 bucket when the file is refreshed and re-uploaded?

[socialawareness]

How can I load my S3 ms SQL databases to snowflake
I have uploaded my database from on premises ms SQL to s3 .

[Ibad_gamer]

Will there be more Contents on Snowflake?