> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cloud.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Databricks Lakehouse Federation

> Databricks Lakehouse Federation allows for data virtualization without importing data into Databricks. Although Connect AI allows for data virtualization, there are some features, such as data lineage and fine-grained access control, that can benefit from being virtualized on Databricks. For more information on Databricks Lakehouse Federation, see the [Databricks documentation](https://www.databricks.com/blog/announcing-general-availability-lakehouse-federation).

Databricks Lakehouse Federation can pull data from sources that you have connected to your Connect AI account. This page outlines the steps to connect Databricks Lakehouse Federation to the Connect AI Virtual SQL Server API.

## Prerequisites

Before you connect, you must first do the following:

* Connect a data source to your Connect AI account. See [Sources](/en/Sources) for more information.
* Generate a Personal Access Token (PAT) on the [Settings](/en/Settings#personal-access-tokens) page. Copy this down, as it acts as your password during authentication.

## Connect to Connect AI

To establish a connection from Databricks Lakehouse Federation to the Connect AI Virtual SQL Server API, follow these steps.

<Steps>
  <Step>
    Log in to Databricks.
  </Step>

  <Step>
    In the navigation pane, select **Catalog**. Click **+** and select **Add a connection**.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/databrickslhf_client_add_connection.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=1938d34d953fc4cba85eb68d25b37181" alt="" width="1023" height="458" data-path="en/images/databrickslhf_client_add_connection.png" />
    </Frame>
  </Step>

  <Step>
    In **Create Connection**, enter the following:

    * **Connection name**—the user-defined connection name.
    * **Connection type**—select **SQL Server** from the drop-down list.
    * **Auth type**—select **Username and password**.
    * **Host**—*tds.cdata.com*
    * **Port**—*14333*
    * **User**—enter your Connect AI username. This is displayed in the top-right corner of the Connect AI interface. For example, *[test@cdata.com](mailto:test@cdata.com)*.
    * **Password**—enter the PAT you generated on the [Settings](/en/Settings#personal-access-tokens) page.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/databrickslhf_client_connection_details.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=9fcbbb0247fa2804c3ca948452dd656a" alt="" width="1009" height="662" data-path="en/images/databrickslhf_client_connection_details.png" />
    </Frame>
  </Step>

  <Step>
    Click **Test connection**. If the connection succeeds, a confirmation dialog appears.
  </Step>

  <Step>
    You now need to add the target database to the Catalog. In the navigation pane, select the connection you just created and click **Create catalog**.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/databrickslhf_client_create_catalog.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=7bd4a247cfd6a4f84f5946461fd55deb" alt="" width="1021" height="377" data-path="en/images/databrickslhf_client_create_catalog.png" />
    </Frame>
  </Step>

  <Step>
    In the **Create a new catalog** dialog, enter the following information,

    * **Catalog name**—enter a user-defined catalog name.
    * **Connection**—this is the Databricks connection you defined earlier and selected.
    * **Database**—enter the Connection Name of the Connect AI data source you want to connect to (for example, *Salesforce1*).

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/databrickslhf_client_catalog_details.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=af4a4cfa2a248cf0dd81d1a802ae4555" alt="" width="954" height="783" data-path="en/images/databrickslhf_client_catalog_details.png" />
    </Frame>
  </Step>

  <Step>
    Click **Create**. If the catalog creation succeeds, a confirmation dialog appears. Click **View catalog** to view your new catalog.
  </Step>

  <Step>
    You can also return to **Catalog** in the navigation pane and find the catalog you just added. Expand the catalog to view the objects in the catalog.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/databrickslhf_client_view_catalog.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=64fe982455d3c98a367f4434fb5399db" alt="" width="742" height="867" data-path="en/images/databrickslhf_client_view_catalog.png" />
    </Frame>
  </Step>

  <Step>
    Select a table and click the **Overview** tab to view table metadata.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/databrickslhf_client_table_metadata.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=d067bdfb2c4d40953aa88f3e848d8377" alt="" width="1044" height="717" data-path="en/images/databrickslhf_client_table_metadata.png" />
    </Frame>
  </Step>

  <Step>
    Click the **Sample Data** tab to view the real-time data in the table.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/databrickslhf_client_table_data.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=3fc2f9ae5ca7a90caed6b69a8820a0cc" alt="" width="1032" height="487" data-path="en/images/databrickslhf_client_table_data.png" />
    </Frame>
  </Step>

  <Step>
    Go to **Dashboards** in the navigation pane to visualize the data.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/databrickslhf_client_dashboards.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=176f621b2e4a56c49d1ad61b7bc238ad" alt="" width="1025" height="525" data-path="en/images/databrickslhf_client_dashboards.png" />
    </Frame>
  </Step>
</Steps>