Snowflake 101 Tutorial: How to load data & scale compute

Step-by-step tutorial on how to load data into Snowflake and how to scale a data warehouse quickly.

0:00 Intro
0:42 Tutorial Dataset
1:03 A brief tour of the Snowflake UI
1:31 Snowflake Data Marketplace
1:35 Create a new warehouse
3:24 How to load data into Snowflake
4:20 How to scale a data warehouse
5:41 Working with semi-structured data like JSON
7:15 Accessing data via secure, live shares
8:25 How to create data visualizations
8:55 Building and sharing dashboards

🍺 If you've learned something new from this video, buy me a coffee to support this channel =)

===============================================================================

Snowflake is a cloud computing–based data cloud company based in Bozeman, Montana. It was founded in July 2012 and was publicly launched in October 2014 after two years in stealth mode.

The firm offers a cloud-based data storage and analytics service, generally termed "data-as-a-service". It allows corporate users to store and analyze data using cloud-based hardware and software. Snowflake services main features are separation of storage and compute, on-the-fly scalable compute, data sharing, data cloning, and third-party tools support in order to handle the demanding needs of growing enterprises. It runs on Amazon S3 since 2014, on Microsoft Azure since 2018 and on the Google Cloud Platform since 2019. The company was ranked first on the Forbes Cloud 100 in 2019. The company's initial public offering raised $3.4 billion in September 2020, one of the largest software IPOs in history.

#snowflake #data #dataengineering #dataengineer #dataengineeringessentials #datawarehouse

[JennyManEngineer]

🚀 If you're wanting to become a data engineer, or you already are one and want to dive deeper into topics like real-time streaming and CDC, this series will help you the best way: