Summary
After an Airbyte upgrade, the hashid in the ‘users’ table is no longer available for joining tables. How can the ‘profile’ be joined to ‘users’ in this scenario?
Question
Hi, how do we join 2 table from a mongodb collection (I have users with a profile entry converted into users and users_profile by Airbyte.
Before I could do INNER JOIN on _airbyte_users_hashid but SINCE the upgrade, the users table dont have this hashid anymore !
How can I join profile to users ?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.