SQL SERVER – PolyBase Error Msg 46530 – External Data Sources Are Not Supported With Type GENERIC


 

While trying to try PolyBase on my laptop, I was getting an error. When I looked further, the solution was so different and the error message has no relation to it. In this blog, I would share my findings of error Msg 46530 – External data sources are not supported with type GENERIC.

Here is the query which I was executing:

CREATE EXTERNAL DATA SOURCE BigPinalSQLExternalData WITH ( LOCATION = ‘sqlserver://BigPinal:1433’, PUSHDOWN = ON, CREDENTIAL = RemoteCredentials );

and the error message was

Msg 46530, Level 16, State 11, Line 1
External data sources are not supported with type GENERIC.

Below is the screenshot.

WORKAROUND/SOLUTION –