Specifies an optional Amazon Web Services IAM role to use for the COPY command.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Categories: | Bulk Loading |
| Data Access | |
| Alias: | BL_ROLE= |
| Default: | none |
| Data source: | Spark |
| Note: | Support for this option was added in SAS 9.4M9. |
| See: | BL_KEY= LIBNAME option, BL_SECRET= LIBNAME option, BL_TOKEN= LIBNAME option |
| Example: |
|
Table of Contents
specifies the role value to use for the CREDENTIALS parameter in the AWS COPY command.
When BL_IAM_ROLE= is specified, the AWS COPY command uses the assigned value for the CREDENTIALS parameter. IAM roles are specified in the AWS environment using the following syntax. They are used as part of the authentication process.
aws_iam_role=arn:aws:iam::<AWS-account-ID>:role/<role-name>For BL_IAM_ROLE=, use the following syntax:
BL_IAM_ROLE='<AWS-account-ID>:role/<role-name>'Spark: This option is supported for bulk loading to Databricks in AWS. For more information, see Bulk Loading and Unloading to Databricks in Azure.