| title | Allow PolyBase export configuration option |
|---|---|
| description | Set `allow polybase export` configuration option in SQL Server settings |
| author | WilliamDAssafMSFT |
| ms.author | wiassaf |
| ms.reviewer | mikeray |
| ms.date | 12/13/2022 |
| ms.service | sql |
| ms.subservice | polybase |
| ms.topic | conceptual |
[!INCLUDE sqlserver2016]
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 [!INCLUDEsssql22-md] compared to previous versions:
- Introduced in [!INCLUDEsssql22-md], the CREATE EXTERNAL TABLE AS SELECT (CETAS) statement requires the option
allow polybase exportto be enabled by usingsp_configure. This 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 previous versions of SQL Server, enabling
allow polybase exportallows 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 | Disabled, the default setting. |
| 1 | Enabled |
This change takes effect immediately.
The following example enables this setting.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'allow polybase export', 1;
GO
RECONFIGURE;
GO