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.
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/.