Some partner solutions allow you to integrate with only Databricks SQL warehouses or Databricks clusters, but not both. For details, see the partner documentation.
These solutions allow you to:
Load data from external data sources into local Delta Lake tables.
Create and manage extract-transform-load (ETL) and extract-load-transform (ELT) data pipelines through simplified user interfaces.
Perform business intelligence operations on data.
Work with machine learning (ML) on data.
For a list of participating partners, see Partner Connect partners.
Your Databricks account must be on the Premium or Enterprise Plan. This is because many of the partner solutions in Partner Connect use Databricks SQL, which is available only on these plans. To view your Databricks account details, use the account console.
Your Databricks workspace must be on the E2 version of the Databricks platform. This is because Partner Connect uses Databricks service principals, which are available only on this version of the platform. To determine whether your workspace is on the E2 version of the Databricks platform, contact your Databricks representative.
To create new connections to partner solutions, you must first sign in to your workspace as a Databricks admin. For information about Databricks admins, see Manage workspace-level users.
For all other Partner Connect tasks, you must first sign in to your workspace as a Databricks admin; or a Databricks user who has at least the Workspace access entitlement and, if you are working with SQL warehouses, the Databricks SQL access entitlement. For more information, see Manage workspace-level users.
Make sure your Databricks account, workspace, and the signed-in user all meet the requirements for Partner Connect.
In the sidebar, click Partner Connect.
Click the tile for the partner that you want to connect your workspace to. If the tile has a check mark icon, stop here, as your workspace is already connected. Otherwise, follow the on-screen directions to finish creating the connection.
Partner solutions that use a locally-installed application instead of a web-based one (such as Power BI Desktop and Tableau Desktop) do not display a check mark icon in their tile in Partner Connect, even after you connect your workspace to them.
To work with your new connection, see the concluding or Next steps section of the corresponding Setup guide in the list of Partner Connect partners.
This section describes common tasks you might need to complete to create and manage partner connections using Partner Connect.
Partner solutions in the Data Ingestion category in Partner Connect can create databases and tables in your workspace. These databases and tables are owned by the partner solution’s associated Databricks service principal in your workspace.
By default, these databases and tables can be accessed only by the service principal and by workspace admins. To allow other users in your workspace to access these databases and tables, use the SQL GRANT statement. To get access details for an existing database or table, use the SQL SHOW GRANTS statement.
Databricks partner solutions require you to provide the partner with a Databricks personal access token. The partner uses this token to authenticate with your Databricks workspace.
For cloud-based partner solutions in Partner Connect (such as Fivetran, Labelbox, Prophecy, and Rivery), Partner Connect automatically creates the token (along with a Databricks service principal that is associated with that token) and then shares the token’s value with the partner. You cannot access the token’s value. If for any reason the token expires or the token’s value is no longer shared with the partner, you must create a replacement token for the service principal; to do this, see Manage service principals and personal access tokens. To share the replacement token with the partner, see the partner’s documentation.
Only Databricks workspace administrators can generate replacement tokens for Databricks service principals. If you cannot generate a replacement token, contact your administrator. See also Manage workspace-level service principals.
For desktop-based partner solutions in Partner Connect (such as Power BI and Tableau), you must create the token and then share the token’s value with the partner. To create the token, see Generate a personal access token. To set up the partner solution so that it shares the new token with the partner, follow the on-screen instructions in Partner Connect or see the partner’s documentation.
When you create the token and share the token’s value with the partner, the partner can take whatever actions that the related entity (such as your Databricks user or a Databricks service principal) can normally take within your Databricks workspace. Do not share token values with partners whom you do not trust.
As a security best practice, when authenticating with automated tools, systems, scripts, and apps, Databricks recommends you use access tokens belonging to service principals instead of workspace users. For more information, see Service principals for Databricks automation.
Databricks workspace administrators can disable token generation. If you cannot generate a token, contact your administrator. See also Manage personal access tokens.
To allow a Databricks SQL warehouse to access data outside of Databricks, see Configure access to cloud storage.