Clever Geek Handbook

Is it more economical to use views in BigQuery instead of plain SQL?

You pay for the size of the requested data. So what would be a better alternative to using views in terms of cost?

+3


source to share


1 answer


Views are not implemented in bigquery (currently), so the cost of a query from a view is identical to writing a more complex query on the base table.



You can, of course, create your own "materialized views" by running the query and saving it as a table. You can then run subsequent queries against that table. This can be more economical if the stored table is smaller than the base table. However, it takes a little more manual bookkeeping.

+5


source






More articles:


All Articles