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

• 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.