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(‘<urllib3.connection.HTTPConnection object at 0x000002E878B37DF0>: Failed to establish a new connection: [WinError 10061] No connection could be made because the target machine actively refused it’))
@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?
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
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 and see if this helps!
Answering your questions, the port is indeed 9047 and dbt connects with Dremio through REST API.
@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
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