| title | Server Configuration: allow polybase export |
|---|---|
| description | Set the configuration option to allow PolyBase export in SQL Server settings. |
| author | MikeRayMSFT |
| ms.author | mikeray |
| ms.reviewer | hudequei, randolphwest |
| ms.date | 08/26/2025 |
| ms.service | sql |
| ms.subservice | polybase |
| ms.topic | how-to |
[!INCLUDE sqlserver2016]
The allow polybase export server configuration option allows the export of data out of [!INCLUDE ssnoversion-md]. The functionality of this configuration option is different starting with [!INCLUDE sssql22-md] compared to previous versions:
-
In [!INCLUDE sssql22-md] and later versions, the CREATE EXTERNAL TABLE AS SELECT (CETAS) statement requires that you enable
allow polybase exportusingsp_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 [!INCLUDE sssql19-md] and earlier versions, enabling
allow polybase exportallows Hadoop to export data out of [!INCLUDE ssnoversion-md] 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.
EXECUTE sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXECUTE sp_configure 'allow polybase export', 1;
GO
RECONFIGURE;
GO