To connect your Databricks workspace to a reverse ETL partner solution using Partner Connect, you typically follow the steps in this article.
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 Databricks clusters, but not both.
See the requirements for using Partner Connect.
For partner-specific requirements, see the appropriate partner article.
To connect your Databricks workspace to a reverse ETL partner solution, follow the steps in this section.
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.
In the sidebar, click Partner Connect.
Click the partner tile.
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 Databricks account to prompt you to sign in to your existing partner account.
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.
If there are no SQL warehouses in your workspace, do the following:
Click Create warehouse. A new tab opens in your browser that displays the New SQL Warehouse page in the Databricks SQL UI.
Follow the steps in Configure SQL warehouses.
Return to the Partner Connect tab in your browser, then close the partner tile.
Re-open the partner tile.
Select the SQL warehouse you just created from the drop-down list.
Select a catalog and a schema from the drop-down lists, then click Add. You can repeat this step to add multiple schemas.
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,
Partner Connect creates the following resources in your workspace:
A Databricks service principal named <PARTNER>_USER.
A Databricks personal access token that is associated with the <PARTNER>_USER service principal.
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.
The Email box displays the email address for your 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.
Click Connect to <Partner> or Sign in.
A new tab opens in your web browser, which displays the partner website.
Complete the on-screen instructions on the partner website to create your trial partner account or sign in to your existing partner account.