Qlik replicate Issue for Insert and Update scenario

[gopikrishnan06]

Hi team, 

Adding new column as add column as audit created datetime for insert, Audit updated datetime for the update.

When ever i get the insert command then it need to change the audit created date time. When ever i get the update command it change the audit updated date time.

But here it not working.. When i get insert or update it change the audit created date time alone..

Code: 

Audit created date time i used.

Column 'audit_created_datetime', data type DATETIME(6)
        Value: $AR_H_TIMESTAMP

Audit updated Date time i used

Add column
	for %.%
	Column 'audit_last_updated_datetime', data type DATETIME(6)
        Value: datetime('now', 'UTC')

 Kindly confirm the best one..

Whenever i need to get insert the current timestamp need to get it..

whenever i need to get update the current timestamp need to get it..

[gopikrishnan06]

Hi All,

Here i check with Qlik support and said as this Data enrichment not supported in the Qlik version for 2024 and 2025 version too..

so i manually  added the audit_created_datetime column in the Databricks Delta table with current timestamp.

ALTER TABLE xxx ADD COLUMN audit_created_datetime TIMESTAMP;
ALTER TABLE xxx SET TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported');
alter table xxx alter column audit_created_datetime set default current_timestamp();

when ever the INSERT happen at Qlik replicate even it not showing the current timestamp for the column audit_created_timestamp.. 

Kindly correct me if any wrong