# Dbt-dremio 1.8.0 Connection Error using software host **URL:** \ **Category:** Uncategorized\ **Created:** [December 10, 2024, 1:06am UTC](https://community.dremio.com/t/dbt-dremio-1-8-0-connection-error-using-software-host/12580 "2024-12-10T01:06:02Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![rdkworld](https://avatars.discourse-cdn.com/v4/letter/r/6de8d8/32.png) [@rdkworld](https://community.dremio.com/u/rdkworld)\ **Post date:** [December 10, 2024, 1:06am UTC](https://community.dremio.com/t/dbt-dremio-1-8-0-connection-error-using-software-host/12580/1 "2024-12-10T01:06:02Z")
Hello, I am testing connectivity from my local machine to dremio on software host, I have installed dbt-core and dbt-dremio and done the db2 init When I test the connectivity using dbt debug, I get below error. Any thoughts? 00:59:45 Connection test: [ERROR] 00:59:45 1 check failed: 00:59:45 dbt was unable to connect to the specified database. The database returned the following error: > Database Error > HTTPConnectionPool(host=‘removed host name’, port=9047): Max retries exceeded with url: /apiv2/login (Caused by NewConnectionError(‘\: Failed to establish a new connection: [WinError 10061] No connection could be made because the target machine actively refused it’)) ---
**Author:** ![rdkworld](https://avatars.discourse-cdn.com/v4/letter/r/6de8d8/32.png) [@rdkworld](https://community.dremio.com/u/rdkworld)\ **Post date:** [December 11, 2024, 12:14am UTC](https://community.dremio.com/t/dbt-dremio-1-8-0-connection-error-using-software-host/12580/2 "2024-12-11T00:14:39Z")
@fetanchaud Hi Fabrice, I see you have responded on dbt in the past. Any thoughts/suggestions I can try out? do you know if dbt uses port 9047 via a rest call? ---
**Author:** ![Liliana](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/liliana/32/6191_2.png) [@Liliana](https://community.dremio.com/u/Liliana)\ **Post date:** [December 11, 2024, 11:01am UTC](https://community.dremio.com/t/dbt-dremio-1-8-0-connection-error-using-software-host/12580/3 "2024-12-11T11:01:22Z")
Hi @rdkworld! Could you please provide the dbt project configurations in `~/.dbt/profiles.yml`? Thanks! ---
**Author:** ![rdkworld](https://avatars.discourse-cdn.com/v4/letter/r/6de8d8/32.png) [@rdkworld](https://community.dremio.com/u/rdkworld)\ **Post date:** [December 11, 2024, 11:02pm UTC](https://community.dremio.com/t/dbt-dremio-1-8-0-connection-error-using-software-host/12580/4 "2024-12-11T23:02:08Z")
Hi @Liliana Here is the dbt profile configuration. Does dbt indeed use port 9047 or could it be 31010 or 32010, also is the call to dremio a REST API call or ODBC Arrow or pure ODBC run\_dremio\_sqls: outputs: dev: dremio\_space: ‘@user’ dremio\_space\_folder: no\_schema object\_storage\_path: no\_schema object\_storage\_source: $scratch password: port: 9047 software\_host: threads: 1 type: dremio use\_ssl: false user: target: dev ---
**Author:** ![Liliana](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/liliana/32/6191_2.png) [@Liliana](https://community.dremio.com/u/Liliana)\ **Post date:** [December 12, 2024, 11:04am UTC](https://community.dremio.com/t/dbt-dremio-1-8-0-connection-error-using-software-host/12580/5 "2024-12-12T11:04:21Z")
Thank you for providing the configurations. If you are trying to run it locally, `software_host` should be _localhost_. However, if you are working in an environment (for instance, a docker container) `software_host` should be the container’s name. You can take a look on this [repository](https://github.com/vandop/dremio-personal-analytics) and see if this helps! Answering your questions, the port is indeed 9047 and dbt connects with Dremio through REST API. ---
**Author:** ![rdkworld](https://avatars.discourse-cdn.com/v4/letter/r/6de8d8/32.png) [@rdkworld](https://community.dremio.com/u/rdkworld)\ **Post date:** [December 12, 2024, 2:36pm UTC](https://community.dremio.com/t/dbt-dremio-1-8-0-connection-error-using-software-host/12580/6 "2024-12-12T14:36:13Z")
@Liliana thanks, dremio is not local nor it is on docker. It is on ec2 on aws and i provide the hostname that is reachable from my machine. Doing a restapi to login endpoint with hostname on port 9047 works(thru postman, python requests) however when doing thru dbt does not work. I looked at repo you provided, it is for local host ---
**Author:** ![Liliana](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/liliana/32/6191_2.png) [@Liliana](https://community.dremio.com/u/Liliana)\ **Post date:** [December 16, 2024, 2:22pm UTC](https://community.dremio.com/t/dbt-dremio-1-8-0-connection-error-using-software-host/12580/7 "2024-12-16T14:22:30Z")
Hi @rdkworld Thanks for answering and sorry for the late response. In this case we would need to check more in detail in order to help you. Could you please help us reproduce the error? > **Current Behavior** > _Please provide us more information regarding the current behavior, i.e., how you made it work through POSTMAN / Python requests; a network capture if possible; the configuration details; etc_ > > **Steps To Reproduce** > _Please guide us in order to reproduce the error in our side_ > > Environment > > - OS: … > - dbt-dremio: … > - Dremio Software: … > - Dremio Cloud: … > > **Relevant log output** > …