Specifies the Amazon Web Services access key that is used with key-based access control. If you are using temporary token credentials, this is the temporary access key ID.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | none |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | Amazon Redshift, Snowflake, Spark |
| Notes: | Support for this data set option was added in SAS 9.4M4. |
| Support for Snowflake was added in the August 2019 release of SAS/ACCESS. | |
| See: | BL_KEY= LIBNAME option, BULKLOAD= data set option |
Table of Contents
specifies an AWS key that you use to access the AWS environment.
You can see more information about managing access keys in the Amazon Web Services (AWS) documentation.
Spark: This option is supported for bulk loading to Databricks in AWS. For more information, see Bulk Loading and Unloading to Databricks in Azure.