Fusion migration from dbt Core - dbt1011 error on debug

Help
1

The problem I’m having

I’m trying to test out dbt Fusion and running into problems with the dbtf debug step.

This is the error I get

error: dbt1011: HTTP error: io: An existing connection was forcibly closed by the remote host. (os error 10054)

The context of why I’m trying to do this

Currently i’m using a dbt core and wanted to try out dbt Fusion with my existing project & profiles files to be able to share with my dev team and explore if we can make use of Fusion or not.

What I’ve already tried

I’m running on

  • VSCode version 1.105.1
  • dbt VSCode extension 0.20.0
  • dbt Fusion dbt-fusion 2.0.0-preview.48

I have generated a dbt_cloud.yml file. I am using an existing profiles.yml file that works fine with dbt core. An example of my profiles file is below

my_project_name:
  outputs:
    pd02_de:
      host: adb-9999999999999999.99.azuredatabricks.net
      http_path: /sql/1.0/warehouses/xxxxxxxxxxx
      catalog: prod_catalog
      schema: my_schema
      threads: 4
      auth_type: oauth
      type: databricks
      session_properties:
        ANSI_MODE: TRUE
  target: prod

I have the following settings in the project already

dbt-core~=1.10.9
dbt-databricks~=1.10.9

Some example code or error messages

dbt-fusion 2.0.0-preview.48
   Loading ~/.dbt/profiles.yml
 Debugging profile: pd02_de
 Debugging dbt version: 2.0.0-preview.48
 Debugging platform: windows x86_64 (windows)
 Debugging adapter type: databricks (remote)
 Debugging dependencies:
  git: OK
 Debugging connection:
  "schema": "my_schema",
  "host": "REDACTED",
  "http_path": "REDACTED"
error: dbt1011: HTTP error: io: An existing connection was forcibly closed by the remote host. (os error 10054)

============================================================== Execution Summary ===============================================================
Finished 'debug' with 1 error for target 'pd02_de' [476ms]

────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────

We couldn't validate your connection using dbtf debug.

   Please review the debug output above and verify your profiles.yml settings (account, host, username, schema,
   and authentication).

   Helpful resources:
      ‣ dbt profiles documentation: https://docs.getdbt.com/docs/core/connect-data-platform/connection-profiles
      ‣ Get help in our community Slack: #dbt-fusion-engine


============================================================== Execution Summary ===============================================================
Finished 'init' successfully [2.8s]

 *  The terminal process "C:\Users\35308\.local\bin\dbt.exe 'init', '--fusion-upgrade'" terminated with exit code: 1.
2

I think i resolved the issue - Fusion was unable to download the necessary Databricks setup files from the CDN during the setup stage. I manually downloaded them via CURL and was able to successfully run a dbtf debug