| title | Allow PolyBase export configuration option | Microsoft Docs |
|---|---|
| description | Set `allow polybase export` configuration option in SQL Server settings |
| ms.custom | |
| ms.date | 07/10/2020 |
| ms.prod | sql |
| ms.prod_service | |
| ms.reviewer | |
| ms.technology | polybase |
| ms.topic | conceptual |
| author | MikeRayMSFT |
| ms.author | mikeray |
[!INCLUDE sqlserver2016]
allow polybase export server configuration option allows INSERT into a Hadoop external table.
This feature does not support insert into other external data sources.
The possible values are described in the following table:
| Value | Meaning |
|---|---|
| 0 | Disabled. This is the default setting. |
| 1 | Enabled |
The setting takes effect immediately.
The following example enables this setting.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'allow polybase export', 0;
GO
RECONFIGURE;
GO