target_entity_attribute_list_with_transform_cast_parquet

Target database: Snowflake

Resolves as full target entity attribute list having the transformations based on the first SOURCE entity mapping. One-to-one mappings without transformation formula will be translated as single-level parquet column references with datatype in select context.

See also:

Variables

Usage

VARIABLE

<target_entity_attribute_list_with_transform_cast_parquet>

Notes

Supported in all loads.

Examples

Variable used in an OVERRIDE load step

Given mapping:

Target entity: publish.F_RATECODE

Source entity: src.SOURCE

source attributes	Formula	Target attribute
attribute_a		attribute_a
attribute_b		attribute_b
attribute_c		attribute_c

OVERRIDE load step in F_RATECODE entity:

SQL

INSERT INTO <target_schema>.<target_entity_name>
SELECT <target_entity_attribute_list_with_transform_cast_parquet>
FROM <source_entity_schema>.<source_entity_name>;

Load executed in the target database Snowflake:

SQL

INSERT INTO publish.F_RATECODE
SELECT $1::attribute_a::VARCHAR(50)
, $1::attribute_b::VARCHAR(50)
, $1::attribute_c::VARCHAR(50)
FROM src.SOURCE;