Skip to content

Databricks Lakehouse Federation

Lakehouse Federation in Databricks🔗

This feature allows us to query external system data without replicating storage on databricks.

Steps to Setup Federation🔗

We need the external location to setup connection.

image

Create a new Connection.

image

image

image

image

image

  • Foreign catalogs are read only.
  • Any catalog that doesnt come under Unity Catalog scheme of things is Foreign Catalog.
  • We can manage permissions and also check lineage of tables of Foreign Catalogs.

Creating Catalogs using SQL

image