Table of Contents

Databricks

Ramya Priya Updated by Ramya Priya

To load data from Databricks to Tellius, follow the below steps.

Prerequisites

  1. Access to the Databricks Cloud Console (https://dbc-xxxxxxx.cloud.databricks.com)
  2. Access to Tellius platform

Steps to be followed from Databrick Cloud Console

  1. Visit the Databricks Cloud Console at https://dbc-xxxxxxx.cloud.databricks.com and log in with your credentials.
  2. Once logged in, navigate to SQL module in Databricks Cloud.
  1. In the left menu, select SQL Warehouses and choose the required warehouse.
  1. Copy the JDBC URL provided on the warehouse details page. The URL should be in the following format:
jdbc:spark://dbc-xxxxxx.cloud.databricks.com:443/<DatabaseName>;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/warehouses/xxxxxx;

Please make sure to replace <DatabaseName> with the database name from which you are trying to load the data.
  1. In the bottom right corner of the Databricks Cloud Console, click on the user icon and choose User Settings.
  2. Create a new Personal Access Token by clicking Generate New Token.
  3. Set an appropriate token name and validity, then click on Generate. Copy the generated token.
  1. Update the JDBC URL by adding the Personal Access Token to it. Replace <PersonalAccessToken> with the token you copied in the previous step. The final JDBC URL should look like this:
jdbc:spark://dbc-xxxxxx.cloud.databricks.com:443/<DatabaseName>;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/warehouses/xxxxxx;UID=token;PWD=<PersonalAccessToken>

Steps to be followed from Tellius

  1. Log in to the Tellius platform and navigate to Data --> Connect --> Create New --> Databricks Delta Lake.
  1. Enable the toggle Use validated datasource connection details to select from an already established connection. Choose the required datasource in Select Datasource.
  2. Provide the updated JDBC URL from step 8 in the URL field.
  3. Provide a relevant Datasource Name and click on Save and browse host or Update and browse host.

Did we help you?

Looker SQL Interface

Connecting to an AlloyDB Cluster

Contact