I am facing issue while integrating dremio in superset through SQLAlchemy URI. I followed the documentation and installed corresponding dependencies.
Dependencies added in superset
RUN apt-get install -y alien build-essential libssl-dev libffi-dev python-pip libsasl2-dev libldap2-dev python3-pip python3-setuptools gcc
RUN apt-get update && apt-get install -y unixodbc-dev mdbtools odbcinst1debian2 libodbc1 odbcinst unixodbc # unixODBC unixODBC-bin unixODBC-dev gcc-c+
Deployed dremio(from marketplace) in aws ec2 instance and superset v0.35.2/0.36 in local through docker.
SQLAlchemy URI: “dremio://admin:admin@123@aws-ec2-instance:31010/dremio”
Issue: Unexpected response…Attached the screenshot
Deployed dremio(from docker hub) v4.5.0 and superset(from docker) v0.35.2/0.36
SQLAlchemy URI: dremio://admin:admin@123@localhost:31010/dremio
Issue : WARNING:superset.views.core:Connection failed (pyodbc.OperationalError) (‘08S01’, ‘[08S01] [Dremio][Connector] (20) Failure occurred while trying to connect to local=localhost:31010. (Details: [30001]Connection failure. Host:localhost port:31010. Error: Connection refused.) (20) (SQLDriverConnect)’)
(Background on this error at: http://sqlalche.me/e/e3q8)
Attached are the screenshot
Can anyone help me out on this
