Skip to main content
Skip table of contents

target_entity_attribute_list

Target database: Snowflake, Azure Synapse SQL

Resolved as a comma-separated list of target entity attributes in file load execution.


See also:


Usage

VARIABLE
<target_entity_attribute_list>

Notes

Supported in file loads.

List can be specified in the manifest columns property (SaaS, Private).


Examples

Snowflake: Variable used in OVERRIDE_FILE_LOAD

<target_entity_attribute_list> is resolved as a comma-separated list of attributes defined in a manifest, for example:

ratecodeid, description

File load customized with OVERRIDE_FILE_LOAD:

SQL
COPY INTO ...
(<target_entity_attribute_list>)
FROM ...
...
;

File load executed in Snowflake:

SQL
COPY INTO ...
(ratecodeid, description)
FROM ...
...
;

Azure Synapse SQL: Variable used in OVERRIDE_FILE_LOAD

<target_entity_attribute_list> is resolved as a comma-separated list of attributes in parentheses defined in a manifest, for example:

(ratecodeid, description)

File load customized with OVERRIDE_FILE_LOAD:

SQL
COPY INTO ...
<target_entity_attribute_list>
FROM ...
WITH (...);

File load executed in Azure Synapse SQL:

SQL
COPY INTO ...
(ratecodeid, description)
FROM ...
WITH (...);
JavaScript errors detected

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

If this problem persists, please contact our support.