bigquery auto update table

0
votes

I'm using firebase to collect the app data (one iOS and one Android) and linking to bigquery. so everyday the data will be collected on daily base, but I want everyday's data to be stored in one big table. basically after everyday's data is being collect, I want automatically query insert function to insert the new data(intraday table) into that big table?

1
firebasegoogle-bigqueryauto-update

1 Answers

1
votes
  1. Create a partitioned table
  2. Write a script that gets triggered to push the new data into the partitioned table from step 1.

https://cloud.google.com/bigquery/docs/partitioned-tables Schedule query in BigQuery