Systems and methods for synchronization of data

Abstract

Computer-implemented systems and methods for synchronizing data for dataset execution. The system includes a source database that stores a canonical dataset, a secondary database that stores a processed dataset, and a synchronization server that comprises a processor and a memory. The processor is configured to monitor for a publication of one or more source tables and when the publication is detected, identify the processed tables, corresponding to the source tables, to be updated in the processed dataset. The processor determines a tolerance level corresponding to each processed table and updates the processed tables in the processed dataset. The tolerance level can be based on an execution requirement of a downstream application. In some embodiments, the downstream application can be a machine learning model. The processor determines whether the processed tables in the processed dataset were successfully updated within the tolerance levels and transmits a notification based on the determination.