Connect to Rivery
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, accelerate 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.
Note
Rivery does not integrate with Azure Databricks clusters.
Connect to Rivery manually
Use the following instructions to manually connect Rivery to a SQL warehouse in your workspace.
Requirements
Before you connect to Rivery manually, you need the following:
An Azure Databricks personal access token or a Microsoft Entra ID (formerly Azure Active Directory) token.
Note
As a security best practice, when you authenticate with automated tools, systems, scripts, and apps, Databricks recommends that you use 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 Create a SQL warehouse.
Connection details for your SQL warehouse. See Get connection details for an Azure Databricks compute resource. Specifically, you need the SQL warehouse's Server Hostname, Port, and HTTP Path field values.
Steps to connect
To connect to Rivery manually, follow the steps in this section.
Sign in to your Rivery account, or create a new Rivery account, at https://console.rivery.io.
Click Connections.
Important
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 Save.
Click the lightning bolt (Test connection) icon.
Additional resources
See the following resources on the Rivery website: