Snowflake Python Data Engineering Training

Price
$3,000.00 USD

Duration
3 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information
Download Course Details
Course Details Only
Course Details & Schedule
Skip to Class 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.

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.

Who Should Attend?

  • Data Engineers
  • Data Scientists
  • Data Application Developers
  • Database Architects
  • Database Administrators
  • Data Analysts with programming experience
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Course Prerequisites

  • Basic Python coding proficiency.
  • Familiarity with basic SQL

Agenda

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
 

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.

CourseID: 3606106E
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons