In less than a decade, Snowflake has emerged as one of the most reliable platforms for data warehousing. Benoit Dageville, Thierry Cruanes and Marcin Żukowski founded the company in July 2012. Snowflake offers data-warehouse-as-a service or cloud-based data storage and analytics services.
Snowflake has been on Amazon S3 since 2014, Microsoft Azure since 2018, and Google Cloud for the last two years. The platform enables data storage, processing, and analytic solutions that are faster, easier to use, and flexible than traditional offerings.
Sign up for your weekly dose of what's up in emerging technology.
In this article, we list free resources and tools to help you learn the nuts & bolts of Snowflake.
Courses & modules
Snowflake Documentation is a go-to resource for users planning to learn Snowflake from scratch. The documentation provides conceptual overviews, tutorials, and a detailed reference for all supported SQL commands, operations and functions.
The module covers:
- System prerequisites and requirements for using Snowflake after setting up your account
- Instructions for connecting to Snowflake using the web interface and other supported clients
- Introduction to the main pages in the web interface and the tasks you can perform on each page
- Step-by-step instructions for using the command-line interface to create a table and database, load data into the table from an external data, and query the table
In this free Udemy course, you will learn about Snowflake Cloud Data Warehouse and its architecture. It will teach you how to build highly scalable, high performance next-gen modern data warehouses. The beginner-friendly course covers the basics of cloud, SaaS, etc.
Check out the free course here.
In this video lesson, Prashant Pandey from Learning Journal unpacks Snowflake Cloud Data Warehouse and the basics of Snowflake, separation of storage and computing techniques, and storage architecture (how storage database tables are stored and accessed when you execute SQL).
The Kahan Data Solutions tutorial walks you through the main components of the Snowflake user interface. The video demo covers the introduction of Snowflake, initial view, worksheets, databases, shares, warehouses, history, accounts and account versus worksheet role, notifications, partner connect, preview app, persisted queries and query history.
Books & guides
Co-authored by William Waddington, Kevin McGinley, Pui Kei Johnston Chu, Gjorgji Georgievski and Dinesh Kulkarni, the book titled ‘Architecting Data-Intensive SaaS Applications: Building Scalable Software with Snowflake‘ covers the entire aspect of data applications and why it matters; things to look out for in modern data platform; building scalable data applications; data processing; and data sharing.
Click here to download the pdf version of the book.
The guide describes five of the most common use cases for startups and companies building data applications and how Snowflake addresses the key challenges when developing applications including.
- Customer 360 Data Apps
- IoT Data Apps
- Application Health and Security Analytics Data Apps
- Machine Learning and Data Science Apps
- Embedded Analytics Data Apps
Click here to download the pdf version of the guide.