Starweaver

Announcement 001 - You MUST Create a FREE Snowflake account

Labs - Overview

Lab 1 - Load Taxi Trajectory Data

Lab 2 - Transactions

Lab 3 - Unload To Internal Stage

Lab 4 - Load Data to Multiple Tables

Lab 5 - Load Tobacco Data Using Internal Stage - Unguided

Lab 6 - Create Integration Object

Lab 7 - Using Snowflake as Query Engine

Lab 8 - AWS Open Data

Lab 9 - Loading Parquet File

Lab 10 - Finding Bug During Upload to S3

Lab 11 - Loading Json Book Data

Lab 12 - Loading Twitter Data Unstructured

Module 1 - Overview and Learning Objectives

Module 1.1 - Signing up for Snowflake Trial

Module 1.2 - The Snowflake Story

Module 1.3 - Creating our first Database & Table

Module 1.4 - Snowflake Pricing Overview

Assignment - Create, Load & Query a Table

Quiz - Snowflake Overview

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