Set allow polybase export configuration option

Applies to: SQL Server 2016 (13.x) and later versions

The allow polybase export server configuration option allows the export of data out of SQL Server. The functionality of this configuration option is different starting with SQL Server 2022 (16.x) compared to previous versions:

The possible values are described in the following table:

Value Meaning
0 Disabled, the default setting.
1 Enabled

This change takes effect immediately.

Example

The following example enables this setting.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'allow polybase export', 1;
GO
RECONFIGURE;
GO

Next steps