# Objects not showing up when trying to connect to Azure Sql Data Warehouse

**URL:** <https://community.dremio.com/t/objects-not-showing-up-when-trying-to-connect-to-azure-sql-data-warehouse/4567>\
**Category:** Uncategorized\
**Created:** [November 14, 2019, 10:28am UTC](https://community.dremio.com/t/objects-not-showing-up-when-trying-to-connect-to-azure-sql-data-warehouse/4567 "2019-11-14T10:28:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![pushkin23](https://avatars.discourse-cdn.com/v4/letter/p/e9bcb4/32.png) [@pushkin23](https://community.dremio.com/u/pushkin23)\
**Post date:** [November 14, 2019, 10:28am UTC](https://community.dremio.com/t/objects-not-showing-up-when-trying-to-connect-to-azure-sql-data-warehouse/4567/1 "2019-11-14T10:28:22Z")

</div>

I am trying to connect Sql Data Warehouse service from Azure to Dremio and run queries on tables present in it. I have used Microsoft Sql Server as the source type.  
I am able to connect to the DWH however no objects show up (count shows as zero). Also i see below error in logs:

2019-11-14 10:23:43,103 [metadata-refresh-Azure\_Sql\_Dwh] ERROR c.d.e.s.j.d.a.ArpDialect$ArpSchemaFetcher - Error retrieving all tables for Azure\_Sql\_Dwh  
com.microsoft.sqlserver.jdbc.SQLServerException: Parse error at line: 3, column: 20: Incorrect syntax near ‘table’.  
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:254) ~[mssql-jdbc-7.0.0.jre8.jar:na]  
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1608) ~[mssql-jdbc-7.0.0.jre8.jar:na]  
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:859) ~[mssql-jdbc-7.0.0.jre8.jar:na]  
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:759) ~[mssql-jdbc-7.0.0.jre8.jar:na]  
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7240) ~[mssql-jdbc-7.0.0.jre8.jar:na]  
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2869) ~[mssql-jdbc-7.0.0.jre8.jar:na]  
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:243) ~[mssql-jdbc-7.0.0.jre8.jar:na]  
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:218) ~[mssql-jdbc-7.0.0.jre8.jar:na]  
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:688) ~[mssql-jdbc-7.0.0.jre8.jar:na]  
at com.dremio.exec.store.jdbc.dialect.arp.ArpDialect$ArpSchemaFetcher$ArpJdbcDatasetMetadataIterable.(ArpDialect.java:90)

Regards  
Pushkin

---

<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:** [November 14, 2019, 2:23pm UTC](https://community.dremio.com/t/objects-not-showing-up-when-trying-to-connect-to-azure-sql-data-warehouse/4567/2 "2019-11-14T14:23:21Z")

</div>

Hi @pushkin23

Currently we do not support SQL DW as a source and yet to build a connector

Thanks  
@balaji.ramaswamy

---

<div class="post-metadata">

**Author:** ![pushkin23](https://avatars.discourse-cdn.com/v4/letter/p/e9bcb4/32.png) [@pushkin23](https://community.dremio.com/u/pushkin23)\
**Post date:** [November 15, 2019, 12:29pm UTC](https://community.dremio.com/t/objects-not-showing-up-when-trying-to-connect-to-azure-sql-data-warehouse/4567/3 "2019-11-15T12:29:55Z")

</div>

Thanks for the reply. However below post does talk about connecting Azure SQL DWH as a source.

> **[Joining Azure SQL Data Warehouse and Azure Data Lake Store for Power BI](https://www.dremio.com/tutorials/adls-dremio-powerbi/)**
>
> Tutorial that helps users learn how to join data from ADLS and SQL Data warehouse using Dremio and Power BI.

  
Can you please check.

---

<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:** [November 15, 2019, 5:53pm UTC](https://community.dremio.com/t/objects-not-showing-up-when-trying-to-connect-to-azure-sql-data-warehouse/4567/4 "2019-11-15T17:53:46Z")

</div>

Hi @pushkin23

The Dremio SQL server connector used to connect to SQL DW until there was a change that prevented it from connecting. We are looking (in our roadmap) to add a dedicated SQL DW connector.

Some of our customers use data factory to move the data to ADLS and then use Dremio to query the lake. Would that work?

I have put in a request to take down the tutorial

Thanks  
@balaji.ramaswamy