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.
You can follow along using your own Snowflake trial by using Snowflake's full guide available here: quickstarts.snowflake.com/gui...
If you want to get started with Snowflake and need some guidance, schedule time with us here: calendly.com/datalytyx/snowfl...

[@buguannishi]

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

[@Juan-Hdez]

Very useful. Thank you Salome!

[@vinodsagar2412]

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

[@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.

[@hardikkikani2119]

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

[@TheGiulz76]

very clear and useful. Salome fantastic!

[@shobhitbhatnagar9539]

Thanks for the quick introduction.

[@banamali143]

Thanks a lot for sharing this session.

[@muhammadbabadjanov]

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.

[@michealgabriel4692]

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

[@user-ky1ut5kk2p]

Spot on - just what I needed! Thank you

[@ExcelTutorials1]

thanks!

[@mwarcademw]

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

[@mw7365]

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

[@chaychsaeed]

Why my Free Trial does not look like as mentioned in your video. Mine says Worksheet/Dashboard/Data/Marketplace......

[@anajawaid4424]

I am trying my hands on snowflake for the first time and my user interface looks totally different to what you are showing here?, has there been any sort of update as it is a bit confusing to trace stuff in the new UI

[@webcloudcoding9034]

Where can I get Weather data JSON FILE???

[@webcloudcoding9034]

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

[@fabianzamora1174]

how can one know the URL?

[@privateaccount896]

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????

[@privateaccount896]

For anyone, who is having the same Issue, i found the solution: When you Import from the Worksheet, you need to add:
copy into trips from @citibike_trips
file_format=CSV
ON_ERROR = CONTINUE

[@sarthakkhore8012]

Just reading reading reading !

[@skbhati199]

good

[@Dreddwinner]

😎

[@manit77]

It's a MySQL backend.

[@webcloudcoding9034]

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

[@sakumalla158]

where did you find the required data ( the city bike csv files and the json files) to complete tge lab.

[@vio4jesus]

C'mon Snowflake - get some better interesting data sets for these demos, PLEASE

[@Powdermonkey99]

Sorry, This presentation did not work or me, the um and ah & searching for words .

[@tree2rhym]

correct comand to load the data is :
copy into trips from @citibike_trips file_format=CSV PATTERN = '.*\.csv\.gz$' ON_ERROR = SKIP_FILE ;

[@shizariaz2876]

totally worked

[@gantafamily]

Hi, When I am trying to load staged file it is giving me this error: Number of columns in file (1) does not match that of the corresponding table (16), use file format option error_on_column_count_mismatch=false to ignore this error File 'citibike-trips-parquet/2013/06/03/data_01a19496-0601-8b21-003d-9b03003c624a_2106_4_0.snappy.parquet', line 2, character 1 Row 1 starts at line 1, column "TRIPS"["TRIPDURATION":1] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client.
Can someone please help me to resolve this error. Thanks

[@webcloudcoding9034]

Loading data>.not working>showing the error
Found character '\u0006' instead of field delimiter ',' File 'citibike-trips-parquet/2013/06/05/data_01a19496-0601-8b21-003d-9b03003c624a_206_2_0.snappy.parquet', line 323, character 593 Row 323, column "TRIPS"["START_STATION_ID":4] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client.
please help

[@anishyapaul5189]

try to use this command,
copy into trips from @citibike_trips file_format=CSV PATTERN = '.*\.csv\.gz$' ON_ERROR = SKIP_FILE ;