Specifies an AWS IAM role name that enables you to connect to an Amazon S3 environment.
| Valid in: | DATA and PROC steps (when accessing data that is in an external data source) |
|---|---|
| Category: | Data Access |
| Default: | none |
| Requirement: | To use this option, you must first specify BULKLOAD=YES or BULKUNLOAD=YES. |
| Interaction: | If you specify both BL_IAM_ASSUME_ROLE_ARN= and BL_IAM_ASSUME_ROLE_NAME=, then the BL_IAM_ASSUME_ROLE_NAME= value is used. |
| Data source: | Amazon Redshift, Spark |
| Note: | Support for this option was added in SAS 9.4M9. |
| See: | BL_IAM_ASSUME_ROLE_ARN= data set option, BL_IAM_ASSUME_ROLE_NAME= LIBNAME option |
| Example: | BL_IAM_ASSUME_ROLE_NAME="eard" |
Table of Contents
specifies an AWS IAM role name that enables you to get access credentials for S3 via the AssumeRole IAM operation.
This option is used only when you are bulk loading data to AWS or bulk unloading data from AWS.
This option is used to access IAM role credentials in the Amazon S3 environment. If credentials are provided in more than one way, SAS/ACCESS retrieves values in the following order.
For example, if no value is set for the data set option but a value is set for the LIBNAME option, then SAS/ACCESS uses the LIBNAME option value. No further locations are checked.
For more information about S3 configuration, see PROC S3 Configuration in Base SAS Procedures Guide.
Spark: This option is supported for bulk loading to Databricks in AWS. For more information, see Bulk Loading and Unloading to Databricks in Azure.