Specifies the maximum completion time for a storage task, in seconds.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Bulk Loading |
| Default: | LIBNAME option value |
| Data source: | Microsoft SQL Server, Snowflake, Spark |
| Notes: | Support for this data set option was added in SAS 9.4M7. |
| Support for Snowflake and Spark was added in SAS 9.4M9. | |
| See: | BL_TIMEOUT= LIBNAME 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.
Microsoft SQL Server: This option is used to support bulk loading when you access Azure Synapse Analytics (SQL DW) using an Azure Data Lake Gen2 account.
Snowflake: This option is used to bulk load or bulk unload compressed Parquet files that are stored in an Azure ADLS location. For more information, see Bulk Loading and Bulk Unloading Data Files in Azure ADLS Locations.
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.