01 — Overview
BigQuery is where many teams keep event data, marketing spend and product usage. Chamfer lets the people who act on that data do it in an app instead of a saved query. Describe the tool and the Bench builds it against your datasets: a churn-risk list for customer success, a spend tracker for marketing, a gauge log for a quality team.
Before each query runs, Chamfer checks its estimated scan size against the limit you set for that app. Partition filters are added where your tables support them, and results can be cached for minutes or hours. Scheduled Jobs can read BigQuery overnight and write a summary to Stockroom, Chamfer’s managed Postgres, so daytime screens stay fast. Access runs through a service account you control, and every query appears in the Logbook with its scan size and the person who ran it.
02 — What you can do
Scan limits
Chamfer estimates bytes scanned before each query and stops any over the app's limit.
Partition-aware SQL
Generated queries use partition and cluster filters where your tables have them.
Overnight summaries
Schedule a Job to roll large tables into small ones for fast daytime screens.
03 — FAQ
Before you connect BigQuery
How does Chamfer authenticate to BigQuery?
Can we cap what a query costs?
Does BigQuery row-level security still apply?
Can we join BigQuery with other sources?
04 — Pairs well with