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:

LOCATION = 'sqlserver://BigPinal:1433',
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 – External Data Sources

Based on my internet search, I found that the error message appears when you don’t have a PolyBase feature installed or it is not enabled via sp_configure.

To check if the feature is installed, you can use below T-SQL.

SELECT SERVERPROPERTY ('IsPolyBaseInstalled') AS IsPolyBaseInstalled; 

If you get zero as output, then the feature is not installed at all. The next step is to install the feature using setup.exe. Here is the feature which you need.

If you get the output as one (1) then you need to enable PolyBase using sp_configrure.

exec sp_configure @configname = 'polybase enabled', @configvalue = 1;

If the feature is not installed and try running above would cause this error

Msg 46923, Level 16, State 1, Procedure sp_configure, Line 166 [Batch Start Line 8]
PolyBase feature is not installed. Please consult Books Online for more information on this feature.

The command would run successfully when the feature is installed.

Did this blog help you in fixing the issue? If yes, please comment and let me know.

Here is the updated list for March 2020 of all the tools which I recommend. Do let me know if you use any of the above tools: SQL SERVER Tools I Use and Recommend (Updated: March 2020).

Reference: Pinal Dave (https://blog.sqlauthority.com)

, , , ,
Previous Post
SQL SERVER – What do These Messages Mean – “I/O is Frozen on Database” and “I/O was Resumed on Database”?
Next Post
SQL SERVER – LogonUserExEx Fails for User & GetToken – Logging on as the CNO Failed With Error 1326

Related Posts

1 Comment. Leave new

  • You can’t install polybase on more than one instance. What do you do if you need two instances (say test and dev) on the same server that both contain databases with polybase external tables? Is there any way to use the polybase installed on the first instance to create external data sources on the second instance?


Leave a Reply Cancel reply

Exit mobile version