Connect to Data Sources and Services

Lakeflow Connect vs Lakehouse Federation

Lakehouse Federation allows you to query external data sources without moving your data. When you have a choice between Lakeflow Connect and Lakehouse Federation, choose Lakehouse Federation for ad hoc reporting or proof-of-concept work on your ETL pipelines.

Example : Sharepoint integration

Lakehouse Federation

Lakehouse Federation is the query federation platform for Databricks. The term query federation describes a collection of features that enable users and systems to run queries against multiple data sources without needing to migrate all data to a unified system.

There are two types of federation: query federation and catalog federation.

Query Federation vs Lakehouse Federation

Supported Data Sources