
Databricks Lakehouse Federation: Query Your Data Without Moving It
TLDR Databricks Lakehouse Federation is Databricks’ query federation platform. It lets you query external systems like Snowflake, Redshift, BigQuery, SQL Server, Oracle, and Teradata directly through Unity Catalog, without moving the data first. Two modes exist: query federation, which pushes SQL down to the source over JDBC, and catalog federation, which reads Iceberg or Delta tables straight from object storage







