Databricks
When you use Databricks as a data source with ChartFactor Studio, you can provide powerful interactive analytics, bringing to your business analysts the contributions of your data scientists and data engineers while scaling to massive datasets. Your business analysts can also share their interactions and insights with a larger audience by generating web applications that they can publish in a web server.
This article features ChartFactor Studio Desktop.
Requirements¶
- ChartFactor Studio Desktop v4.1.18 or above
- A Databricks personal access token
- The connection details for your SQL warehouse, specifically the Server hostname and the Warehouse ID which is the last part of the HTTP path in the connection details section of the Databricks SQL Warehouses page.
Connecting to ChartFactor Studio Desktop¶
Follow these instructions to connect to a cluster or SQL warehouse with ChartFactor Studio Desktop.
- Download ChartFactor Studio Desktop
- Select New > App
- Select the blue button on the lower right corner of the page to open the New Data Provider dialog
- In the list of data providers, select Databricks
-
Enter the following:
a. Name: This is the name that ChartFactor Studio will use to refer to your data provider within your visualizations
b. Host: This is the Server host name specified in your SQL Warehouse connection details page
c. Warehouse ID: This is the last part of the HTTP path specified in your SQL Warehouse connection details page
d. Databricks access token: This is your personal Databricks personal access token
-
Save your data provider by selecting the SAVE button
You should now be able to select your newly configured Databricks data provider to visualize your data sources.
There is no need to refresh anything to keep your data up to date in your applications, data updates in real time.