Target database: Snowflake, Amazon Redshift
Resolved as data source credentials in file load execution.
Supported in file loads.
Snowflake file load with a storage integration
If a storage integration is defined with OPT_STORAGE_INTEGRATION, <source_credentials> is resolved as:
Snowflake load from ADE file load bucket/container
Note that it is recommended to use a storage integration instead.
Amazon Redshift load from ADE file load bucket/container
File load customized with OVERRIDE_FILE_LOAD:
COPY ... FROM ... <source_credentials> ... ;
File load executed in Amazon Redshift:
COPY ... FROM ... IAM_ROLE 'arn:aws:iam::<aws-account-id>:role/<role-name>' ... ;