Skip to main content
Skip table of contents

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.


Examples

Snowflake file load with a storage integration

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

STORAGE_INTEGRATION=example_storage_integration


Snowflake load from ADE file load bucket/container

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.


Amazon Redshift load from ADE file load bucket/container

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>'
...
;

Microsoft Fabric load from ADE file load bucket/container

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>')
...
;

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.