Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
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
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Introduction to SQL Server 2022 data virtualization - Training
Learn about data virtualization, how to use Polybase to access and query external data, and enhanced Polybase features in SQL Server 2022.