DataLakeTableUpsertExample
This is an example of a DataLakeObject as a table configured with 'UPSERT' as a refresh mode.
Columns
| Name | Type | ReadOnly | References | Description |
| cdp_sys_SourceVersion | String | False | ||
| contact_name | String | False | ||
| created_date | Datetime | False | ||
| Data_Source | String | False | ||
| Data_Source_Object | String | False | ||
| id [KEY] | String | False | ||
| is_new | Bool | False | ||
| KQ_id | String | False | ||
| modifie_date | Datetime | False | ||
| my_email | String | False | ||
| my_percent | Double | False | ||
| my_phone | String | False | ||
| my_url | String | False | ||
| shipAddress | String | False | ||
| taxExempt | String | False | ||
| tax_rate | Double | False | ||
| total | Double | False |
Pseudo-Columns
The following pseudo column fields are used in the Update and Upsert statements.
| Name | Type | Description |
| Overwrite | Bool |
When set to true, the Update and Upsert query will overwrite all fields in the row. If not set, or set to False, the provider will throw a warning message. |