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.

Note: Databricks Academy is transitioning from video lectures to a more streamlined PDF format with slides and notes for all self-paced courses. Please note that demo videos will still be available in their original format. We would love to hear your thoughts on this change, so please share your feedback through the course survey at the end. Thank you for being a part of our learning community!

Skill Level

Associate

Duration

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.

Self-Paced

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

Customer registration Partner registration

See all our registration options

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

Instructor-Led

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

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

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

Data Engineer

Get Started with Databricks for Data Engineering

This course introduces the foundational skills needed to perform a basic data engineering workflow on the Databricks Data Intelligence Platform. You will explore the workspace, work with Unity Catalog, and learn the day-to-day building blocks a data engineer uses on Databricks.

The course follows a hands-on path. You start by getting oriented in the workspace, then work through paired Demo and Lab notebooks for each topic. Demos walk you through a concept with the instructor or a guided notebook.

The content covers:

• The Databricks Data Intelligence Platform and how the Databricks workspace, Unity Catalog, and notebooks fit together.

• Creating and managing Delta Lake tables.

• Modifying data with INSERT, UPDATE, and DELETE.

• Exploring version history and time travel on Delta tables.

• Ingesting data with Lakeflow Connect options: CTAS, the Upload UI, and COPY INTO.

• Building a Medallion Architecture pipeline that transforms data through Bronze, Silver, and Gold layers.

• Automating pipelines with Lakeflow Jobs.

• (Bonus) Building a declarative pipeline with Spark Declarative Pipelines.

AI/BI for Data Analysts

This course teaches data analysts how to design, build, publish, and operate AI/BI Dashboards in Databricks. AI/BI Dashboards combine governed Unity Catalog data with interactive visualizations, filters, and Genie integration so business users can explore answers without writing code.

The course follows a single end-to-end build. You start with source tables in Unity Catalog and finish with a published, monitored multi-page dashboard. Along the way you learn how dashboards fit into the broader Databricks AI/BI product family and where Genie, datasets, visualizations, and filters each fit in the workflow.

The content covers:

• AI/BI Dashboard fundamentals and how they relate to Genie and the rest of the Databricks platform.

• Exploring source data in Unity Catalog and designing reusable dashboard datasets with SQL.

• Authoring visualizations (KPIs, trends, breakdowns) and laying out a clean multi-page dashboard.

• Using Genie Code to draft SQL, charts, and filters from natural language prompts.

• Adding filters to make dashboards interactive and responsive to viewer questions.

• Publishing, sharing, and managing permissions so the right people can view and edit the dashboard.

• Running the dashboard in production with scheduled refresh, caching, and usage monitoring.

Note: For SCORM lecture files, please ensure that you close the SCORM window after completing the content. Do not click the ‘Next Lesson’ button, as doing so may prevent the SCORM module from being marked as complete.

Paid & Subscription

Lab

Associate

Get Started with Databricks for Generative AI - Mandarin Chinese

本课程提供对 Mosaic AI 平台的实用入门介绍，重点讲解用于构建和部署生成式 AI 系统的核心组件与功能。学员将了解 Databricks 如何助力开发可扩展的生成式 AI 解决方案，并探索 Mosaic AI 的相关工具，例如 Vector Search、Agent Framework，以及 MLflow 用于模型跟踪与记录的生成式 AI 功能。本课程包含动手实践，内容涵盖构建并评估检索增强生成 (RAG) 管道、部署生成式 AI 智能体，以及利用评估框架优化性能。完成本课程后，学员将掌握使用 Mosaic AI 设计、部署和监控常见生成式 AI 应用所需的技能。

Languages Available: English | 日本語 | Português BR | 한국어

Paid & Subscription

Lab

Onboarding