Build Data Pipelines with Apache Spark Declarative Pipelines
This course introduces users to the essential concepts and skills needed to build data pipelines using Apache Spark™ Declarative Pipelines (SDP) in Databricks for incremental batch or streaming ingestion and processing through multiple streaming tables and materialized views. Designed for data engineers new to Spark Declarative Pipelines, the course provides a comprehensive overview of core components such as incremental data processing, streaming tables, materialized views, and temporary views, highlighting their specific purposes and differences.
Topics covered include:
• Developing and debugging ETL pipelines with the multi-file editor in Spark Declarative Pipelines using SQL (with Python code examples provided)
• How Spark Declarative Pipelines track data dependencies in a pipeline through the pipeline graph
• Configuring pipeline compute resources, data assets, trigger modes, and other advanced options
Next, the course introduces data quality expectations in Spark Declarative Pipelines, guiding users through the process of integrating expectations into pipelines to validate and enforce data integrity. Learners will then explore how to put a pipeline into production, including scheduling options, and enabling pipeline event logging to monitor pipeline performance and health.
Finally, the course covers how to implement Change Data Capture (CDC) using the AUTO CDC INTO syntax within Spark Declarative Pipelines to manage slowly changing dimensions (SCD Type 1 and Type 2), preparing users to integrate CDC into their own pipelines.
Note: Databricks Academy is transitioning to a notebook-based format for classroom sessions within the Databricks environment, discontinuing the use of slide decks for lectures. You can access the lecture notebooks in the Vocareum lab environment.
In this course, the content was developed for participants with these skills/knowledge/abilities:
• Basic understanding of the Databricks Data Intelligence platform, including Databricks Workspaces, Apache Spark, Delta Lake, the Medallion Architecture, Lakeflow Jobs and Unity Catalog.
• Experience ingesting raw data into Delta tables, including using the read_files SQL function to load formats like CSV, JSON, TXT, and Parquet.
• Proficiency in transforming data using SQL, including writing intermediate-level queries and a basic understanding of SQL joins.
• Understanding of ETL concepts, and batch/streaming workflows.
Outline
• Introduction to Data Engineering in Databricks
• Demo: Course Setup and Creating a Pipeline
• Course Project and Dataset Types Overview
• Simplified Pipeline Development and Common Pipeline Settings
• Demo: Developing a Simple Pipeline
• Ensure Data Quality with Expectations
• Demo: Adding Data Quality Expectations
• Lab: Create a Pipeline
• Streaming Joins and Deploying Pipelines to Production
• Demo: Deploying a Pipeline to Production
• Change Data Capture (CDC) Overview
• Demo: Change Data Capture with AUTO CDC with SCD TYPE 1
• Bonus Lab: AUTO CDC INTO with SCD Type 1
Upcoming Public Classes
Date | Time | Your Local Time | Language | Price |
|---|---|---|---|---|
Sep 03 | 01 PM - 05 PM (Australia/Sydney) | - | English | $750.00 |
Sep 03 | 01 PM - 05 PM (Europe/Paris) | - | English | $750.00 |
Sep 03 | 09 AM - 01 PM (America/New_York) | - | English | $750.00 |
Oct 06 | 09 AM - 01 PM (Europe/Paris) | - | English | $750.00 |
Oct 06 | 01 PM - 05 PM (America/New_York) | - | English | $750.00 |
Oct 07 | 09 AM - 01 PM (Asia/Kolkata) | - | English | $750.00 |
Public Class Registration
If your company has purchased success credits or has a learning subscription, please fill out the Training Request form. Otherwise, you can register below.
Private Class Request
If your company is interested in private training, please submit a request.
Registration options
Databricks has a delivery method for wherever you are on your learning journey
Self-Paced
Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos
Register nowInstructor-Led
Public and private courses taught by expert instructors across half-day to two-day courses
Register nowBlended Learning
Self-paced and weekly instructor-led sessions for every style of learner to optimize course completion and knowledge retention. Go to Subscriptions Catalog tab to purchase
Purchase nowSkills@Scale
Comprehensive training offering for large scale customers that includes learning elements for every style of learning. Inquire with your account executive for details

