Dremio Blog question https://www.dremio.com/blog/bi-dashboards-101-with-dremio-and-superset/

1

Hello,

I am following the Dremio blog BI Dashboards 101 with Dremio and Superset | Dremio , and trying to setup Superset.

I was able to standup Dremio on Docker containers, but unable to connect database from Superset into the local dremio container.

Specifically, I have a problem creating dremio database conenction from superset
The blog mentions, For Dremio Software

dremio+flight://dremio-username:dremio-password@host:32010/?UseEncryption=false

Accordingly, I configured the connection as,
dremio+flight://admin:Password1@localhost:32010/?UseEncryption=false

but unable to connect since Superset container could not connect to Dremio.

Screenshot 2024-12-10 at 5.27.03 PM
Screenshot 2024-12-10 at 5.27.03 PM3024×1494 494 KB

ERROR: (builtins.NoneType) None
[SQL: Flight returned unavailable error, with message: failed to connect to all addresses; last error: UNKNOWN: ipv4:127.0.0.1:32010: Failed to connect to remote host: Connection refused]
(Background on this error at: Error Messages — SQLAlchemy 1.4 Documentation)

Could you please let me know the right URI to be used in this case? I did read the complete blog but could not find a solution to this problem.

2

@Prathamesh I have pinged the author of this document and please ping back if no answer. Please give it time as it is Holidays time and response could be a little slow

3

I’d watch how I do it in the following video:

In your errors it looks like you are putting localhost as the host in the url (127.0.0.1) since this is on the docker network the superset container will see the Dremio container based on the name in the docker compose file so it would be something like (http://dremio:32710)

In the video above I walk through the whole local setup and explain it in detail.

4

Thank you Balaji and Alex.