target_entity_attribute_list_with_transform_cast_and_positions

Supported databases: Databricks SQL, Azure Fabric, Azure SQL Database, Azure Synapse SQL,Snowflake

First SOURCE type entity mapping will be used for the resolution of this variable. The one to one source-target attribute mappings without transformation will be added with their source entity position

See also:

• Variables

Usage

<target_entity_attribute_list_with_transform_cast_and_positions>

Notes

Supported only for 1-1 mappings.

For Azure databases will be resolving the position to support column list syntax defined in https://learn.microsoft.com/en-us/sql/t-sql/statements/copy-into-transact-sql .

For Databricks source column reference will be done through position in form _c<order> (indexing beginning from zero).

For Snowflake source column reference will be done through position in form $<order> (indexing beginning from one).

Examples

Variable used in an OVERRIDE load step

Given mapping:

Target entity: publish.D_RATECODE

Source entity: src.SOURCE

OVERRIDE load step in D_RATECODE entity:

insert into <target_schema>.<target_entity_name>
select <target_entity_attribute_list_with_transform_cast_and_positions>
from <source_entity_schema>.<source_entity_name>;

Load executed in the target database Snowflake:

insert into publish.D_RATECODE
select <timemillis> AS run_id,
       $4
from src.SOURCE;

Load executed in the target database Databricks:

insert into publish.D_RATECODE
select <timemillis> AS run_id,
       CAST(_c3 AS STRING) AS information
from src.SOURCE;

Load executed in the target database Microsoft Fabric, Azure SQL Database, Azure Synapse SQL:

insert into [publish].[D_RATECODE]
select <timemillis> AS [run_id],
       information 4
from [src].[SOURCE];