Specifies whether to delete only the data file or all files that the SAS/ACCESS engine creates for the DBMS bulk-load facility.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | YES |
| Requirement: | To specify this option, you must also set BULKLOAD=YES or BULKUNLOAD=YES. |
| Data source: | Amazon Redshift, Google BigQuery, Microsoft SQL Server, Snowflake, Spark |
| Notes: | Support for Microsoft SQL Server was added in SAS 9.4M7. |
| Support for Snowflake and Spark was added in SAS 9.4M9. | |
| See: | BL_DATAFILE= data set option, BL_DELETE_DATAFILE= data set option, BL_DELETE_ONLY_DATAFILE= data set option, BL_USE_MANIFEST data set option, BULKLOAD= data set option |
Table of Contents
deletes all (data, control, and log) files that the SAS/ACCESS engine creates for the DBMS bulk-load facility.
does not delete these files.
Amazon Redshift: Setting BL_DELETE_DATAFILES=YES deletes data files that are created during the bulk retrieval process. If BL_USE_MANIFEST=YES, then manifest files are deleted as well. Files are deleted from the local machine and from the S3 bucket.
Microsoft SQL Server: This option is used when Microsoft SQL Server loads data to Azure Synapse Analytics (SQL DW) with an Azure Data Lake Storage Gen2 storage account. For more information, see Bulk Loading to Azure Synapse Analytics.
Spark: This option is used when the Spark engine bulk loads or bulk unloads data in Databricks. For more information, see Bulk Loading and Bulk Unloading with the Spark Engine.