Snowflake Python Data Engineering Training

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

  • Cloning
  • Time Travel

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

  • Streamlit
  • Data Sharing

12 - Management and Observability

  • Observability on Snowflake
  • Outbound Notifications
  • Snowflake Alerts
  • Data Pipeline Logging

Class Dates & Times

Class times are listed Eastern time

This is a 3-day class

Price : $3,000.00

D&H Price : $3,000.00

Class dates not listed.
Please contact us for available dates and times.