sql-servert-sqlpolybase

How to check if External Tables (PolyBase objects) are supported on given SQL Server using just SQL query?

This may as well be named "How to check if PolyBase is installed on SQL Server using just SQL Query" (as those two are basically synonyms).

When PolyBase is not installed, you're not able to call CREATE EXTERNAL TABLE, DATA SOURCE or FILE FORMAT, etc.

How can you check beforehand if those server features are available, using just SQL Query?

Is there anything like SELECT SERVERPROPERTY('IsPolyBaseInstalled') for PolyBase component?

Solution

  • You will find some information with :

    SELECT * 
FROM   sys.configurations 
WHERE  name LIKE '%polybase%' COLLATE French_CI_AI;

    To enable PolyBase use sp_configure