# Superset to Dremio connectivity **URL:** \ **Category:** Uncategorized\ **Created:** [October 20, 2022, 6:47am UTC](https://community.dremio.com/t/superset-to-dremio-connectivity/9844 "2022-10-20T06:47:30Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![ramprasd89](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@ramprasd89](https://community.dremio.com/u/ramprasd89)\ **Post date:** [October 20, 2022, 6:47am UTC](https://community.dremio.com/t/superset-to-dremio-connectivity/9844/1 "2022-10-20T06:47:30Z")
Hi, We have hosted Dremio and Superset on an AKS Cluster in Azure and we are trying to connect Superset to the Dremio Database(Lakehouse) for fetching some dashboards. We have installed all the required drivers(arrowflight, sqlalchemy\_dremio and unixodc/dev) to establish the connection. Strangely we are able not able to connect to Dremio from the Superset UI using the connection strings: - dremio+flight://admin:[password@dremiohostname.westeurope.cloudapp.azure.com](mailto:password@dremiohostname.westeurope.cloudapp.azure.com):32010/dremio - dremio://admin:[adminpass@dremiohostname.westeurope.cloudapp.azure.com](mailto:adminpass@dremiohostname.westeurope.cloudapp.azure.com):31010/databaseschema.dataset/dremio?SSL=0 Here’s the error: `_(builtins.NoneType) None\n(Background on this error at: https://sqlalche.me/e/14/dbapi)", "error_type": "GENERIC_DB_ENGINE_ERROR", "level": "error", "extra": {"engine_name": "Dremio", "issue_codes": [{"code": 1002, "message": "Issue 1002 - The database returned an unexpected error."}]}}]_` However, while trying from inside the Superset pod, using this python script [here](https://github.com/dremio-hub/arrow-flight-client-examples/blob/main/python/example.py), the connection goes through without any issues. PS - One point to note is that, we have not enabled SSL certificates for our hostnames. ---
**Author:** ![ramprasd89](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@ramprasd89](https://community.dremio.com/u/ramprasd89)\ **Post date:** [October 28, 2022, 12:32am UTC](https://community.dremio.com/t/superset-to-dremio-connectivity/9844/2 "2022-10-28T00:32:37Z")
@lenoyjacob @balaji.ramaswamy - Hi Experts, Any suggestions here would be of much help. ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [October 30, 2022, 5:22pm UTC](https://community.dremio.com/t/superset-to-dremio-connectivity/9844/3 "2022-10-30T17:22:19Z")
@ramprasd89 Did you see the below already? > Also this Database error 1002 that is retuned seems very generic, can you check with Superset on how to get additional logging on this? ---
**Author:** ![shaggy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/shaggy/32/4520_2.png) [@shaggy](https://community.dremio.com/u/shaggy)\ **Post date:** [October 31, 2022, 4:39pm UTC](https://community.dremio.com/t/superset-to-dremio-connectivity/9844/4 "2022-10-31T16:39:56Z")
I have similar issue… I guess problem in sqlalchemy plugin… when I tried to connect trough from pyarrow import flight - its working ok, but when I tried get data using sqlalchemy(I guess Superset use the same method) I got an error E1031 18:32:27.780669000 8513643776 ssl\_utils.cc:590] load\_file: {“created”:“@1667226747.780654000”,“description”:“Failed to load file”,“file”:“/Users/voltrondata/github-actions-runner/\_work/crossbow/crossbow/vcpkg/buildtrees/grpc/src/85a295989c-6cf7bf442d.clean/src/core/lib/iomgr/load\_file.cc”,“file\_line”:72,“filename”:“/usr/share/grpc/roots.pem”,“referenced\_errors”:[{“created”:“@1667226747.780653000”,“description”:“No such file or directory”,“errno”:2,“file”:“/Users/voltrondata/github-actions-runner/\_work/crossbow/crossbow/vcpkg/buildtrees/grpc/src/85a295989c-6cf7bf442d.clean/src/core/lib/iomgr/load\_file.cc”,“file\_line”:45,“os\_error”:“No such file or directory”,“syscall”:“fopen”}]} E1031 18:32:27.780682000 8513643776 ssl\_security\_connector.cc:420] Could not get default pem root certs. E1031 18:32:27.780684000 8513643776 secure\_channel\_create.cc:88] Failed to create secure subchannel for secure name ‘localhost:32010’ E1031 18:32:27.780686000 8513643776 secure\_channel\_create.cc:48] Failed to create channel args during subchannel creation. E1031 18:32:27.780691000 8513643776 ssl\_security\_connector.cc:420] Could not get default pem root certs. E1031 18:32:27.780693000 8513643776 secure\_channel\_create.cc:88] Failed to create secure subchannel for secure name ‘localhost:32010’ E1031 18:32:27.780694000 8513643776 secure\_channel\_create.cc:48] Failed to create channel args during subchannel creation. ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/7/7f464655eee72d34f0b40e1c897133729737443a.jpeg)