Version 2021
How to Connect to Databricks
Databricks is an open and unified data analytics platform for data engineering, data science, machine learning, and analytics.
After generating a new token, you can import data from Databricks to MicroStrategy.
Generate a New Token
- Log into your Databricks workspace
- Select your cluster to go to the Clusters management page.
- Click the Advanced Options drop-down.
-
Copy the JDBC URL for later use.
- Click the user profile icon in the top right of your workspace.
- Click User Settings.
-
Under the Access Tokens tab, click the Generate a New Token button.
- Complete the required fields for the new token.
- Click the Generate button.
- Copy the generated token for later use.
Connect in MicroStrategy
- Web
- Workstation
-
In MicroStrategy Web, click on the Create button > Add External Data.
-
Find and select the Databricks connector from the data source list.
-
In the Select Import Options dialog, select an option and click Next.
-
Next to Data Sources, click New Data Source
to add a new connection.
-
In the Connections dialog, complete the required fields. Use the JDBC URL and token information retrieved in the Generate a New Token section above.
.
- Click Save.
-
Connect to the saved Databricks data source and select the tables you want to import.
-
Prepare the data or click Finish.
You can now use the saved cube to build dossiers.
-
In Workstation, next to Datasets, click Create a new dataset
and choose a project.
- Choose an environment and project.
-
Find and select the Databricks connector from the data source list.
-
In the Select Import Options dialog, select an option and click Next.
-
Next to Data Sources, click New Data Source
to add a new connection.
-
In the Connections dialog, complete the required fields. Use the JDBC URL and token information retrieved in the Generate a New Token section above.
.
- Click Save.
-
Connect to the saved Databricks data source and select the tables you want to import.
-
Prepare the data or click Finish.
You can now use the saved cube to build dossiers.