target_entity_attribute_list_with_transform_cast_exttable
Target database: Snowflake, Azure SQL Database, Azure Synapse SQL, Google BigQuery, Databricks SQL,Amazon Redshift
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 with table creation column definition syntax.
See also:
Usage
<target_entity_attribute_list_with_transform_cast_exttable>
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 |
PRE load step in F_RATECODE entity:
CREATE TEMP TABLE <target_schema>.<target_entity_name>_TMP
(<target_entity_attribute_list_with_transform_cast_exttable>);
Load executed in the target database Snowflake:
CREATE TEMP TABLE publish.F_RATECODE_TMP
(attribute_a VARCHAR(50)
, attribute_b VARCHAR(50)
, attribute_c VARCHAR(50)
);
Load executed in the target database BigQuery:
CREATE TEMP TABLE publish.F_RATECODE_TMP
(attribute_a STRING(50)
, attribute_b STRING(50)
, attribute_c STRING(50)
);
Load executed in the target database Databricks:
CREATE TEMP TABLE publish.F_RATECODE_TMP
(attribute_a VARCHAR(50)
, attribute_b VARCHAR(50)
, attribute_c VARCHAR(50)
);
Load executed in the target database Azure SQL Database, Azure Synapse SQL:
CREATE TEMP TABLE publish.F_RATECODE_TMP
([attribute_a] NVARCHAR(50)
, [attribute_b] NVARCHAR(50)
, [attribute_c] NVARCHAR(50)
);
Load executed in the target database Redshift:
CREATE TEMP TABLE publish.F_RATECODE_TMP
(attribute_a VARCHAR(50)
, attribute_b VARCHAR(50)
, attribute_c VARCHAR(50)
);