You can use a materialized view for that. https://cloud.google.com/bigquery/docs/materialized-views-intro