# Issue with Superset with Dremio

**URL:** <https://community.dremio.com/t/issue-with-superset-with-dremio/5884>\
**Category:** Dremio University\
**Created:** [July 9, 2020, 6:06pm UTC](https://community.dremio.com/t/issue-with-superset-with-dremio/5884 "2020-07-09T18:06:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shrikanth](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@shrikanth](https://community.dremio.com/u/shrikanth)\
**Post date:** [July 9, 2020, 6:06pm UTC](https://community.dremio.com/t/issue-with-superset-with-dremio/5884/1 "2020-07-09T18:06:37Z")

</div>

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](http://sqlalche.me/e/e3q8))

Attached are the screenshot

Can anyone help me out on this

 ![Screenshot from 2020-07-09 23-38-27](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/0/0fd2773b95485a0b764b563aac1daa6b912f94eb.png)

---

<div class="post-metadata">

**Author:** ![shrikanth](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@shrikanth](https://community.dremio.com/u/shrikanth)\
**Post date:** [July 10, 2020, 4:20pm UTC](https://community.dremio.com/t/issue-with-superset-with-dremio/5884/2 "2020-07-10T16:20:07Z")

</div>

I am able to resolve it. Issue seems to be with different configured jdbc port in aws