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
1.2 Populated XML Example
Last updated