| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|---|
Server configuration: allow polybase export |
Set the configuration option to allow PolyBase export in SQL Server settings. |
MikeRayMSFT |
mikeray |
hudequei, randolphwest |
07/18/2024 |
sql |
polybase |
conceptual |
[!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.
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'allow polybase export', 1;
GO
RECONFIGURE;
GO