dbt Core

You can connect to Snowflake through a custom domain using the host parameter in profiles.yaml:

my_project:
  target: dev
  outputs:
    dev:
      type: snowflake
      account: myorg-myaccount
      host: $account.espressocomputing.com
      user: <user>
      # ...

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

See the dbt docs for more information.