The case for and against. What BigQuery does well, and when it costs too much.
For. What works in its favour.
- Pay-per-use pricing with no minimum commitment, so a small project can run for free within the monthly quotas.
- Scales automatically to very large datasets without any infrastructure to provision or maintain.
Against. What to plan for.
- Query cost is hard to predict in advance and depends on how well tables are partitioned and clustered.
- Requires solid SQL and data-modeling skills; it is not usable without a technical background.