Connecting a Databricks Datasource

Create a Databricks Datasource in bipp

Here is what you need to connect:

  • Own Databricks instance
  • Database connection information
Most commonly used Databricks instance is Azure. If you don’t have one, create an Azure instance using this quickstart guide.
  1. Select Datasources from the bottom left corner of the Home Navigation pane to open the Datasources page.

    Datasource Page

  2. Click New Datasource on the Datasources page.

    New Datasource

  3. Enter a Name. For example, TestDataBricks.

  4. Select Databricks for SQL Dialect for your database. bipp creates and enforces the rules for the selected dialect.

    Datasource Databricks

  5. Enter the information for your Databricks database instance:

    • Hostname: name or IP address of the database host.
    • HttpPath: FQDN of the database instance.
    • ClusterToken: Access token to establish connection with the database
    • Database: name of the database for the connection.
  6. Click Test to verify the datasource connectivity. If you have an error, fix the connection or credentials problem and click Test again.

  7. Click Create to add the datasource.

Congratulations! You have successfully created a Databricks datasource in bipp.