Unlocking Investment Insights Without Migrating Your Data: Lakehouse Federation

Databricks Lakehouse Federation lets users create federated connections to external databases such as SQL Server, PostgreSQL, MySQL, and Snowflake and query them directly from Databricks with standard SQL, keeping data in place. The post walks through a wealth management example that joins on-premises portfolio holdings with FactSet data subscribed from the Databricks Marketplace in a single query, then powers a dashboard and a Genie natural-language agent without pipelines, materialized views, or persisted objects. It notes the same pattern applies to other industries, such as healthcare, manufacturing, and retail.