Snowflake: A to Z including Snowpark

Description:

Embrace the data revolution with 'Snowflake: A to Z Including Snowpark Training.' In the era of Big Data and expanding cloud environments, Snowflake, a cloud-based Software as a Service (SaaS) platform, provides the solution for data warehousing and advanced analytics. This comprehensive course offers a deep understanding of Snowflake's capabilities, merging theory with hands-on experience on the platform. Additionally, students master Snowpark API, a Python-based tool from Snowflake, for effective data engineering. Prepare to navigate the world of data with confidence, and stay ahead in the ever-evolving landscape of cloud-based data management.

Duration: 4 days

Course Code:  BDT299

Learning Objectives:

After this course, you will be able to:

• Snowflake Architecture & Features
• Data Ingestion in Snowflake: Structured & Unstructured Data
• Snowflake: Data Sharing and Continuous Data Protection
• Tasks & Procedures in Snowflake
• Caching and Clustering in Snowflake
• Using Snowpark API (using Python)

Basic understanding of relational databases and using SQL, Python

This course is designed for Software Developers, DBA, Software Architects, Quality Assurance Engineers, BI Professionals

Course Outline:

1. Snowflake Architecture

• Snowflake and Cloud Environments
• Three Tier architecture
• Understanding Data Storage, Query Processing and Cloud Services
• Snowflake UI – Query pane, Results Pane and Object Pane
• Lab: Examine Snowflake UI

2. Snowflake Features

• Standard and Extended SQL
• Tools and Interfaces
• Connectivity
• Understanding Roles Hierarchies
• Lab: Roles

3. Structured Data Ingestion

• Database objects for Structured Data Ingestion
• Stage and File Objects
• Bulk load from Cloud Storage
• Local Storage: Load and Unload data
• Querying ingested data
• Lab: Multiple Data Ingestion Labs

4. Unstructured Data Ingestion

• Database objects for Un-structured Data Ingestion
• Ingesting JSON data
• Querying Data
• Lab: JSON data ingestion

5. Data Sharing and Continuous Data Protection

• What is a Data Share?
• Data Providers and Consumers
• Share Data with Snowflake & Non-snowflake users
• Understanding Time Travel & Fail-safe
• Zero copy cloning
• Cloning Database, Schema, Tables
• Labs: Multiple Labs on these topics

6. Tasks & Procedures

• Understanding Tasks, Stored Procedures and Functions
• Tasks and Scheduling
• Using Stream Objects
• Streams and Tasks
• Labs: Using Tasks

7. Data Caching & Clustering

• Table Types
• Snowflake Caching Features
• Understanding Clustering
• Clustering keys
• Labs: Caching and Clustering labs

8. Snowpark API (Python)

• Read and write operations
• Understanding how Snowpark API works
• Read and load data from Amazon S3 into snowflake
• Should and should not do with Snowpark API
• Create Snowpark UDF (User Defined Function)
• Leverage third-party Python libraries
• Labs: on topics described above

Training material provided: Yes (Digital format)

Hands-on Lab: Instructions will be provided to set up a free tier snowflake account.