Connecting to Snowflake & Roles/Users

• Overview of the Ecosystem
• Snowflake Partner Connect
• SnowSQL (CLI Client) – Installation, Configuration and Usage
• Lab – Snowsql Lab & Exercises
• Creation of user Roles in Snowflake
• Creation of Users in Snowflake
• Explanation of Roles and User Management

Virtual Warehouses in Snowflake

• Creation of Virtual Warehouses
• Explanation of Virtual Warehouses Privileges
• Resource Monitors Management and Alerts

Database Objects and Storage in Snowflake

• Creation of Databases and Schema
• Explanation of Databases and Schema Privileges
• Creation Types of Tables
• Explanation of Table Privileges
• Explanation of Snowflake Cache Layer

Snowflake Time Travel and Fail Safe

• Time Travel
• Time Travel considerations
• Fail Safe – Recovery
• Lab – Time Travel and Fail-Safe Lab & Exercises

Zero Copy Cloning in Snowflake

• Explanation of zero copy cloning using different object
• What can be cloned and what cannot

Types of Stages

• Internal Stages
• External Stage

Loading into Snowflake (On-Premises to Cloud)

• Overview of Data Loading/Unloading
• Bulk Data Loading/Unloading from a Local File System
• Loading Using the Web Interface (Limited)
• Querying Data in Staged Files
• Troubleshooting Bulk Data Loads
• Lab – Data Loading / Unloading Lab & Exercises

Loading into Snowflake (Cloud to Cloud)

• AWS Integration Process
• AWS to Snowflake Data Loading

Continuous Data Loading into Snowflake –

• Continuous Data Loading using Snowpipe
• Snowpipe Configuration

Loading Semi Structure Data into Snowflake

• Loading Semi-Structure data from on-premises to cloud
• JSON and XML

Advance Topics

• Streams and Tasks
• Types of SCD’s
• Email Notification creation
• Lab – Streams & Tasks Lab & Exercises

Sharing Data and Views in Snowflake

• Introduction to Data Sharing
• Data Providers
• Data Consumers
• Working with Shares
• Using Secure Objects to Control Data Access
• Configuring a Reader Account
• Managing Reader Accounts
• Lab – Data Sharing Exercises

UDF and Procedures

• Analytical Functions
• User Defined Functions
• Procedures

Performance Tuning

• Query Tuning
• Clustering
• Micro Partitions
• Materialized Views
• Performance Considerations

Masking Policies – Column Level and Row Level

• Column level Masking Policies
• Row level Masking Policies

Working With Dates and Time Stamps

• Dates and time Stamps
• Date and Time Stamp conversions

DBT Topics

• DBT Overview
• Set up DBT Cloud
• Creating connection between DBT and Snowflake
• Data loading into the data warehouse

GitHub Integration

• Version Control
• Data repository set up & connect to DBT cloud
• Fundamentals of DBT cloud IDE
• The process to connect to Repository
• The process to connect to your warehouse

Modes and Materialization

• Learning Objectives – Materializations
• Materialization Overview
• Model Dependencies
• Table type materialization
• Incremental materialization
• Ephemeral materialization

Source and Seed

• Learning Objectives – Seeds and Sources
• Seeds and Sources Overview
• Source Configuration
• Seeds
• Sources
• Source Freshness

Tests

• Tests Overview
• Generic Tests
• Singular Tests
• Create your own singular test

Snapshot

• Snapshots Overview
• Creating a Snapshot
• Incremental strategies

Macros

• What are Macros?
• Creation of Macros

Hooks and Exposures

• Hooks
• Setting up a BI Dashboard in Snowflake and Preset
• Documentation

Pipelines from ADF to Snowflake

• Creation of Azure Blob storage
• ADF Pipeline configuration and set up
• Data Load from Azure Blob to Snowflake using ADF

Realtime Project with Explanation using Snowflake, DBT and ADF

• Unix Basic Commands
• Interview Questions
• Resume Building