databricks Platform · Updated Jul 10, 2026

SharePoint Connector in Lakeflow Connect

Ingest files and structured data from SharePoint into Databricks.

What it does

The SharePoint connector in Lakeflow Connect enables users to ingest unstructured files as binary data and parse structured formats like CSV, JSON, XML, and Excel into Delta tables. It supports incremental ingestion and schema evolution, allowing for flexible data management. Users can authenticate using various OAuth methods, and workspace admins can manage access to this feature.

Why it matters

This feature enhances data ingestion capabilities for organizations using SharePoint, allowing for seamless integration of data into Databricks for analysis and transformation. It improves productivity by enabling users to automate data workflows and ensures governance through Unity Catalog support. This is particularly beneficial for data teams looking to streamline their data pipelines and enhance data accessibility.

Key capabilities

File Ingestion

Ingest unstructured files and parse structured formats into Delta tables.

Incremental Ingestion

Supports incremental data updates to keep your datasets current.

Schema Evolution

Allows for schema changes during data ingestion, configurable via schema evolution mode.

OAuth Authentication

Supports multiple OAuth authentication methods for secure access.

Prerequisites

Workspace admin access to configure SharePoint authentication.

Knowledge of the chosen authentication method for connection setup.

Understanding of user personas for pipeline creation.

Recommended use cases

Automating data ingestion from SharePoint for reporting.Transforming SharePoint data for analytics in Databricks.Integrating SharePoint files into data pipelines for downstream processing.

Limitations · remember

!UI-based pipeline authoring is not supported.

!Basic authentication methods (username/password, API key, service account JSON key) are not supported.

!SCD type 2 is not supported.

Architecture

Lakeflow Connect → SharePoint Connector → Delta Tables → Databricks Workflows

Get started

Configure Authentication

Set up SharePoint authentication based on your chosen method.

Create Connection

Use Catalog Explorer to create a connection to SharePoint.

Create Pipeline

Non-admin users can create a pipeline using the established connection.

Key takeaway

The SharePoint connector in Lakeflow Connect is now generally available, enabling efficient data ingestion from SharePoint into Databricks.

2026-07-10-sharepoint-connector-in-lakeflow-connect-will-soon-be-generally-available Generated by the Databricks Updates Agent · browse all updates