# 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.

Source: https://docs.querylab.io/

**Query 1 · 80 TB | ~$500**

```sql
SELECT *
FROM `ace-analytics.warehouse.events`
WHERE event_date BETWEEN '2019-01-01' AND '2024-12-31'
```

Dev mode: $0.05 (0.01% sample) · Save ~30% with reservations

## Start here

- [Connecting to BigQuery](https://docs.querylab.io/getting-started/connecting-to-bigquery/): sign in with Google or reuse local gcloud credentials.
- [The Playground](https://docs.querylab.io/getting-started/playground/): the whole IDE on a sample project, no account, 1 GB per query.
- [Keyboard shortcuts](https://docs.querylab.io/getting-started/keyboard-shortcuts/): the ones worth learning on day one.

## The editor

- [Auto-completions](https://docs.querylab.io/writing-sql/auto-completions/), [hierarchical](https://docs.querylab.io/writing-sql/hierarchical-completions/), [ghost](https://docs.querylab.io/writing-sql/ghost-completions/), and [value](https://docs.querylab.io/writing-sql/value-suggestions/) completions.
- [Cost limits](https://docs.querylab.io/writing-sql/cost-limits/) and [TABLESAMPLE](https://docs.querylab.io/writing-sql/tablesample/): stop expensive queries before they bill; test on a sample for cents.
- [Code quality](https://docs.querylab.io/writing-sql/code-quality/): warnings and quick fixes for missing partition filters, `SELECT *` on large tables, undefined columns.
- [Pipe syntax](https://docs.querylab.io/writing-sql/pipe-syntax/), [charts](https://docs.querylab.io/writing-sql/charts/), [graph queries](https://docs.querylab.io/writing-sql/graph-queries/), [dbt](https://docs.querylab.io/writing-sql/dbt-support/) and [Dataform](https://docs.querylab.io/writing-sql/dataform-support/).

## Around the editor

- [Prism AI](https://docs.querylab.io/prism-ai/introduction/): the agent that reads your schema, dry-runs its own SQL, and edits your query with your approval.
- [Results](https://docs.querylab.io/results/results-grid/) and [export](https://docs.querylab.io/results/export/): the grid, Json mode, Google Sheets, CSV.
- [Schema browser](https://docs.querylab.io/schema-browser/navigating-resources/): projects, datasets, tables, GA4 export shards, time travel, DDL.
- [Notebooks](https://docs.querylab.io/notebooks/), [sharing](https://docs.querylab.io/sharing/), [data management](https://docs.querylab.io/data-management/import/).
- [Desktop app](https://docs.querylab.io/desktop-app/): the same editor for macOS and Windows, with credentials in your OS keychain.

## BigQuery concepts

How BigQuery itself works, with examples you can run on this site: [how a query is billed](https://docs.querylab.io/bigquery/how-queries-are-billed/), [partitioning](https://docs.querylab.io/bigquery/partitioning/) and [clustering](https://docs.querylab.io/bigquery/clustering/), [arrays and UNNEST](https://docs.querylab.io/bigquery/unnest/), [dates and time zones](https://docs.querylab.io/bigquery/dates-and-times/), [MERGE](https://docs.querylab.io/bigquery/merge/), [scripting](https://docs.querylab.io/bigquery/scripting/) and more. See [all BigQuery articles](https://docs.querylab.io/bigquery/).