Microsoft Azure Databricks connection

Databricks is a big data analytics tool based on Apache Spark.

Supported versions

Databricks SQL engine version 4.0.0. For compatibility, use JDBC driver version 2.6.25 or later.

Limitations

Only structured relational databases are supported.

Create a connection to Databricks

To access your data in Microsoft Azure Databricks, create a connection to it.

Enter these connection details and select an authentication method.

Connection details

  • Connection name

  • Hostname or IP address of the database

  • Port number

  • HTTP path: Path of the endpoint for which the server is configured in HTTP transport mode.

  • Keepalive interval: Interval in seconds between keepalive validation queries. Set to a value greater than 0 to enable keepalive.

Credentials

Choose an authentication method:

Prerequisite for Entra ID authentication - Microsoft Entra ID is a cloud-based identity and access management service. To obtain connection values for the Entra ID authentication method, sign in to the Microsoft Azure portal. For more information about Microsoft Entra ID, see What is Microsoft Entra ID? and Get Microsoft Entra ID tokens for service principals.

  • Entra ID client secret credentials

    • Tenant ID: The client ID for authorizing access to Microsoft Azure.

    • Client ID of service principal: The client ID of service prinicpal for authorizing access to Microsoft Azure.

    • Client secret of service principal: The authentication key that is associated with the client ID for authorizing access to Microsoft Azure.

  • Entra ID token

  • Service principal credentials

  • Username and password