Google BigQuery logo

Data warehouses

BigQuery

Connect BigQuery with a service account and build tools on the datasets your analysts already rely on. The Bench writes standard SQL against your schema, Chamfer estimates the bytes each query will scan, and anything over your limit is blocked. Results can feed forms, approvals and scheduled Jobs.

Data warehouses

BigQuery

Connect BigQuery with a service account and build tools on the datasets your analysts already rely on. The Bench writes standard SQL against your schema, Chamfer estimates the bytes each query will scan, and anything over your limit is blocked. Results can feed forms, approvals and scheduled Jobs.

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?

Connect one source and describe your first app

Create a free website with Framer, the website builder loved by startups, designers and agencies.