Snowflake Table Target XML Example

This page details an example Snowflake Target connection

1. XML Example

This example XML uses the following values:

Value	Description	Example
CONNECTIONS_STRING	The connections string for your target	"87E4lvPf83gLK8eKapH6Y0YqIFSNbFlq62uN9487"
TABLE_NAME	The name of your target table	"Users"
ID_COLUMN	The name of the identity column that exists in the target (OR a single column that is guaranteed to be unique and automatically populated for every new record).	"CINCHYID"
ID_DATA_TYPE	The data type of your ID Column	"Number"
SOURCE_COLUMN_NAME	The name(s) of your source column(s)	"Name"
TARGET_COLUMN_NAME	The name(s) of your target column(s)	"Employee_Name"
TARGET_SYNC_KEY	The Sync Key Column Reference of your target	"Employee_Name"
NEW_BEHAVIOUR	The behaviour for new records	"INSERT"
DROPPED_BEHAVIOUR	The behaviour for dropped records	"DELETE"
CHANGED_BEHAVIOUR	The behaviour for changed records	"UPDATE"

1.1 Blank XML Example

<SnowflakeTableTarget reconcileData="true" 
connectionString=“CONNECTIONS_STRING” table=“TABLE_NAME” idColumn=“ID_COLUMN” idDataType=“ID_DATA_TYPE”>
        <ColumnMappings>
            <ColumnMapping sourceColumn=“SOURCE_COLUMN_NAME” targetColumn=“TARGET_COLUMN_NAME”/>
        </ColumnMappings>
        <SyncKey>
            <SyncKeyColumnReference name=“TARGET_SYNC_KEY”/>
        </SyncKey>
        <NewRecordBehaviour type=“NEW_BEHAVIOUR”/>
        <DroppedRecordBehaviour type=“DROPPED_BEHAVIOUR”/>
        <ChangedRecordBehaviour type=“CHANGED_BEHAVIOUR”/>
        <PostSyncScripts/>
    </SnowflakeTableTarget>

1.2 Populated XML Example

<SnowflakeTableTarget reconcileData="true" 
connectionString="87E4lvPf83gLK8eKapH6Y0YqIFSNbFlq62uN9487" table=“Users” idColumn="CINCHYID" idDataType="Number">
        <ColumnMappings>
            <ColumnMapping sourceColumn=“Name” targetColumn=“Employee_Name”/>
        </ColumnMappings>
        <SyncKey>
            <SyncKeyColumnReference name=“Employee_Name”/>
        </SyncKey>
        <NewRecordBehaviour type="INSERT"/>
        <DroppedRecordBehaviour type="DELETE"/>
        <ChangedRecordBehaviour type="UPDATE"/>
        <PostSyncScripts/>
    </SnowflakeTableTarget>