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 Databricks clusters.

Connect to Rivery using Partner Connect

To connect to Rivery using Partner Connect, do the following:

1. Connect to ingestion partners using Partner Connect.

2. 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.

Connect to Rivery manually

Use the following instructions to manually connect Rivery to a SQL warehouse in your workspace.

Note

To connect your SQL warehouses faster to Rivery, use Partner Connect.

Requirements

Before you connect to Rivery manually, you need the following:

• A Databricks personal access token.

  Note

  As a security best practice when you authenticate with automated tools, systems, scripts, and apps, Databricks recommends that you use OAuth tokens.

  If you use personal access token authentication, Databricks recommends using 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 a 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.

Tip

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.

1. Sign in to your Rivery account, or create a new Rivery account, at https://console.rivery.io.

2. 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.

3. Click Create New Connection.

4. Choose Databricks. Use the Filter Data Sources box to find it if necessary.

5. Enter a Connection Name and an optional Description.

6. Enter the Server Hostname, Port, and HTTP Path from the connection details for your SQL warehouse.

7. Enter your token in Personal Access Token.

8. Click Save.

9. Click the lightning bolt (Test connection) icon.

Additional resources

See the following resources on the Rivery website:

• Data Source to Target Overview

• Documentation

• Community

• Support