Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.