Databricks SQL

The Databricks SQL Connection enables the ingestion of structured data from Databricks Workspaces using a SQL interface.

Connection Settings

JDBC Connection String

The JDBC connection string of the Databricks instance. It should follow the format: jdbc:databricks://XXX-XXXXXXXX-XXXX.cloud.databricks.com:443.

HTTP Path

The HTTP path of the SQL warehouse. It should follow the format: /sql/1.0/warehouses/XXXXXXXXXXXXX.

Authentication Type

Specifies the authentication method used to connect to the Databricks instance. Personal Access Token and OAuth are supported.

Personal Access Token (PAT)

Used to authenticate individual users.

Token

The token used for user authentication.

OAuth

Used to authenticate service principals and users.

Client ID

The client ID of the service principal or user.

Client Secret

The client secret of the service principal or user.

Keep Alive

See JDBC Driver Settings for keep alive settings.

Input Settings

See JDBC Driver Settings for input settings.

Output Settings

Outputs are not supported.