Unable to create EXTERNAL TABLE to Azure SQL Server on Azure SQL Data Warehouse

Question

Unable to create EXTERNAL TABLE at Azure SQL Data Warehouse pointing to Azure SQL Server.

CREATE EXTERNAL DATA SOURCE EX_SOURCE
WITH ( 
    TYPE = RDBMS,
    LOCATION = 'SERVER.database.windows.net',
    DATABASE_NAME = 'DB_NAME',
    CREDENTIAL = "CREDENTIAL"
)
;

Responds with:

Incorrect syntax near 'RDBMS'

Does anyone know a workaround for this?

I also have tried to to do it the other way around. It allows me to create an EXTERNAL DATA SOURCE pointing to Azure SQL Data Warehouse from Azure SQL Server and to create EXTERNAL TABLE, but when I try to query it I get:

Error retrieving data from one or more shards.  The underlying error message received was: 'Parse error at line: 1, column: 36: Incorrect syntax near '='.'.

Matt Usher · Accepted Answer · 2015-11-09 19:09:15Z

2

Azure SQL Data Warehouse, today, only supports creating an external data source to Azure Blob Storage and Hadoop ('hdfs://') targets. The current external query syntax for Azure SQL Database does not support Azure SQL Data Warehouse.

answered Nov 9, 2015 at 19:09

Matt Usher

1,3256 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to create EXTERNAL TABLE to Azure SQL Server on Azure SQL Data Warehouse

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related