# Databricks Lakehouse Federation queries on-premises and FactSet data without migration

> Original title: Unlocking Investment Insights Without Migrating Your Data: Lakehouse Federation

- Source: Databricks Blog
- Published: 2026-10-27T18:00:00.000Z
- Bad Influence: https://badinfluence.news/items/o8bmyyo8918jczbwmvugap0jq
- Original: https://www.databricks.com/blog/unlocking-investment-insights-without-migrating-your-data-lakehouse-federation

## Summary

Databricks says Lakehouse Federation lets users query external databases such as SQL Server with standard SQL and join them with FactSet marketplace data in Unity Catalog, without copying data to the cloud. The walkthrough builds a portfolio dashboard and a Genie natural-language agent that re-query the on-premises holdings live on each refresh. The data stays in the source system, with no pipelines or persisted views.