Fivetran

Fivetran automated data integration adapts as schemas and APIs change, ensuring reliable data access and simplified analysis with ready-to-query schemas.

You can integrate your Databricks SQL endpoints and Azure Databricks clusters with Fivetran. The Fivetran integration with Azure Databricks helps you easily centralize data from disparate data sources into Delta Lake.

Connect to Fivetran by using Partner Connect

Note

Partner Connect does not integrate Fivetran with Azure Databricks clusters. To integrate a cluster with Fivetran, skip ahead to Connect to Fivetran manually.

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

  1. Make sure your Azure 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 Fivetran tile.

    Note

    If the Fivetran tile has a check mark icon inside of it, this means one of your administrators has already used Partner Connect to connect Fivetran to your workspace. Contact that admin, who can add you to the Fivetran account that they created by using Partner Connect. After they add you, click the Fivetran 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 FIVETRAN_ENDPOINT by default. (You can change this default name before you click Next.)
    • An Azure Databricks service principal named FIVETRAN_USER.
  5. For Email, enter the email address that you want Fivetran to use to create a 14-day trial Fivetran account for you, or enter the email address for your existing Fivetran account.

  6. Click Connect to Fivetran or Sign in.

    Important

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

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

    If you clicked Connect to Fivetran, Partner Connect creates an Azure Databricks personal access token and associates it with the FIVETRAN_USER service principal.

  7. A new tab opens in your web browser, which displays the Fivetran website.

  8. Complete the on-screen instructions in Fivetran to create your 14-day trial Fivetran account or to sign in to your existing Fivetran account.

  9. Continue with Next steps.

Connect to Fivetran

To complete this series of steps, you get the connection details for an existing compute resource (a SQL endpoint or cluster) in your workspace and then add those details to your Fivetran account.

Note

To connect a SQL endpoint with Fivetran faster, use Partner Connect.

For a SQL endpoint, generate an Azure Databricks personal access token or get an Azure Active Directory token and then:

Tip

If the Fivetran tile in Partner Connect in your workspace 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 Fivetran asks you for it.

For a cluster, generate an Azure Databricks personal access token or get an Azure Active Directory token and then:

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

  1. Sign in to your Fivetran account, or create a new Fivetran account, at https://fivetran.com/dashboard.

    Important

    If you sign in to your organization’s Fivetran account, a Choose Destination page may display, listing one or more existing destination entries with the Databricks logo. These entries might contain connection details for compute resources in workspaces that are separate from yours. If you still want to reuse one of these connections, and you trust the compute resource and have access to it, choose that destination and then skip ahead to Next steps. Otherwise, choose any available destination to get past this page, and then go to https://fivetran.com/account.

  2. In your Dashboard page in Fivetran, click the Destinations tab. (If the Dashboard page is not displayed, go to https://fivetran.com/account.)

  3. Click Add Destination.

  4. Enter a Destination name and click Add.

  5. On the Fivetran is modern ELT page, click Set up a connector.

  6. Click a data source, and then click Next.

  7. Follow the on-screen instructions in the Setup Guide in Fivetran to finish setting up the connector.

  8. Click Save & Test.

  9. After the test succeeds, click Continue.

  10. On the Select your data’s destination page, click Databricks on Azure.

  11. Click Continue Setup.

  12. Complete the on-screen instructions in Fivetran to enter the connection details for your existing Azure Databricks compute resource, specifically the Server Hostname and HTTP Path field values, and the token that you generated earlier.

  13. Click Save & Test.

  14. After the test succeeeds, click Continue.

  15. Continue with Next steps.

Next steps

Explore one or more of the following resources on the Fivetran website: