Zero to Snowflake in 58 minutes

In this video, we'll walk you through the 'Getting Started with Snowflake - Zero to Snowflake' entry-level guide in only 58 minutes.

Salome will demonstrate how easy it is to

*prepare your lab environment
*load data
*run queries
*clone data
*work with semi-structured data
*time travel *set up role-based access controls
*get data from the Data Marketplace
*and reset your environment

They say it will take 90 minutes, but she'll get this done in 58.

[buguannishi]

Thank you for sharing this introduction about Snowlake! Your presentation is precise and clear.

[Urban]

Summary:
Setup snowflake
Db
File type
Stage (external)
Create table
Import data
Query data
Create view
Aggregate data
Join two tables
Clone table
Rollback: mistaken data update fix
42:40 using roles
50:09 shares
52:42 data marketplace
55:55 reset account

[TheGiulz]

very clear and useful. Salome fantastic!

[SIBUK]

Dude!! You legend. I had this problem on a Ruby on Rails app and it totally fixed it for on that also. Thank you.

[vinodsagar]

Amazing video !.. I am new to snowflake, saw many videos in youtube couldn't able to match there level, after seeing this video I am feeling even I can learn snowflake and level of confidence is getting higher, thanks a lot for you support.... wish you all the best, keep going

[gm]

Thanks for the definition of "work sh*ts"! Much appreciated 😅

[michealgabriel]

Great video, thanks for sharing. Looks like I need to learn some SQL.

[hardikkikani]

Great video. Can you make a video to understand the query execution plan and using it to improve query performance?

[lgolsen]

So, you proved (once again) that the weather improves if we can persuade more people to ride a bike 😜

Seriously: great ‘basic’ video….

[eco]

Note on creating external stage: Make sure to include the final forward slash (/) at the end of the URL or you will encounter errors later when loading data from the bucket.

[ElaineSmith-wm]

Spot on - just what I needed! Thank you

[mw]

The Citibike data was found in the aws public url, just follow everything she said to load the data.

[banamali]

Thanks a lot for sharing this session.

[chaychsaeed]

Why my Free Trial does not look like as mentioned in your video. Mine says

[mwarcademw]

where can i find the queries to execute (in text) for pratice ?

[privateaccount]

Hi,

By getting the file with the Stage like in the Video, i Receive a file, which includes csv, json and parquet datasets. This is making a Problem singe the Stage is using the file format which is csv….does anyone know, Why the dataset is not only csv or does someone had the same issue????

[TK-lvff]

I signed up for a free trial, and my snowflake UI looks completely different than hers...

[webcloudcoding]

Where can I get Weather data JSON FILE???

[webcloudcoding]

I did this LAB successfully. with new UI-snowlight.

[webcloudcoding]

Where can I find citibike data csv file? please..