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

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

SwathiPulagam — Wed, 29 Jun 2022 14:34:19 GMT

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:

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

Environment

Snowflake Target

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

igbins09 — Wed, 18 Oct 2023 01:41:03 GMT

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

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

Sonja_Bauernfeind — Wed, 18 Oct 2023 07:22:45 GMT

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