dbt Core

Change the host parameter in profiles.yml and leave http_path unchanged:

my_project:
  target: dev
  outputs:
    dev:
      type: databricks
      host: <workspace>.cloud.databricks.espressocomputing.com
      http_path: /sql/1.0/warehouses/<warehouse_id>
      token: "{{ env_var('DATABRICKS_TOKEN') }}"
      catalog: <catalog>
      schema: <schema>
      # ...

OAuth authentication (auth_type: oauth, with or without client_id / client_secret) works unchanged.

Each project can be configured to use its own profile if needed.

See the dbt docs for more information.