Validation modes for dml statements

A method comprising:

• receiving a first query, the first query comprising a first set of statements, the first set of statements including at least a first statement for performing a first Data Manipulation Language (DML) operation on a first table;
• determining a set of rows that are modified based on performing the first DML operation on the first table, the set of rows including a first set of updated rows;
• generating a first delta file based on the determined set of rows, the first delta file comprising a first bitset to indicate a particular set of rows of the first table that have been deleted or updated, and a first set of updated rows;
• generating a first updated rows file based on the first set of updated rows;
• determining a second set of rows of the first table that have not been modified by performing the first DML operation on the first table;
• generating a first residual file based on the second set of rows that have not been modified;
• and
• performing a validation process to validate the first DML operation using at least the first delta file, the first residual file, and a matching CoW file;
• receiving a first query, the first query comprising a first set of statements, the first set of statements including at least a first statement for performing a first Data Manipulation Language (DML) operation on a first table;
• determining a set of rows that are modified based on performing the first DML operation on the first table, the set of rows including a first set of updated rows;
• generating a first delta file based on the determined set of rows, the first delta file comprising a first bitset to indicate a particular set of rows of the first table that have been deleted or updated, and a first set of updated rows;
• generating a first updated rows file based on the first set of updated rows;
• determining a second set of rows of the first table that have not been modified by performing the first DML operation on the first table;
• generating a first residual file based on the second set of rows that have not been modified;
• and
• performing a validation process to validate the first DML operation using at least the first delta file, the first residual file, and a matching CoW file.

A non-transitory computer-storage medium comprising instructions that, when executed by one or more processors of a machine, configure the machine to perform operations comprising:

• receiving a first query, the first query comprising a first set of statements, the first set of statements including at least a first statement for performing a first Data Manipulation Language (DML) operation on a first table;
• determining a set of rows that are modified based on performing the first DML operation on the first table, the set of rows including a first set of updated rows;
• generating a first delta file based on the determined set of rows, the first delta file comprising a first bitset to indicate a particular set of rows of the first table that have been deleted or updated, and a first set of updated rows;
• generating a first updated rows file based on the first set of updated rows;
• determining a second set of rows of the first table that have not been modified by performing the first DML operation on the first table;
• generating a first residual file based on the second set of rows that have not been modified;
• and
• performing a validation process to validate the first DML operation using at least the first delta file, the first residual file, and a matching CoW file.