I have 3 tables in BigQuery which have data constantly being appended. I want to create another table in BigQuery that is a join of these 3 tables, and I want the new table to be always updated. What’s a good solution to this?
1
For your requirement, you can consider using Scheduled Queries by incrementally updating the data to the new table. You need to create a Scheduled Query and configure it to append the data of the 3 tables to the new table and further set the interval of time to auto update the query.
You can also try creating Materialized View for better query performance. Create a Materialized view that automatically refreshes the data of the 3 tables to the new table within the certain interval of time provided.