# SQL Data Warehouse connection issue

**URL:** <https://community.dremio.com/t/sql-data-warehouse-connection-issue/3733>\
**Category:** Uncategorized\
**Created:** [July 23, 2019, 1:25pm UTC](https://community.dremio.com/t/sql-data-warehouse-connection-issue/3733 "2019-07-23T13:25:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![damiencoueron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/damiencoueron/32/1496_2.png) [@damiencoueron](https://community.dremio.com/u/damiencoueron)\
**Post date:** [July 23, 2019, 1:25pm UTC](https://community.dremio.com/t/sql-data-warehouse-connection-issue/3733/1 "2019-07-23T13:25:49Z")

</div>

I can’t see any SQL Data Warehouse schema/table when connecting with Dremio.  
If I don’t specify a database, I can only see the master db and if I specify a database I can see nothing.

I made sure that my SQL Server login works by trying other db tools (Azure Data Studio).  
And I also tried specifying a fake database in Dremio and it generates an error.

It means that Dremio accepts the database and login I provide but It won’t show me a list of schema or tables.

Any idea ?

---

<div class="post-metadata">

**Author:** ![damiencoueron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/damiencoueron/32/1496_2.png) [@damiencoueron](https://community.dremio.com/u/damiencoueron)\
**Post date:** [July 24, 2019, 7:46pm UTC](https://community.dremio.com/t/sql-data-warehouse-connection-issue/3733/2 "2019-07-24T19:46:04Z")

</div>

Anyone with an idea?  
Are there specific roles to assign the user for dremio ?

---

<div class="post-metadata">

**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:** [July 24, 2019, 11:42pm UTC](https://community.dremio.com/t/sql-data-warehouse-connection-issue/3733/3 "2019-07-24T23:42:36Z")

</div>

@damiencoueron

What version of Dremio is this? Do you have server.log you can attach?

Thanks  
@balaji.ramaswamy

---

<div class="post-metadata">

**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:** [July 25, 2019, 3:54pm UTC](https://community.dremio.com/t/sql-data-warehouse-connection-issue/3733/4 "2019-07-25T15:54:36Z")

</div>

@damiencoueron

Looks like currently we do not support SQL datawarehouse. This is something on the roadmap that our product management team is looking at

Thanks  
@balaji.ramaswamy

---

<div class="post-metadata">

**Author:** ![damiencoueron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/damiencoueron/32/1496_2.png) [@damiencoueron](https://community.dremio.com/u/damiencoueron)\
**Post date:** [July 25, 2019, 10:49pm UTC](https://community.dremio.com/t/sql-data-warehouse-connection-issue/3733/5 "2019-07-25T22:49:14Z")

</div>

Are you sure ?

There is a tutorial about SQL Data Warehouse on Dremio website here: [https://www.dremio.com/tutorials/adls-dremio-powerbi/](https://www.dremio.com/tutorials/adls-dremio-powerbi/)

And one of your users had an issue with SQL Data Warehouse that you resolved in 2017 here: [Connection Issue with Azure SQL Data Warehouse](https://community.dremio.com/t/connection-issue-with-azure-sql-data-warehouse/500)