My apologies - was deleting from and loading different databases that contained user details. Whoops. Thanks Colin.
Wondered if you could please help explain another issue however?
We have ‘users’ and ‘shops’ collections. When creating a user, it should add a row to the shops database, however it frequently creates multiple ‘shops’ for the same user account (see phone number column in picture) with different id’s.
(I’m loading the shops collection into BigQuery instead of the users collection because of ease of joining with other tables, otherwise the solution would be to just load the users collection!)
Do you know why this is happening? Thanks!