Skip to main content
Skip table of contents

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

VARIABLE
<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:

SQL
CREATE TEMP TABLE <target_schema>.<target_entity_name>_TMP
(<target_entity_attribute_list_with_transform_cast_exttable>);

Load executed in the target database Snowflake:

SQL
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:

SQL
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:

SQL
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:

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:

SQL
CREATE TEMP TABLE publish.F_RATECODE_TMP
(attribute_A VARCHAR(50)
, attribute_B VARCHAR(50)
, attribute_C VARCHAR(50)
);

JavaScript errors detected

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

If this problem persists, please contact our support.