Tools10 min read
Snowflake vs BigQuery: Credits vs Bytes Scanned
The pricing models decide the architecture: warehouse-hours versus on-demand scans, plus multi-cloud vs GCP-native gravity.
- snowflake
- bigquery
- cost-optimization
Topic
#bigquery
4 posts ·view all posts
Tools
BigQuery9 min read
BigQuery Partitioning and Clustering: Stop Paying for Full Table Scans
BigQuery charges by bytes scanned. Learn how partitioning and clustering cut scan costs by 90%+, and the query patterns that silently bypass them.
- bigquery
- cost-optimization
- sql
BigQuery13 min read
How BigQuery Pruning Actually Works: Partition Metadata, Block Statistics, and the Shapes That Defeat Both
What BigQuery reads before it reads your data: partition metadata, Capacitor block statistics, and the specific query shapes that silently turn a pruned scan into a full one.
- bigquery
- performance
BigQuery13 min read
Cutting a BigQuery Bill: Partitioning, Byte Limits, Materialized Views, and On-Demand vs Editions
How I take a runaway BigQuery invoice apart: find the top jobs, fix pruning, cap bytes billed, use materialized views honestly, and decide when Editions beats on-demand.
- bigquery
- cost