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

1

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

2

Hi @pushkin23

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

Thanks
@balaji.ramaswamy

3

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


Can you please check.

4

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

1 Like