Specifies the location of the optional configuration file that the SAS communication layer uses to interact with the Amazon S3 tool.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Alias: | BL_CONFIG_FILE= [Snowflake] |
| Default: | none |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | Amazon Redshift, Snowflake, Spark |
| Note: | Support for Spark was added in SAS 9.4M9. |
| See: | BL_CONFIG= LIBNAME option, BULKLOAD= data set option |
| Examples: |
|
|
Table of Contents
specifies the host-specific directory path where the optional configuration file for communications with S3 is located.
The configuration file that you specify can contain options for communication with the Amazon S3 tool. The file format uses name=value syntax with one option per line. For example, you can specify the following S3 options in this file:
ssl=yes
keyId=access-key-ID
secret=secret-access-key
region=aws-region
sessionToken=temporary-tokenFor more information, see information about credentials on the Amazon Web Services website.
Spark: This option is supported for bulk loading to Databricks in AWS. For more information, see Bulk Loading and Unloading to Databricks in Azure.