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.

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.
• 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.
• Cost limits and TABLESAMPLE: stop expensive queries before they bill; test on a sample for cents.
• Code quality: warnings and quick fixes for 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, sharing, data management.
• Desktop app: the same editor with credentials in your macOS Keychain.

BigQuery concepts

How BigQuery itself works, with examples you can run on this site: how a query is billed, partitioning and clustering, arrays and UNNEST, dates and time zones, MERGE, scripting and more. See all BigQuery articles.