Connect to reverse ETL partners using Partner Connect

  • Article

To connect your Azure Databricks workspace to a reverse ETL partner solution using Partner Connect, you typically follow the steps in this article.

Important

Before you follow the steps in this article, see the appropriate partner article for important partner-specific information. There might be differences in the connection steps between partner solutions. Some partner solutions also allow you to integrate with Databricks SQL warehouses (formerly Databricks SQL endpoints) or Azure Databricks clusters, but not both.

Requirements

See the requirements for using Partner Connect.

Important

For partner-specific requirements, see the appropriate partner article.

Steps to connect to a reverse ETL partner

To connect your Azure Databricks workspace to a reverse ETL partner solution, follow the steps in this section.

Tip

If you have an existing partner account, Databricks recommends that you follow the steps to connect to the partner solution manually in the appropriate partner article. This is because the connection experience in Partner Connect is optimized for new partner accounts.

  1. In the sidebar, click Partner Connect button Partner Connect.

  2. Click the partner tile.

    Note

    If the partner tile has a check mark icon inside it, an administrator has already used Partner Connect to connect the partner to your workspace. Skip to step 8. The partner will use the email address for your Azure Databricks account to prompt you to sign in to your existing partner account.

  3. If there are SQL warehouses in your workspace, select a SQL warehouse from the drop-down list. If your SQL warehouse is stopped, click Start.

  4. If there are no SQL warehouses in your workspace, do the following:

    1. Click Create warehouse. A new tab opens in your browser that displays the New SQL Warehouse page in the Databricks SQL UI.
    2. Follow the steps in Create a SQL warehouse.
    3. Return to the Partner Connect tab in your browser, then close the partner tile.
    4. Re-open the partner tile.
    5. Select the SQL warehouse you just created from the drop-down list.

  5. Select a catalog and a schema from the drop-down lists, then click Add. You can repeat this step to add multiple schemas.

    Note

    If a partner doesn’t support Unity Catalog with Partner Connect, the workspace default catalog is used. If your workspace isn’t Unity Catalog-enabled, hive_metastore is used.

  6. Click Next.

    Partner Connect creates the following resources in your workspace:

    Partner Connect also grants the following privileges to the <PARTNER>_USER service principal:

    • (Unity Catalog)USE CATALOG: Required to interact with objects within the selected catalog.
    • (Unity Catalog) USE SCHEMA: Required to interact with objects within the selected schema.
    • (Hive metastore) USAGE: Required to grant the SELECT and READ METADATA privileges for the schemas you selected.
    • SELECT: Grants the ability to read the schemas you selected.
    • (Hive metastore) READ METADATA: Grants the ability to read metadata for the schemas you selected.
    • CAN_USE: Grants permissions to use the SQL warehouse you selected.

  7. Click Next.

    The Email box displays the email address for your Azure Databricks account. The partner uses this email address to prompt you to either create a new partner account or sign in to your existing partner account.

  8. Click Connect to <Partner> or Sign in.

    A new tab opens in your web browser, which displays the partner website.

  9. Complete the on-screen instructions on the partner website to create your trial partner account or sign in to your existing partner account.