What is the best practice regarding mapping data between the source and destination?

Hello team,

I am wondering what’s the best practice to map data between the source and destination? I know Airbyte destination connectors generally have the _airbyte_ab_id uuid in the destination db table, but how do I use that uuid to find out the original record in the source? Thanks for any tips.

Hey @pinglin, thanks for the question. The _airbyte_ab_id_ uuid in the destination table is a metadata column created during the destination normalization process. According to the docs: Basic Normalization | Airbyte Documentation, it’s just a random uuid and cannot be used to find the original record in the source.

What connector are you using for the source and does the data in your source use primary keys for the records?