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 endpoints with Rivery.

Note

Rivery does not integrate with Databricks clusters.

Connect to Rivery by using Partner Connect

Note

If you already have a Rivery account, Databricks recommends that you skip ahead to Connect to Rivery manually instead. This is because the new connection experience in Partner Connect is optimized for new Rivery accounts.

  1. Make sure your Databricks account, workspace, and the signed-in user all meet the requirements for Partner Connect.

  2. In the sidebar, click Partner Connect button Partner Connect.

  3. Click the Rivery tile.

    Note

    If the Rivery tile has a check mark icon inside of it, this means one of your administrators has already used Partner Connect to connect Rivery to your workspace. Contact that admin, who can add you to the Rivery account that they created by using Partner Connect. After they add you, click the Rivery tile.

  4. If the Connect to partner dialog shows a Next button, click it.

    Partner Connect creates the following resources in your workspace:

    • A SQL endpoint named RIVERY_ENDPOINT by default. (You can change this default name before you click Next.)
    • A Databricks service principal named RIVERY_USER.
  5. For Email, enter the email address that you want Rivery to use to create your 14-day trial Rivery account.

  6. Click the button with the label Connect to Rivery or Sign in.

    Important

    If an error appears stating that someone from your organization has already created an account with Rivery, do one of the following:

    • Enter an email address that is not associated with your organization, and then click Connect to Rivery or Sign in again.
    • Contact one of your organization’s administrators and have them add you to your organization’s Rivery account. After they add you, click Connect to Rivery or Sign in again.

    If you clicked Connect to Rivery, Partner Connect creates a Databricks personal access token and associates it with the RIVERY_USER service principal.

  7. On the separate Rivery website tab that appears, complete the on-screen instructions to have Rivery finish creating a 14-day trial Rivery account for you, or sign in to your existing Rivery account.

  8. In your Rivery account, choose Connections. The connection to your SQL endpoint should be displayed.

  9. Do one of the following:

Connect to Rivery manually

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

Note

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

To complete this series of steps, you get the connection details for an existing SQL endpoint in your workspace and then add those details to your Rivery account.

Before you begin, be sure to generate a Databricks personal access token.

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 endpoint 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 may already be a list of existing connection entries with the Databricks logo. These entries might contain connection details for SQL endpoints in workspaces that are separate from yours. If you still want to reuse one of these connections, and you trust the SQL endpoint and have access to it, choose that destination and then skip ahead to Next steps.

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

  7. Enter your token in Personal Access Token.

  8. Click Save.

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

  10. After the test succeeds, skip ahead to Next steps.