Specifies the number of threads to use for bulk unloading from the DBMS into SAS.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | LIBNAME option value [Amazon Redshift, Google BigQuery] |
| none [Snowflake] | |
| Range: | 1–10 |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | Amazon Redshift, Google BigQuery, Snowflake |
| Note: | Support for Google BigQuery was added in SAS 9.4M7. |
| See: | BL_NUM_READ_THREADS= LIBNAME option, BULKUNLOAD= data set option, BULKUNLOAD= LIBNAME option |
Table of Contents
specifies the number of threads that are used to perform bulk unloading (retrieval) of data from a DBMS.