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 Development Connection

You will be prompted to add a Development connection during the onboarding, or you can add more connections by going to account settings > connections, select Development Environment and enter the required fields.

Using Personal Access Token (PAT)

Fields details

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

• 🏢 Workspace level fields are set by the the workspace Admin and not configurable for by user

• 👥 User level fields are set by each user (Admin/Developer) when setting the Development connection.

Field	Description	Example	Level
Profile Name	The profile name set in your dbt_project.yaml . See more here.	dbt-databricks	🏢 Workspace level
Target	The target name used to identify the connection. See more here.	dev	🏢 Workspace level
Service Host Name	Databricks server hostname	dbc-e7c65a5c-0521.cloud.databricks.com	🏢 Workspace level
HTTP path	Databricks compute resources URL	/sql/1.0/warehouses/fbc246efa4369412	🏢 Workspace level
Unity Catalog Name (Optional)	The name of the Unity Catalog. See more here.	analytics	🏢 Workspace level
Personal Access Token (PAT)	The PAT created by each user. See more here.	dapid7cc51fb15d5889136351110e66119b3	👥 User level
Schema	The default schema used to build dbt™️ objects at runtime.	dbt_john	👥 User level
Threads	The number of threads used in this connection. See more here.	8	👥 User level