Snowflake for Developers

This lecture provides users with high level concepts in distributed computing and how Snowflake utilizes those concepts to create its own unique architecture. The lecture introduces the three architectural layers of Snowflake Cloud Data Warehouse namely

1. Data Storage

2. Virtual Warehouse

3. Cloud Services

This lecture will review the snowflake Data storage architecture.

It will develop understanding of:

1. Blob Storage – AWS's S3 Capabilities and its influence on Snowflake's design decisions

2. How data is stored in a table structure

3. Concept of clustering

This lecture will review Snowflake’s Virtual Warehouse Architectural Concepts. The lecture will take a deep dive into concepts like

1. Caching mechanism of Snowflake

2. File Stealing process

3. Execution engine capabilities

This lecture will review Snowflake’s 3rd layer in its architecture – The Cloud Services.

1. We will understand the functions of Cloud Services

2. Learn about query management.

3. Take a deep dive into concurrency control

4. We will understanding the concept of query pruning.

A brief description of content of sections here

Quick walk through on creating a trial account with snowflake.

Description of various Editions available within Snowflake and their differences. Also discusses Snowflake's Pricing model which is separate storage and compute

Covers basics of Snowflake's features that are either different or new concepts from traditional databases or data warehouse. Covers topics like

1. Stages

2. File Formats

3. Sequences

4. Security Basics

This web interface walkthrough covers the basics of Snowflake's Web User Interface. We describe functions like Search, Admin section, monitoring, and features like marketplace.

In this comprehensive lesson, you will learn everything you need to know about Snowflake Virtual Warehouses, a fundamental component of Snowflake's architecture. This course is designed to guide you through the key aspects of virtual warehouses, including their types, configuration, and optimization. You'll gain hands-on experience in setting up virtual warehouses, understanding their cost implications, and optimizing them for various workloads. Whether you're handling small queries or large-scale data processing, this lesson will equip you with the knowledge to make the most of your Snowflake environment.

What you will learn:

1. Snowflake Virtual Warehouse

2. Compute and Storage

3. Scaling Modes

4. Multi-cluster

5. Auto Suspend

6. Auto Resume

7. Cost Optimization

8. Query Acceleration

9. Scaling Up vs. Scaling Out

10. Snowpark Optimized

This final lecture in Snowflake Web user interface takes a deep dive into the database function and digs deeper into Databases, Schema, Tables, creating a table and loading data via Stage etc..

This Lecture Helps understand various options to load data into snowflake. It also provides a demo using python code to automated data loading.

This lecture helps understand Snowflake's Transformation capability while loading data and once data is in snowflake. It highlights Snowflake's Transform (T) capabilities in the  Extract Load and Transform (ELT) realm of things. Demo includes transformation during load and after load and JSON object capabilities.

This Lecture provides in depth understanding of how to consume data from Snowflake for Analytical other purposes. Demo includes usage of Purpose Built Snowflake Connectors, JDBC Drivers, ODBC Drivers etc..

Describes Snowflake's Snowpipes - Its auto ingestion mechanism for data stored in cloud storage and ingestion pipeline as soon as the file hits the source location.

This Lecture highlights Snowflake's Time Travel Capabilities

Provides Introduction to Snowflake CLI called SnowSQL

This lecture explains the Snowflake Secured Views, why they are essential, and how to use them.

This lecture is a complete overview of Snowflake Data Sharing concepts. It discusses the importance of data sharing, its limitations, and other restrictions. It explains how to set data sharing up and running and its top Use-cases. The lecture also talks about reader accounts and their use with data sharing.

This section introduces students to the Snowpark capability within Snowflake. Essentially allowing users to interact with Snowflake using tools like python, java and scala. i.e alternative technologies other than SQL.

We will do some test data setup for upcoming lectures.

This lecture will take a look at Python worksheets and How Snowflake is integrated with python.

In this lecture, we accept the terms of Anaconda and proceed to work more with Python tables.

This lecture was recorded with a classic console, which is being replaced by Snowflake's new console. It is made available in the Archive section if anyone wants to refer to it.

The first part of the web interface walkthrough covers the basics of Snowflake's Web User Interface. This part covers functions like Help, Partner, and Profile management.

This lecture was recorded with a classic console, which is being replaced by Snowflake's new console. It is made available in the Archive section if anyone wants to refer to it. The Second part in the Web user interface walk through covers more detail coverage on features and functions like History, Worksheets, Warehouses and Shares