source_entity_attribute_list
Target database: Snowflake, Azure Synapse SQL, Microsoft Fabric, Google BigQuery, Databricks SQL
Resolved as a comma-separated list of attributes of the first source entity mapped as SOURCE in file load execution.
See also:
Usage
<source_entity_attribute_list>
Notes
Supported in file loads,transform_persist and transform_sql_view.
Examples
Snowflake: Variable used in OVERRIDE_FILE_LOAD
<source_entity_attribute_list> is resolved as a comma-separated list of source entity attributes in their positional order, for example:
ratecodeid, description
File load customized with OVERRIDE_FILE_LOAD:
COPY INTO ...
(<source_entity_attribute_list>)
FROM ...
...
;
File load executed in Snowflake:
COPY INTO ...
(ratecodeid, description)
FROM ...
...
;
Azure Synapse SQL and Microsoft Fabric: Variable used in OVERRIDE_FILE_LOAD
<source_entity_attribute_list> is resolved as a comma-separated list of source entity attributes in their positional order, for example:
(ratecodeid, description)
File load customized with OVERRIDE_FILE_LOAD:
COPY INTO ...
<source_entity_attribute_list>
FROM ...
WITH (...);
File load executed in Azure Synapse SQL:
COPY INTO ...
(ratecodeid, description)
FROM ...
WITH (...);
Databricks SQL: Variable used in TRANSFORM_PERSIST
<source_entity_attribute_list> is resolved as a comma-separated list of source entity attributes in their positional order, for example:
(ratecodeid, description)
File load customized with TRANSFORM_PERSIST:
INSERT INTO ...
SELECT <source_entity_attribute_list> FROM <source_entity_schema>.<source_entity_name>
File load executed in Databricks SQL:
INSERT INTO ...
SELECT ratecodeid, description FROM source.ENTITY
Google BigQuery: Variable used in TRANSFORM_PERSIST
<source_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 TRANSFORM_PERSIST:
INSERT INTO ...
SELECT <source_entity_attribute_list> FROM <source_entity_schema>.<source_entity_name>
File load executed in BigQuery SQL:
INSERT INTO ...
SELECT ratecodeid, description FROM source.ENTITY