Materialize the Query Result for Performance
til/data/bigquery-materialize-query-results-for-performance.md Current Note ID: The unique ID of this note.
Materialize the query result for multistage queries to make your query faster and lower the costs.
Write the results to a table for multistage query it is costing to much data.
Many operations, such as
row_number, costs a lot more data than the selected columns. Writing to a destination table would save some data.
Planted: by L Ma;
BigQuery Meta Tables
Meta tables are very useful when it comes to get bigquery table information programmatically.
Generate a Column of Continuous Dates in BigQuery
Generate a table with a column of continuous dates
Lei Ma (2019). 'Materialize the Query Result for Performance', Datumorphism, 05 April. Available at: https://datumorphism.leima.is/til/data/bigquery-materialize-query-results-for-performance/.