Table chunking for database comparison

A system, comprising:

• one or more memories collectively containing one or more programs;
• and
• one or more processors, wherein the one or more processors are configured to, individually or collectively, perform an operation comprising:
• receiving a pair of datasets comprising a source dataset and a target dataset;
• determining that a data partition configuration table has been defined for the pair of datasets, wherein the data partition configuration table comprises one or more partitioning rules for dividing the source dataset and the target dataset into one or more partitions;
• in response to the determination:
• identifying one or more partitioning attributes within the pair of datasets based on the one or more partitioning rules, and
• determining boundary values for each of the one or more partitioning attributes to define the one or more partitions;
• generating a query for each partition, the query comprising instructions to retrieve data from the source dataset and the target dataset for each partition based on the one or more partitioning attributes and the corresponding boundary values;
• and
• performing a data comparison between pair of datasets based on the query.

One or more computer-readable media containing, in any combination, computer program code that, when executed by a computer system, performs an operation comprising:

• receiving a pair of datasets comprising a source dataset and a target dataset;
• determining that a data partition configuration table has been defined for the pair of datasets, wherein the data partition configuration table comprises one or more partitioning rules for dividing the source dataset and the target dataset into one or more partitions;
• in response to the determination:
• identifying one or more partitioning attributes within the pair of datasets based on the one or more partitioning rules, and
• determining boundary values for each of the one or more partitioning attributes to define the one or more partitions;
• generating a query for each partition, the query comprising instructions to retrieve data from the source dataset and the target dataset for each partition based on the one or more partitioning attributes and the corresponding boundary values;
• and
• performing a data comparison between pair of datasets based on the query.