📂Cost Optimization

How to save money when querying using BigQuery.

Sometimes it can be expensive to query data from BigQuery, here are some tips on how to optimize costs.

1) Rarely use SELECT * Big query costs are based on the amount of data processed, selecting all columns results in every column being processed, which can be expensive

2) LIMIT 100 DOES NOT save costs! Big query costs are based on the amount of data process, not the size of the result. LIMIT doesn't reduce the amount of row scanning.

3) Apply filters as early and as often as you can Filters reduce the amount of data that has to be processed, directly reducing the cost

Source: https://cloud.google.com/blog/products/data-analytics/cost-optimization-best-practices-for-bigquery