Skip to main content

Data Ingestion with Lakeflow Connect

This course provides a comprehensive introduction to Lakeflow Connect as a scalable and simplified solution for ingesting data into Databricks from a variety of data sources. You will begin by exploring the different types of connectors within Lakeflow Connect (Standard and Managed), learn about various ingestion techniques, including batch, incremental batch, and streaming, and then review the key benefits of Delta tables and the Medallion architecture.


From there, you will gain practical skills to efficiently ingest data from cloud object storage using Lakeflow Connect Standard Connectors with methods such as CREATE TABLE AS (CTAS), COPY INTO, and Auto Loader, along with the benefits and considerations of each approach. You will then learn how to append metadata columns to your bronze level tables during ingestion into the Databricks data intelligence platform. This is followed by working with the rescued data column, which handles records that don’t match the schema of your bronze table, including strategies for managing this rescued data.


The course also introduces techniques for ingesting and flattening semi-structured JSON data, as well as enterprise-grade data ingestion using Lakeflow Connect Managed Connectors.


Finally, learners will explore alternative ingestion strategies, including MERGE INTO operations and leveraging the Databricks Marketplace, equipping you with foundational knowledge to support modern data engineering ingestion.

Skill Level
Associate
Duration
4h
Prerequisites

• Basic understanding of the Databricks Data Intelligence platform, including Databricks Workspaces, Apache Spark, Delta Lake, the Medallion Architecture and Unity Catalog.

• Experience working with various file formats (e.g., Parquet, CSV, JSON, TXT).

• Proficiency in SQL and Python.

• Familiarity with running code in Databricks notebooks.

Outline

  • Introduction to Data Engineering in Databricks

- Data Engineering in Databricks

- What is Lakeflow Connect?

- Delta Lake Review

- Exploring the Lab Environment


  • Cloud Storage Ingestion with LakeFlow Connect Standard Connectors

- Introduction to Data Ingestion from Cloud Storage

- Appending Metadata Columns on Ingest

- Working with the Rescued Data Column

- Ingesting Semi-Structured Data: JSON


  • Enterprise Data Ingestion with LakeFlow Connect Managed Connectors

- Ingesting Enterprise Data into Databricks Overview

- Enterprise Data Ingestion with Lakeflow Connect


  • Ingestion Alternatives

- Ingesting Data with Databricks Marketplace

- Ingesting into Existing Delta Tables

- Data Ingestion with MERGE INTO

Upcoming Public Classes

Date
Time
Your Local Time
Language
Price
Jun 01
01 PM - 05 PM (Europe/London)
-
English
$750.00
Jun 02
09 AM - 01 PM (Australia/Sydney)
-
English
$750.00
Jul 02
08 AM - 12 PM (Asia/Kolkata)
-
English
$750.00
Jul 02
09 AM - 01 PM (America/New_York)
-
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.

See all our registration options

Registration options

Databricks has a delivery method for wherever you are on your learning journey

Runtime

Self-Paced

Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos

Register now

Instructors

Instructor-Led

Public and private courses taught by expert instructors across half-day to two-day courses

Register now

Learning

Blended 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 now

Scale

Skills@Scale

Comprehensive training offering for large scale customers that includes learning elements for every style of learning. Inquire with your account executive for details

Upcoming Public Classes

Generative AI Engineer

Generative AI Engineering with Databricks

This course is aimed at data scientists, machine learning engineers, and other data practitioners who want to build generative AI applications using the latest and most popular frameworks and Databricks capabilities. 

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 in the first three modules. You can access the lecture notebooks in the Vocareum lab environment.

Below, we describe each of the four, four-hour modules included in this course.

Building Retrieval Agents On Databricks: This course provides hands-on training for building retrieval agents on the Databricks Data Intelligence Platform. Participants will learn to parse unstructured documents into structured data, transform and chunk content for retrieval workflows, build vector search solutions for document retrieval, and develop production-ready agents using MLflow and Agent Bricks. The course covers the complete agent lifecycle from document processing through embedding generation, vector indexing, and agent deployment with governance capabilities.

Building Single-Agent Applications on Databricks: This course provides hands-on training for building single-agent applications on the Databricks Data Intelligence Platform. Students will learn to create AI agents that leverage Unity Catalog functions as tools, implement comprehensive tracing and monitoring with MLflow, and deploy agents using both traditional frameworks like LangChain and modern solutions like Agent Bricks. The course covers the complete agent lifecycle from initial tool creation and testing in AI Playground through production deployment with governance, evaluation, and continuous improvement capabilities.

Agent Evaluation on Databricks: This course teaches students how to systematically evaluate AI agents using MLflow's evaluation framework, addressing the unique challenges of non-deterministic AI systems that traditional software testing cannot handle. Students learn to implement various evaluation approaches including built-in judges for common criteria like correctness and safety, guideline judges for business-specific requirements, and custom judges for specialized needs. The course covers both offline evaluation using curated datasets and online production monitoring, with hands-on experience using MLflow's tracing capabilities to understand agent execution patterns and collect human feedback from different stakeholder types. Through practical demonstrations and labs, students develop skills in creating evaluation workflows that drive continuous quality improvements throughout the AI agent development lifecycle.

Generative AI Application Deployment and Monitoring: Ready to learn how to deploy, operationalize, and monitor generative deploying, operationalizing, and monitoring generative AI applications? This module will help you gain skills in the deployment of generative AI applications using tools like Model Serving. We’ll also cover how to operationalize generative AI applications following best practices and recommended architectures. Finally, we’ll discuss the idea of monitoring generative AI applications and their components using Lakehouse Monitoring.

Paid
16h
Lab
instructor-led
Associate

Questions?

If you have any questions, please refer to our Frequently Asked Questions page.