Specifies the AWS profile to use when there is more than one profile in the AWS configuration file.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Bulk Loading |
| Alias: | BL_AWS_PROFILE= |
| 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_AWS_PROFILE_NAME= LIBNAME option, BULKLOAD= data set option |
Table of Contents
specifies the profile to use if there is more than one profile in the AWS configuration file.
If you specify more than one profile in your AWS configuration file, then each profile has a name that is specified in square brackets. Here is a sample configuration file with two profiles, default and analyst.
[default]
region=us-west-2
output=text
[analyst]
region=us-east-1
output=jsonTo use the analyst profile, specify the following code.
data myclass (bulkload=yes
bl_bucket='myBucket/'
bl_aws_profile=analyst
);
set sashelp.class;
run;Spark: This option is supported for bulk loading to Databricks in AWS. For more information, see Bulk Loading and Unloading to Databricks in Azure.