Snowflake Decoded - Fundamentals and hands on Training

This lecture guides through the signup process for snowflake trial version on the Cloud platform of your choice.

How to download resources such as SQL used in practical lectures.

Some students encounter lower quality of video in the video lecture based on the bandwidth available. This lecture lists down the actions you can take to improve the video quality.

This hands on video guides you through creating our very first snowflake database & our first tables which we will use in the next lecture

This hands on video demonstrates and guides you through loading a simple data set into a table

This lecture describes at a highlevel Snowflake's innovative pricing strategy which charges the customer only for actual storage & compute used

During this hands on lecture we will download and setup the snowflake tools & connectors that we will be using later during the lecture.

In this optional lecture we will explore the concept of a data warehouse and how it is structured & the concept of stage. If you are already aware of the concepts please feel free to skip this lecture.

In this optional lecture we will explore the concept of a cloud computing, why it was needed and the advantages it brings. We will also look at the various flavours of offerings i.e. On-Premise, IaaS, PaaS, SaaS etc.. If you are already aware of the concepts please feel free to skip this lecture.

In this lecture we will explore the concept of multiple virtual warehouses and how it can help with the scalability. We will also create a new virtual warehouse as an example.

A more detailed view of the snow flake pricing strategy explaining the storage pricing, the concept of snowflake credit & their relation with virtual warehouses.

In this lecture we will learn about various ingestion methods that Snowflake supports including  methods such as copy into & snow pipe as well as external tables

In this lecture we will explore the high level steps usually required for managing successful & ongoing data loads into Snowflake

In this lecture we will go through the recommended practices for preparing your files for load. We will also generate a sample data set for loading into Snowflake.

In this lecture we will upload our sample file to an S3 bucket and create a stage on top of the S3 bucket

There are 4 or 5 high level steps that are required to process and load JSON data successfully in Snowflake. In this lecture we will go through those high level steps and follow that up with hands on lab.

We are going to load a sample JSON file into a Snowflake table in this hands on lecture, following the 5 high level steps that we specified in the previous lecture,

Near real time & streaming data is now becoming the norm in data warehouse implementations. Snowpipe is a serverless component that enables loading of such data in a near real time manner. In this lecture we will go through an introduction of Snowpipe.

Loading streaming data via Snowpipe is almost as simple as using the COPY command with a few additional steps. In this lecture we will look at the high level steps that we must undertake to setup a functioning Snowpipe

Let's create a new snow pipe, configure event notification on an S3 bucket and see real time data flow into the table.

Snowflake provides some very simple yet effective approaches to improving performance of queries. In this lecture we will look at 5 ways through which performance can be improved.

Allocating dedicated virtual warehouse is a simple yet effective method to immediately improve performance.  In this lecture we will explore how?

Let's define some dedicated virtual warehouses and see the the concept in action through this hands on lecture.

Up-sizing your virtual warehouse when faced with peak demand is a cost effective way of ensuring top performance. In this lecture we will explore scaling up & down of virtual warehouses to incorporate changing demands.

What-if snowflake would take care of increasing & decreasing the virtual warehouses in your system. Meet "Multi-cluster virtual warehouses", through which you can set your snowflake system to scale out and scale back "automagically" in response to changing demands.

Let's define a multi-cluster virtual warehouse and see the scaling up and down in action.

Query result caching is an effective way of ensuring performance without incurring extra costs. In this lecture we will look at what query caching is and how we can design to take advantage of it.

In this brief lab, we will see how Snowflake can return results without running a query through query caching.

Let's define cluster keys for a very large table and see how does it impact the performance and the amount of data Snowflake has to scan for your queries.

This hands on lecture demonstrates time travel to a specific date & time as well as time travel to a state of data before a specific query was executed.

This hands on lecture explains and demonstrates the unique undrop capability, which allows un-dropping databases, schemas & tables

Let's explore the fail safe feature unique to Snowflake, which provides protection against accidental data loss.

In this hands on lecture we will explore how we can view the storage used by fail safe

This lecture introduces & demonstrates the concept of zero copy cloning of data in Snowflake.

This hands on lecture combines the concept of time travel and zero copy clone to create copies of data as at a specific date/time.

This quiz tests the concepts learnt in the section on zero copy cloning & time travel

In this hands-on lecture we will share a simple table with another snowflake user. We will go through the process of defining & adding tables to a share, sharing it with another account and finally consuming the share using the target account.

Demonstrating who's compute is used when the shared data is queried by the consumer

Demonstrating that the shared data is always up to date for the consumer

Having already performed hands on with sharing, lets explore a bit more on what comprises a snowflake share and what type of objects can be added to a share

In this  lecture we will look at the concept of sharing data with non snowflake users and the high level steps required to shared data with non snowflake users

In this hands-on lecture we will share data with a non-snowflake user. We will go through the process of defining reader accounts, sharing data to those reader accounts and finally configuring and preparing the reader account for use by non-snowflake users.

In this hands on lecture we will go through the steps of sharing entire schemas and entire databases.

Sharing views is just a little bit different from sharing ordinary tables. In this lecture we will go through hands on activities to share a view.

Throughout this section we have used SQL to make configuration changes related to sharing. We can also perform all those activities through the web user interface. In this lecture we will demonstrate some of the sharing actions done using the Web UI.

We will explore Snowflake's approach to Access control i.e. RBAC & DAC and will also understand key concepts such as User, Role, Privileges & Secureable Objects

Snowflake provides certain out of the box roles that come with every Snowflake instance. We will review and understand the significance of these roles in this lecture.

The out of the box roles as well as the custom roles are organised in a role hierarchy to simplify management and access for administrative functions. In this lecture we will investigate how the role hierarchy works.

The most powerful role in a Snowflake instance is the ACCOUNTADMIN role. In this lecture we will look at what are the privileges available to this role and the Do's and Dont's of this role

The hands on activities for this section are organised such that they all link together. In this lecture we will look at the outline of the activities that we will perform in the coming lectures.

In this hands on lecture we will test drive the ACCOUNTADMIN role demonstrating the functions that only an ACCOUNTADMIN role can perform

The SECURITYADMIN role is mainly used for user & role management. In this lecture we will discuss the privileges available to the SECURITYADMIN role.

In this hands on lecture we will test drive the SECURITYADMIN role demonstrating the functions that a SECURITYADMIN role can perform. We will also create a set of users & roles which will be used further in this section.

The SYSADMIN role is used to manage objects such as databases, tables, virtual warehouse.

In this hands on lecture we will test drive the SYSADMIN role demonstrating the functions that a SYSADMIN role can perform. We will create database & warehouse objects & grant access to custom roles

Let's use some of the custom roles that we have previously created and investigate how does the access & privileges work with custom roles.

We have already created some custom roles in the hands on lectures. What are some of the characteristics of custom roles? Let's find out.

The role that is available to every user in a Snowflake system, PUBLIC. We will briefly look at what is the PUBLIC role and how we can use it to manage security & privileges.

This quiz tests the Snowflake concepts learnt through this course