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

Note

Rivery does not integrate with Databricks clusters.

Connect to Rivery using Partner Connect

For an overview of the following procedure, watch this YouTube video (3 minutes).

Steps to connect

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

  1. Connect to a data ingestion partner solution 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:

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: