|
Data Warehouse Brushup
|
|
|
|
Snowflake + dbt DWH Session
|
|
|
|
DAY 1- Q&A-DWH
|
|
|
|
Data_Warehouse_CloudLearningYard
|
|
|
Snowflake Introduction & Core Concepts
|
|
|
|
Snowflake Introduction & Architecture
|
|
|
|
SnowSight UI & Pricing Overview
|
|
|
|
SNOWFLAKE_intorduction.pptx
|
|
|
|
First Quiz to evaluate Architecture fundamentals
|
|
|
|
Snowflake + dbt Snowflake Introduction + Architecture
|
|
|
|
Snowflake + dbt DAY 2 Q&A
|
|
|
|
Virtual Warehouse & Gen 2 Warehouses
|
|
|
|
Micro Partition & Storage layer
|
|
|
|
Snowflake + dbt bootcamp-DAY 3 Q&A
|
|
|
|
Snowflake + dbt bootcamp ( UI, Pricing & Virtual Warehouse)
|
|
|
|
Query Execution flow
|
|
|
|
Caching in Details
|
|
|
|
Snowflake + dbt bootcamp (Caching, Query execution flow & UI data ingestion)
|
|
|
|
Snowflake + dbt bootcamp-DAY 4 Q&A
|
|
|
|
Caching
|
|
|
Data loading in Details
|
|
|
|
File formats & mandatory Parameters
|
|
|
|
Stages & its Type
|
|
|
|
UI Data loading
|
|
|
|
Complete Guide on SnowSQL
|
|
|
|
COPY INTO <TABLE>/<LOCATION>
|
|
|
|
Quiz 2 (Data loading)
|
|
|
|
Snowflake + dbt bootcamp (Stages, SnowSQl & COPY INTO)
|
|
|
|
Snowflake + dbt bootcamp-Day 5 Q& A
|
|
|
|
Snowflake Assignment
|
|
|
|
SCRIPT DAY5
|
|
|
Continuous Data Integration
|
|
|
|
External Stages : Creation & configuration
|
|
|
|
Snowflake + dbt bootcamp-DAY 6 (Tables & AWS Data ingestion)
|
|
|
|
Snowflake + dbt bootcamp-DAY 6 Q&A
|
|
|
|
AWS ingestion
|
|
|
|
AWS Data Integration
|
|
|
|
Azure Data load (Recorded Session)
|
|
|
|
GCS Data Integration (Recorded Session)
|
|
|
|
Snowflake + dbt bootcamp, SNOWPIPE & Infer schema
|
|
|
|
External Table
|
|
|
|
Tables_DDL
|
|
|
|
Assignement Snowpipe_AWS ingestion
|
|
|
|
Snowflake + dbt bootcamp Q&A DAY7
|
|
|
|
Snowpipe Load
|
|
|
|
DAY 7 DDL
|
|
|
Micro Partition & Clustering
|
|
|
|
Snowflake + dbt bootcamp DAY 7( MP & Clustering)
|
|
|
|
DAY 8 MP & Clustering Q&A
|
|
|
Data Recovery & Data Pipelines
|
|
|
|
Time travel
|
|
|
|
Zero Copy clone
|
|
|
|
Fail Safe
|
|
|
|
Flatten- JSON/XML data
|
|
|
|
Quiz 3
|
|
|
|
Snowflake + dbt bootcamp-DAY 9( Time Travel & Zero Copy clone)
|
|
|
|
Snowflake + dbt bootcamp-DAY 9(Q&A)
|
|
|
|
Time travel & Zero copy clone
|
|
|
|
SNOWFLAKE TIME TRAVEL
|
|
|
RBAC & Internals
|
|
|
|
System Roles & RBAC
|
|
|
|
Create Custom Roles & Users
|
|
|
|
Implement Data security using Dynamic Masking
|
|
|
|
Data Sharing
|
|
|
|
Account Usage vs Information Schema
|
|
|
|
Resource Monitors & Budgets
|
|
|
|
Snowflake + dbt bootcamp-DAY 10 (RBAC & Dynamic Masking)
|
|
|
|
VIEWS & MATERIALIZED VIEWS
|
|
|
|
Snowflake + dbt bootcamp-DAY 10 (Views)
|
|
|
|
Views DDL
|
|
|
Continuous Data Pipeline & ETL flow
|
|
|
|
Snowpipe
|
|
|
|
CDC using Streams
|
|
|
|
Automate your workflow using TASK & TASK TREE
|
|
|
|
Snowpipe/Task Error Integration (Recorded Session)
|
|
|
|
SCD type 1 & 2 Implementation (Recorded Session)
|
|
|
|
Snowsight Dashboards
|
|
|
Snowflake Advanced chapter-1
|
|
|
|
Directory Tables
|
|
|
|
Dynamic Tables
|
|
|
|
Event Tables(Recorded Session)
|
|
|
|
Hybrid Tables (Recorded Session)
|
|
|
|
Iceberg Tables
|
|
|
|
UDF & Stored Procedure for Dynamic SQL
|
|
|
|
API Data Integration ( Recorded Session)
|
|
|
Snowflake Advanced Chapter-2
|
|
|
|
Getting Start with Snowpark
|
|
|
|
Hands on Project with Snowpark
|
|
|
|
Build your firs app with Streamlit
|
|
|
|
Data engineering with Snowflake Notebooks
|
|
|
Snowflake Advanced Chapter-3
|
|
|
|
GIT Integration with Notebook & Worksheets
|
|
|
|
Performance optimization in depth
|
|
|
|
Query Profile, QAS, SOS etc
|
|
|
|
Reporting using Snowflake Dashboards
|
|
|
Snowflake Cortex
|
|
|
|
Cortex Introductions
|
|
|
|
Cortex LLM functions
|
|
|
|
Document AI
|
|
|
|
Cortex Search Service
|
|
|
|
Snowconvert
|
|
|
DBT- Introduction & Configuration
|
|
|
|
DBT fitment into ETL world
|
|
|
|
DBT Core /Cloud setup
|
|
|
|
DBT configs & YAML
|
|
|
DBT -Models
|
|
|
|
DBT Model & Sources
|
|
|
|
DBT Materialization
|
|
|
|
DBT seeds
|
|
|
|
CLI commands
|
|
|
DBT - Advanced
|
|
|
|
DBT Jinja's & Macros
|
|
|
|
DBT Hooks
|
|
|
|
DBT Snapshots
|
|
|
|
DBT Variables
|
|
|
DBT Testing & Documentation
|
|
|
|
dbt tests
|
|
|
|
DBT custom tests
|
|
|
|
Send Email using DBT
|
|
|
Data Engineering Projects
|
|
|
End to End Data Migration Project using Matillion
|
|