Hello team, I wonder what's the proper way to figure out the one-to-one mapping between the source and destination data? I know we have

_airbyte_ab_id

uuid in the destination db table, but how do I use the uuid to find out the original record in the source? Thanks!

Hello, It depends if you have identity / primary key in source data, so you can find relation between source data and airbyte data by primary key to get generated

_airbyte_ab_id

to track further row transformations. As an option, make a hash of the entire row and compare source and destination hash. But it can take too many resources and row hash must be unique by its nature. Also you can try Datuum.ai: it can’t compare rows at this moment, but provides a UI to see and manage your data, so you can see identity and relations in your data between tables and mapping between source and destination data.