Quick BI:Microsoft Azure Databricks

Notes

Older Databricks database architectures do not include information_schema. As a result, Quick BI cannot retrieve the table list from these architectures. You can only create datasets using custom SQL statements. For the best user experience, we recommend using a newer Databricks architecture when you add it as a data source to Quick BI.

Procedure

1. Add IP addresses to the whitelist.

   Before you connect to Databricks, add the IP addresses of Quick BI to the Databricks whitelist.

2. From the entry point for creating a data source, navigate to the Create Data Source page.

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

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

   Name	Description
   Display Name	The display name of the data source in the data source list. Enter a standard name. The name cannot contain special characters or leading or trailing spaces.
   Server Hostname	The server hostname of the Databricks computing resource. Get the server hostname from the Connection details page of your SQL warehouse in the Databricks console.
   HTTP Path	The HTTP path value of the Databricks computing resource. Get the HTTP path from the Connection details page of your SQL warehouse in the Databricks console.
   Port	The port number of the database. The default value is 443.
   Schema	The name of the schema to connect to.
   Catalog	The catalog that corresponds to the database.
   Authentication Method	Select an identity authentication method. Supported methods are Personal Access Token and OAuth M2M. If you select Personal Access Token, configure the following parameter: Access Token: Enter the access token. Get the access token from the Developer page under Settings in the Databricks console. If you select OAuth M2M, configure the following parameters: Application ID: The universally unique identifier (UUID) or application ID of the service principal. Get the application ID from the Service Principals page under Identity and Access in Settings in the Databricks console. OAuth Secret: The client secret for the OAuth 2.0 connection. In the Databricks console, go to the Service Principals page under Identity and Access in Settings. On the Secrets tab, click Generate secret to get the OAuth secret. Note To ensure the long-term availability of the data source, set a long validity period for the secret. If the secret expires, generate a new one and update it in the Quick BI interface.
   SSL	If the target data source is configured with SSL, select the SSL security protocol to protect your data.
   Init SQL	The SQL statements that are executed for initialization after each connection to the data source. Only SET statements are allowed. Separate multiple statements with semicolons.

5. Click Test Connection to verify the data source connection.

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