Azure Databricks

Notes

The legacy architecture of Databricks does not include information_schema. As a result, Quick BI cannot retrieve the table list from data sources with this architecture. You can create datasets only by using custom SQL. For the best experience, we recommend that you use the new Databricks architecture as the data source.

Procedure

1. Add IP addresses to the allowlist.

   To connect to Databricks, you must first add the Quick BI IP addresses to the Databricks allowlist.

2. Go to the page for creating data sources.

3. On the Microsoft Azure database tab, select the Azure Databricks data source.

4. In the Configure Connection dialog box, configure the following parameters.

   Parameter	Description
   Display Name	The display name of the data source. The name cannot contain special characters or leading or trailing spaces.
   Server Hostname	The server hostname of your Databricks compute resource. In the Databricks management console, go to SQL Warehouses > Connection details to find the server hostname.
   HTTP Path	The HTTP path of your Databricks compute resource. In the Databricks management console, go to SQL Warehouses > Connection details to find the HTTP path.
   Port	The port number of the database. Default value: 443.
   Schema	The name of the schema to connect to.
   Catalog	The catalog of the database.
   Authentication Method	Select an authentication method. You can choose Personal access token or OAuth M2M. If you select Personal access token, configure the following parameter: Access Token: Enter the access token. In the Databricks management console, go to Settings > Developer to get the access token. If you select OAuth M2M, configure the following parameters: Application ID: The UUID or application ID of the service principal. In the Databricks management console, go to Settings > Identity and access > Service Principals to find the application ID. Client secret: The client secret for the OAuth 2.0 connection. In the Databricks management console, go to Settings > Identity and access > Service Principals. On the Secrets tab, click Generate secret to get the client secret. Note To ensure the data source remains available, set a long expiration period for the secret. If the secret expires, generate a new one and update it in Quick BI.
   SSL	If SSL is configured for the target data source, select this option to secure your data connection.
   Initial SQL	SQL statements to run after a connection is established. Only SET statements are allowed. Use a semicolon (;) to separate multiple statements.

5. Click Test Connection to verify the parameters.

6. After the test succeeds, click OK to add the data source.