The DML trigger delays DML actions so that they can be prevented. DML trigger is available for customers who want to audit before and after values when data changes occur. The DML trigger introduces latency, so it is recommended to use this feature sparingly.
On the DBMSs page, click the DBMS tab.
In the DBMS list, click the Edit Configuration icon
.png)
in the required row.Click the DML Triggers Configuration tab, then click Add New Trigger.
Select Use VA Credentials or provide username and password for the new trigger.
In the Trigger Display Name, enter the name to be displayed.
In Select DB drop-down list, select the database to apply the trigger.
In the Select Table drop-down list, select the table to apply the trigger.
In the Select Columns, select the column to apply the trigger.
In the Select DML CMD Type To Audit, select the Insert, Update and Edit to audit.
(Optional) In the Select Trigger Actions, select the Delay Transactions By and provide the required time period.
Click Create Triggers.