Server configuration: allow polybase export

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:

• In SQL Server 2022 (16.x) and later versions, the CREATE EXTERNAL TABLE AS SELECT (CETAS) statement requires that you enable allow polybase export using sp_configure. This setting allows for data to be exported to a CSV or Parquet file. For examples, see Use CREATE EXTERNAL TABLE AS SELECT exporting data as parquet.

• In SQL Server 2019 (15.x) and earlier versions, enabling allow polybase export allows Hadoop to export data out of SQL Server to an external table. For more information, see PolyBase connectors and Export data.

The possible values are described in the following table:

Value	Meaning
0 (default)	Disabled
1	Enabled

This change takes effect immediately.

Examples

The following example enables this setting.

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

Related content

• Exporting data
• Data virtualization with PolyBase in SQL Server
• CREATE EXTERNAL TABLE AS SELECT (CETAS) (Transact-SQL)