Polybase create external datasource giving syntax error

Question

I'm trying to execute the following command in Azure Data Warehouse:

CREATE EXTERNAL DATA SOURCE Brand WITH (TYPE=HADOOP, LOCATION ='wasbs://[email protected]' CREDENTIAL = StorageCred);

And I get this error message:

Incorrect syntax near 'HADOOP'.

I've tried it with and with the command after hadoop, nothing seems to work. Azure Data Warehouse reports version 13.0.400 and I've tried with two versions of SQL Management Studio with the most recent being version 13.0.600.65

Answer 1

It sounds to me like you're not actually getting the command to Azure SQL DW. Look at what I recommended to this guy, and use SSDT instead of SSMS, and see if that resolves it for you. https://stackoverflow.com/a/32693813/144351

Answer 2

This can also be caused by using Serverless SQL Pool incorrectly as it does not support writing so cannot be used as a sink, it also cannot be used with the "Staging" option.