source_credentials

Target database: Snowflake, Amazon Redshift, Microsoft Fabric

Resolved as data source credentials in file load execution.

See also:

Notes

Supported in file loads.

If a storage integration is defined with OPT_STORAGE_INTEGRATION, <source_credentials> is resolved as:

STORAGE_INTEGRATION=example_storage_integration

Edition: Private

<source_credentials> is resolved as the default file load bucket/container credentials in a single file load when a storage integration has not been defined with OPT_STORAGE_INTEGRATION.

AWS:

CREDENTIALS=(aws_key_id='\\\' aws_secret_key='\\\')

Azure:

CREDENTIALS=(azure_sas_token='\\\*')

Note that it is recommended to use a storage integration instead.

Edition: Private

<source_credentials> is resolved as the default file load bucket/container credentials in a single file load, for example:

File load customized with OVERRIDE_FILE_LOAD:

SQL

COPY ...
FROM ...
<source_credentials>
...
;

File load executed in Amazon Redshift:

SQL

COPY ...
FROM ...
IAM_ROLE 'arn:aws:iam::<aws-account-id>:role/<role-name>'
...
;

Edition: Private

<source_credentials> is resolved as the default file load bucket/container credentials in a single file load, for example:

File load customized with OVERRIDE_FILE_LOAD:

SQL

COPY ...
FROM ...
<source_credentials>
...
;

File load executed in Azure Synapse DW:

SQL

COPY ...
FROM ...
CREDENTIAL=(IDENTITY='SOURCE_DATA_WITH_SIGNATURE', SECRET='<secret>')
...
;