source_encryption

Edition: Private

Target database: Snowflake

Resolved as encryption settings in file load execution. Specific encryption settings can be defined for the source bucket/container in a COPY INTO statement in Snowflake with the ENCRYPTION property. See Snowflake documentation.

See also:

• COPY INTO: Additional Cloud Provider Parameters (Snowflake documentation)

• File load bucket/container

• OVERRIDE_FILE_LOAD

• Variables

Notes

Supported in file loads.

This variable can be used when loading from the Agile Data Engine default file load bucket/container and special encryption settings have been set to that bucket/container. Encryption settings have to be defined in the Agile Data Engine installation.

Examples

Variable used in OVERRIDE_FILE_LOAD

File load customized with OVERRIDE_FILE_LOAD:

COPY INTO ...
FROM ...
<source_encryption>
...
;

File load executed in Snowflake:

COPY INTO ...
FROM ...
ENCRYPTION=(TYPE = ... )
...
;