Why do SQL scripts never run parallel?
Situation
Both DATPROF Privacy and Subset support the PARALLEL
setting. However, SQL scripts never run in parallel. Why is that?
Explanation
During execution, Privacy and Subset analyze which tables and columns are involved in masking or subsetting operations. To prevent data locking or consistency issues, operations on the same columns are not run in parallel.
But this logic doesn't apply to SQL scripts. Since Privacy and Subset cannot analyze the contents of custom SQL scripts, they cannot determine which tables or columns are being accessed. As a result, running scripts in parallel could lead to locking conflicts or inconsistent results.
Therefore, SQL scripts are always executed sequentially to ensure data integrity.