Qlik Replicate: Transformation column INSERT_DATETIME is overwritten with Null value when record is updated in Snowflake Target

[SwathiPulagam]

Here is the general use case from many customers. 

Requirement:

Add 3 extra columns to the Snowflake target table like operation, inserted date, and updated date.

Operation: what was the operation performed on a specific record? It will be updated with INSERT or UPDATE or DELETE

Inserted date: The inserted date should be the current time when the record was inserted the first time and it must be unchanged after that.

Updated date: The Updated date must be updated when the record got an update.

Problem encountered: Operation and Updated date transformations are working fine but the Inserted date is updating with 'NULL' value when there is an update on record.

Resolution:

1. Add emptyFieldAsNull internal parameter to the snowflake endpoint.
   
   
   
   
2. Create a Global transformation as below to create INSERT_DATETIME column.
   
   
   
   
3. Reload the task. Insert a record and update the same record to monitor the INSERT_DATETIME column value.

Environment

Qlik Replicate 
Snowflake Target

[igbins09]

Hi, Pls what is the UPDATE transformation value that is already working?

[Sonja_Bauernfeind]

Hello @igbins09 

Please submit your question directly to the Qlik Replicate forum, including details about your requirements and potential issues you are facing.

All the best,
Sonja