Skip to Scheduled Dates
Course Overview
This three-day course equips you with the expertise to integrate Python within the Snowflake AI Data Cloud. You will design and deploy high-performance data engineering solutions utilizing the Snowflake Python API and Snowpark. The course combines lectures, demos, interactive labs, and in-depth discussions to ensure a comprehensive learning experience.
Who Should Attend
- Data Engineers
- Data Scientists
- Data Application Developers
- Database Architects
- Database Administrators
- Data Analysts with programming experience
Course Objectives
- Explain the distinctive features of Snowflake’s platform and its integration with Python.
- Configure and establish secure connections to Snowflake using the Snowpark Session object.
- Design, code, and deploy custom Python functions within Snowflake as User Defined Functions (UDFs).
- Create and encapsulate reusable logic using Stored Procedures.
- Organize and manage automated workflows with Snowflake tasks and Directed Acyclic Graphs (DAGs).
- Automate recurring data tasks using Snowflake’s task scheduling capabilities.
- Monitor and debug data processes while implementing observability techniques in Snowflake and Python environments.
- Leverage Anaconda integration in Snowflake to enhance data solutions with specialized Python libraries.
Course Outline
1 - Snowflake AI Data Cloud
- Using Snowsight
- Snowflake Structure
2 - Snowflake Python API
- Python API Concepts
- Core Classes and Operations
3 - Role-based Access Control (RBAC) Overview
4 - Data Protection Features
5 - Metadata and Caching in Snowflake
- Metadata
- Query Result Cache
- Data Cache
6 - Introduction to the Data Engineering Workflow
7 - Supporting Platform Features
- Snowpark
- Snowflake Connector for Python
- Drivers, Clients, and Connectors Overview
- Snowflake Notebook API
8 - Ingestion
- Data Loading Objects
- Transformations and Copy Options
- Bulk vs. Continuous Data Loading Approaches
- Semi-structured Data
- Snowpipe
- Snowflake Data Loading Best Practices
- Loading Semi-structured Data
9 - Transformation
- Dynamic Tables
- Creating and Managing Streams
- UDFs and Stored Procedures
- External Network Access
- Transformations with Unstructured Data
10 - Orchestration
- Creating Tasks
- Creating a DAG
11 - Delivery
12 - Management and Observability
- Observability on Snowflake
- Outbound Notifications
- Snowflake Alerts
- Data Pipeline Logging