Querylab.io documentation

A SQL IDE for BigQuery that shows the cost of a query while you write it. Start with connecting a project, then read the SQL Editor section, which is where most of the product lives.

-- the Console shows bytes; we show dollars
SELECT *
FROM `ace-analytics.warehouse.events`
WHERE event_date BETWEEN '2019-01-01' AND '2024-12-31'

Start here

• Connecting to BigQuery — sign in with Google or reuse local gcloud credentials; queries go from your device to BigQuery, never through Querylab.io.
• The Playground — the whole IDE on a sample project, no account, 1 GB per query.
• Keyboard shortcuts — the ones worth learning on day one.

The editor

• Auto-completions, hierarchical, ghost, and value completions — Querylab.io knows where your cursor is and what your schema holds.
• Cost limits and TABLESAMPLE — stop expensive queries before they bill; test on a sample for cents.
• Code quality — diagnostics and quick fixes: missing partition filters, SELECT * on large tables, undefined columns.
• Pipe syntax, charts, graph queries, dbt and Dataform.

Around the editor

• Prism AI — the agent that reads your schema, dry-runs its own SQL, and edits your query with your approval.
• Results and export — the grid, Json mode, Google Sheets, CSV.
• Schema browser — projects, datasets, tables, GA4 export shards, time travel, DDL.
• Notebooks, scheduling, sharing, data management.
• Desktop app — the same editor with credentials in your OS keychain.