I have an API based source connector which pulls JSON, with a basic DBT normalisation auto normalises nested JSON structures into separate tables. That's great, however I cannot for the life of me figure out how to join these tables back together - there is some sort of hash

_airbyte_ab_id

, but I cannot see how to join on that key. Can anyone advise how to join normalised JSON post airbyte run? I must be missing something obvious I'm using airbyte latest, connected to snowflake

we can use _airbyte_<table_name>_hashid to join the parent and child table • `_airbyte_<table_name>_hashid`: hash value assigned by airbyte normalization derived from a hash function of the record data.