[GitHub] [superset] npc2kor opened a new issue, #21880: Unable to Connect to Dremio Lakehouse

[GitBox <gi...@apache.org>]

npc2kor opened a new issue, #21880:
URL: https://github.com/apache/superset/issues/21880

   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:32010/dremio
   - dremio://admin: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.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org

[GitHub] [superset] npc2kor closed issue #21880: Unable to Connect to Dremio Lakehouse

[GitBox <gi...@apache.org>]

npc2kor closed issue #21880: Unable to Connect to Dremio Lakehouse
URL: https://github.com/apache/superset/issues/21880


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org