onBefore Transform Scripts Should Only Update The Target Table

< 1 min read

Impact Area

Performance

Severity

High

Affected Element

Transform script

Rule ID

SN-0171

Impact #

Updates on other tables from onBefore Transform Scripts will be committed even if the update on the target table fails. This can cause data inconsistencies. Even if successful, the source of the update on the other table may become confusing.

Remediation #

Avoid updating other tables on onBefore Transform Scripts.

Time to fix #

15 min

Updated on March 21, 2025
Table of contents
Was it helpful ?