Snowflake programming centers on SQL for data management, while expanding into procedural logic through Snowflake Scripting and advanced data engineering/ML with Snowpark (Python, Java, Scala). Developers can build complex transformations, analytics, and applications directly in the data cloud using worksheets, stored procedures, and UDFs. Key enablers include the VS Code extension, Snowpark APIs, and features like Time Travel, with interviews often focusing on problem-solving skills in the candidate’s chosen language.
Module 1: Introduction to Snowflake
Learning Objectives:
In this Module, trainees will learn how the Snowflake database is different from other
conventional databases like Oracle, MS SQL, and how to work with the Snowflake
platform, A quick introduction to Snowflake, and the creation of a trial account, etc.
Topics:
• How does this differ from typical DBs such as (Oracle …)
• A quick introduction to Snowflake and the creation of a trial account
• Creating warehouse, DB, Schema, and tables
• Accessing different roles and using it
• Working with worksheets
• Understanding different types of accounts
Module 2: Understand Cloud Platforms
Learning Objectives:
This Module will help you understand a concept like how to do bulk loading into
Snowflake through AWS S3, Azure Blob Storage, and GCP Bucket storage. In addition,
you will learn about the Snowflake data warehouse’s architecture and caching.
Topics:
• AWS and understanding of S3 storage
• Snowflake architecture and caching
• AZURE and understanding blob storage
• GCP and understanding Bucket storage
Module 3: Snowflake Cloud Platform Data Loading and Unloading
Learning Objectives:
This Module will help you to understand the UCCE concept like File format, internal and
external storage, copy into usage, and more.
Topics:
• Creating the DOM by using
• File formats
• Internal and external storage
• Copy into usage
• Snowflake internal storage
• Getting data from cloud storage into Snowflake (GCP, AZURE and AWS)
Module 4: Snowpipe
Learning Objectives:
In this Module, you will learn a detailed overview of Snowpipe, Continuous loading, Bulk
loading, and Commands like PUT, and GET.
Topics:
• Accessing Snowpipe
• PUT and GET commands
• Bulk loading from cloud storage
• Continuous loading
Module 5: Partner Connect with Snowflake
Learning Objectives:
In this Module, you will learn the use cases of Snowflake python connectors and BI
Connectors.
Topics:
• Snowflake Connector and use cases Python
• BI connectors use cases
• Other connectors hands-on
Module 6: Snowflake Cloud Data Platform’s JSON and Semi-structured Data
Handling
Learning Objectives:
This Module helps you master the concepts like variant data type, file format options,
and creating stages. You will also learn how to load the semi-structured data and how to
access JSON files through the “select” statement.
Topics:
• Variant Datatype
• File format options
• Creating stages
• Loading JSON semi-structured data into SF tables
• Accessing JSON with select statement
Module 7: Scheduling with Snowflake
Learning Objectives:
This Module concept like creating tasks, streams, and accessing procedures with the
tasks. Also, you will learn how to schedule the tasks and how to automate the loading
In this Module, you will learn how to retrieve historical data, and enable or disable time
travel. You will also study the data retention period and cloning through time travel.
Topics:
• Introduction to Time Travel
• Querying Historical Data
• Enabling and Disabling Time Travel
• Data Retention Period
• Using Time Travel to Clone (Databases, Schemas, and Tables Only)
Module 8: Clustering and Performance techniques
Learning Objectives:
This Module discusses topics like creating multi-clusters on large tables and
performance techniques in the Snowflake database.
Topics:
• Creating multi-clusters on large tables
