Snowflake

What is snowflake

Snowflake has emerged as the only cloud data warehouse solution powering the data cloud, allowing businesses to build best-in-class analytical environments with unparalleled power, elasticity, and customization – all at a fraction of the cost. Learning Snowflake is simple and can bring exceptional opportunities for career advancement. This course will teach you all you need to know about Snowflake as well as how to get started with this data platform.

Snowflake course content

Snowflake course content is designed to help you acquire hands-on skills needed for Snowflake Data Analyst and Data Engineer Job Roles and also includes the topics required to clear the Snowflake Certification exams.

Snowflake Architecture and Overview

1. Snowflake Overview
2. Architecture
3. How to use the Snowflake UI & ecosystem

Introduction to Cloud

1. What is Cloud
2. Different Cloud Vendors
3. Advantages of Cloud over On-Premise

Introduction to Data Warehousing Concepts

1. What is a Data Warehouse, and Why do we need a Data Warehouse?
2. Database Vs Data Warehouse.
3. Data Warehouse Architecture
4. OLTP Vs OLAP
5. What is ETL

Introduction to Snowflake

1. How different from traditional DB
2. Quick start to the snowflake and accessing trial account
3. Creating warehouse, DB, Schema, and tables
4. Accessing different roles and using it
5. Working with worksheets
6. Understanding different type of accounts

Understand Cloud platforms

1. AWS and understanding S3 storage
2. Snowflake architecture and caching
3. AZURE and understanding blob storage
4. GCP and understanding Bucket storage

Data Loading and Unloading

1. File formats
2. Internal and external storage
3. Internal and external stage
4. Copy into usage
5. Snowflake internal storage
6. Accessing Cloud storage data into Snowflake (GCP, AZURE and AWS)
7. Data unloading

SnowPipe

1. Accessing Snowpipe
2. PUT and GET commands
3. Bulk loading from cloud storage
4. Continuous loading

Partner connect with snowflake

1. Snowflake Connector and use cases Python
2. BI connectors use cases
3. Other connectors hands-on

Handling JSON and Semi structured data

1. Variant Data Type
2. File format options
3. Creating stages
4. Loading JSON semi-structured data into SF tables
5. Accessing JSON with select statement

Scheduling with Snowflake

1. Creating Tasks
2. Streams
3. Accessing procedures with tasks
4. Scheduling as per time with Different time zones
5. Automate loading process Daily and Weekly

Secure Data sharing

1. Usage of sharing data
2. Sharing data with different accounts
3. Sharing data with non-SF accounts using reader accounts
4. Importance of reader accounts
5. Privileges in data sharing
6. Challenges with cross-region sharing and understanding replication
7. Connecting shared objects with BI tools
8. Limitations with Data sharing

Cloning

1. Limitations with Data sharing
2. Access Control Privileges for Cloned Objects
3. Cloning and Snowflake Objects
4. Impact of DDL on Cloning
5. Impact of DML and Data Retention on Cloning

Time travel & Failsafe

1. Introduction to Time Travel
2. Querying Historical Data
3. Enabling and Disabling Time Travel
4. Data Retention Period
5. Cloning Using Time Travel (Databases, Schemas, and Tables Only)

Query Caching, Clustering, and Performance techniques

1. Creating multi-users on large tables
2. Performance techniques
3. Result set cache
4. Metadata cache
5. Query data cache
6. Best practices of using caching for performance and cost optimization

Advanced Topics

1. Error Handling and Validations
2. Snowflake Pricing model and selecting best Edition and Calculation of Credits usage
3. Resource Monitoring
4. Data Masking
5. Partitioning and Clustering in snowflake
6. Materialized View and Normal View
7. Integration with Python
8. Integration with AWS, Azure and Google
9. Cloud Best Practices to follow