Schema drift

Schema drift occurs when the same data exists in more than one repository and changes are made to one and not the others. For example, data can be loaded from a source into a cloud data warehouse (CDW) for analysis. Changes made to the source schema, such as addition or removal of a column or a data type change, must be detected and managed to keep the data synchronized in the CDW.