I am exporting my snowplow collections collected on Firebase using the extention Export Collections to BigQuery firestore-bigquery-export v0.1.10.
Whenever a document is created, updated, imported, or deleted in the specified collection, this extension sends that update to BigQuery. The columns of my interest are as follows.
I also have my events table on BigQuery which is created from the Integrations in Firebase and exports raw event data from Google Analytics from my app.
My Aim is to create a user_table with user details by joining these 2 tables in an ETL job which has Demographic Information and etc..
I am confused with the approach I need to take for creating this table.