Databricks connection

IP RESTRICTIONS

Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.

👉 See also: Paradime IP addresses.

Add Production Connection

To add the Databricks Production connection, go to account settings > connections, select Production Environment and enter the required fields.

Fields details

Below are list of fields and example to create a connection.

FieldDescriptionExample

Profile Name

The profile name set in your dbt_project.yaml . See more here.

dbt-databricks

Target

The target name used to identify the connection. See more here.

prod

Service Host Name

Databricks server hostname

dbc-e7c65a5c-0521.cloud.databricks.com

HTTP path

Databricks compute resources URL

/sql/1.0/warehouses/fbc246efa4369412

Unity Catalog Name (Optional)

The name of the Unity Catalog. See more here.

analytics

Service Principal Token (SPT)

The SPT created for your service user. See more here.

dapid7cc51fb15d5889136351110e66119b3

Schema

The default schema used to build dbt™️ objects at runtime.

dbt_prod

Threads

The number of threads used in this connection. See more here.

8

Last updated