Specifies the maximum completion time for a storage task, in seconds.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Bulk Loading |
| Default: | 60 |
| Data source: | Microsoft SQL Server, Snowflake, Spark |
| Notes: | Support for this option was added in SAS 9.4M7. |
| Support for Snowflake and Spark was added in SAS 9.4M9. | |
| See: | BL_TIMEOUT= data set option |
Table of Contents
specifies the maximum completion time for a storage task, expressed as a number of seconds. If the task does not complete within the specified time, the storage system might return an error.
This option is used to support bulk loading when you access Azure Synapse Analytics (SQL DW) using an Azure Data Lake Gen2 account.
Spark: This option is used to support bulk loading when you access Databricks in Azure using an Azure Data Lake Gen2 account. For more information, see Bulk Loading and Unloading to Databricks in Azure.