Starweaver

Module 2 - Overview and Learning Objectives

Module 2.1 - What is a Data Warehouse?

Module 2.2 - Why Cloud Computing?

Module 2.3 - Snowflake Architecture

Module 2.4 - Virtual Warehouse and Scalability

Module 2.5 - Snowflake Pricing

Module 3 - Overview and Learning Objectives

Module 3.1 - Install Snow CLI

Module 3.2 - Introduction to Stages

Module 3.3 - Types of Internal Stages

Module 3.4 - External Internal Stage Diff

Module 3.5 - Creating Stage Obj (Fileformat Obj)

Module 3.6 - Upload Data Using Snow CLI

Module 3.7 - Download Data Using Snow CLI

Module 3.8 - Using Different Stage Types

Module 3.8A - Taxi Trajectory - Data Load Demo - 1( Preparing Data)

Module 3.8B - Taxi Trajectory - Data Load Demo - 2 (Loading Sample File)

Module 3.8C - Taxi Trajectory - Data Load Demo 3 ( Understanding Copy Command Performance )

Module 3.8D - Taxi Trajectory Copy Command Performance

Module 3.9 - Policy for External Stage

Module 3.10 - Role for External Stage

Module 3.11 - Creating Integration Obj

Module 3.12 - Load from S3 to Snowflake

Module 3.13 - Upload to S3 from Snowflake

Module 3.14 - Snowpipe Demo

Lab 3.1 - Connect Tasks Together

Lab 3.2 - Create a Stream

Lab 3.3 - Create a Task

Lab Submission - Module 3 (Submit all labs for this module AT ONCE, in a single file)

Module 4 - Overview and Learning Objectives

Module 4.1 - Performance Optimisation

Module 4.2 - Dedicated Virtual Warehouse

Module 4.3 - Dedicated Virtual Warehouse Hands On

Module 4.4 - Scale Up Virtual Warehouse

Module 4.5 - Scale Out Virtual Warehouse

Module 4.6 - Auto Scaling

Module 4.7 - Maximize Cache Usage

Module 4.8 - Lab - Maximize Cache Usage

Module 4.9 - Clustering Keys

Module 4.10 - Lab - Clustering Keys

Module 5 - Overview and Learning Objectives

Module 5.1 - Back to the Future with Snowflake

Module 5.2 - Lab - Travel to a Time or Before a Query

Module 5.3 - Undrop Databases, Schemas & tables

Module 5.4 - Fail Safe in Snowflake

Module 5.5 - Lab - Failsafe Storage Usage

Module 5.6 - Zero Copy Cloning

Module 5.7 - Zero Copy Cloning with Time Travel

Module 6 - Overview and Learning Objectives

Module 6.1 - Secure Data Sharing

Module 6.2 - Sharing Views

Module 6.3 - Sharing with a Snowflake User

Module 6.4 - Sharing Who's Compute is Used

Module 6.5 - Sharing Data Always Uptodate

Module 6.6 - What is a Share?

Module 6.7 - Sharing with Non-Snowflake Users

Module 6.8 - Sharing Complete Databases and Schemas

Module 6.9 - Lab - Sharing - Through Web UI

Module 7 - Overview and Learning Objectives

Module 7.1 - Snowflake Approach to Access Control & Key Concepts

Module 7.2 - Out of the Box Snowflake Roles

Module 7.3 - Role Hierarchy in Snowflake

Module 7.4 - ACCOUNTADMIN role

Module 7.5 - Outline of the IAM Hands on Lectures

Lab - Demonstrating ACCOUNTADMIN role

Module 7.6 - SECURITYADMIN role

Lab - Demonstrating SECURITYADMIN role

Module 7.7 - SYSADMIN role

Lab - Demonstrating SYSADMIN role

Lab - Demonstrating use of the Custom Roles

Module 7.8 - Custom Roles

Module 7.9 - Public Role

Assignment - Assign Privileges Through a New Custom Role