Rivery helps you ingest, orchestrate, and take action on all of your data. Rivery empowers organizations to support more data sources, larger and more complex datasets, speed up time to insights, and increase access to data across the entire organization.
You can integrate your Databricks SQL warehouses (formerly Databricks SQL endpoints) with Rivery.
Rivery does not integrate with Databricks clusters.
For an overview of the following procedure, watch this YouTube video (3 minutes).
To connect to Rivery using Partner Connect, do the following:
In your Rivery account, choose Connections. The connection to your SQL warehouse should be displayed.
If the connection is not displayed, you can troubleshoot by skipping ahead to connect to Rivery manually.
Use the following instructions to manually connect Rivery to a SQL warehouse in your workspace.
To connect your SQL warehouses faster to Rivery, use Partner Connect.
Before you connect to Rivery manually, you need the following:
A Databricks personal access token.
As a security best practice when you authenticate with automated tools, systems, scripts, and apps, Databricks recommends that you use OAuth tokens or personal access tokens belonging to service principals instead of workspace users. To create tokens for service principals, see Manage tokens for a service principal.
A SQL warehouse.
To create a SQL warehouse in your workspace, see Configure SQL warehouses.
Connection details for your SQL warehouse. See Get connection details for a SQL warehouse. Specifically, you need the SQL warehouse’s Server Hostname, Port, and HTTP Path field values.
To connect to Rivery manually, follow the steps in this section.
If the Rivery tile in Partner Connect has a check mark icon inside of it, you can get the connection details for the connected SQL warehouse by clicking the tile and then expanding Connection details. Note however that the Personal access token here is hidden; you must create a replacement personal access token and enter that new token instead when Rivery asks you for it.
Sign in to your Rivery account, or create a new Rivery account, at https://console.rivery.io.
If you sign in to your organization’s Rivery account, there might already be a list of existing connection entries with the Databricks logo. These entries might contain connection details for SQL warehouses in workspaces that are separate from yours. If you still want to reuse one of these connections, and you trust the SQL warehouse and have access to it, choose that destination and skip the remaining steps in this section.
Click Create New Connection.
Choose Databricks. Use the Filter Data Sources box to find it if necessary.
Enter a Connection Name and an optional Description.
Enter the Server Hostname, Port, and HTTP Path from the connection details for your SQL warehouse.
Enter your token in Personal Access Token.
Click the lightning bolt (Test connection) icon.