Google BigQuery Standard SQL Formatter

100% Client-Side Private — Zero Server Uploads

Format Google Cloud BigQuery Standard SQL queries with UNNEST(), STRUCT, ARRAY_AGG, EXCEPT, and backtick table identifiers.

🔒 100% Client-Side: Dữ liệu được xử lý trực tiếp trên trình duyệt và không bao giờ rời khỏi thiết bị của bạn (Zero Server Uploads).

E-E-A-T Security Proof →

Interactive Workspace

SQL Dialects:Standard SQL PostgreSQL (JSONB)Google BigQuery Oracle PL/SQL Snowflake SQL

Ctrl+Enter

Input SQL Query

Ctrl+Enter to format560 chars

select event_date, user_pseudo_id, (select value.string_value from unnest(event_params) where key = 'page_location') as page_url, (select value.int_value from unnest(event_params) where key = 'engagement_time_msec') as engagement_ms, device.category as device_category, geo.country as country from `bigquery-public-data.ga4_obfuscated_sample_ecommerce.events_*` where _table_suffix between '20260101' and '20260131' and event_name in ('page_view', 'purchase') qualify row_number() over (partition by user_pseudo_id order by event_timestamp desc) = 1 limit 100;

Formatted SQL Result

SELECT
  event_date,
  user_pseudo_id,
  (
    SELECT
      value.string_value
    FROM
      UNNEST (event_params)
    WHERE
      key = 'page_location'
  ) AS page_url,
  (
    SELECT
      value.int_value
    FROM
      UNNEST (event_params)
    WHERE
      key = 'engagement_time_msec'
  ) AS engagement_ms,
  device.category AS device_category,
  geo.country AS country
FROM
  `bigquery-public-data.ga4_obfuscated_sample_ecommerce.events_*`
WHERE
  _table_suffix BETWEEN '20260101' AND '20260131'
  AND event_name IN ('page_view', 'purchase')
QUALIFY
  row_number() OVER (
    PARTITION BY
      user_pseudo_id
    ORDER BY
      event_timestamp DESC
  ) = 1
LIMIT
  100;

Share & Developer Embed

How do I use Google BigQuery Standard SQL Formatter?

Paste your Google Cloud BigQuery Standard SQL query into the left editor (or inspect the pre-loaded GA4 `UNNEST(event_params)` sample).

Verify that the SQL Dialect is pre-selected to 'Google BigQuery' with 2-space indentation.

Inspect the formatted output on the right with properly indented `UNNEST(...)`, `STRUCT(...)`, and backtick table references.

Click 'Copy' to paste the clean query back into the GCP BigQuery Console, Looker Studio, or your `dbt` model.

What features does Google BigQuery Standard SQL Formatter offer?

Pre-configured for Google Cloud BigQuery Standard SQL (`bigquery` dialect)

Preserves backtick-quoted multi-part identifiers (`` `analytics-prod-2026.ga4.events_*` ``)

Cleanly indents nested `UNNEST(event_params)` subqueries for GA4 and Firebase analytics

Supports BigQuery-specific `SELECT * EXCEPT(...) REPLACE(...)`, `SAFE_DIVIDE`, and `QUALIFY` window filtering

Pre-loaded with a real-world Google Analytics 4 (`ga4_obfuscated_sample`) `UNNEST` query

100% Client-Side execution: GCP project IDs and warehouse schemas never leave your browser

Google BigQuery Standard SQL Syntax & Nested Array Formatting

BigQuery stores repeated records as native `ARRAY<STRUCT<...>>` columns rather than normalized join tables, requiring specialized `UNNEST` and `STRUCT` formatting.

BigQuery Standard SQL Constructs Supported
BigQuery Construct	Syntax Pattern	Primary Analytics Use Case	Formatter Behavior
Backtick Table IDs	`project.dataset.events_*`	Wildcard date-sharded tables	Preserves hyphens & dots inside backticks
UNNEST() Flattening	(SELECT value.string_value FROM UNNEST(event_params))	GA4 & Firebase event extraction	Indents correlated scalar subqueries
Column Projection	SELECT * EXCEPT(ssn, ip_address)	PII removal in analytical views	Keeps EXCEPT/REPLACE inline with SELECT
Window QUALIFY	QUALIFY ROW_NUMBER() OVER (...) = 1	Deduplicating streaming inserts	Aligns QUALIFY as a top-level clause

How is Google BigQuery Standard SQL Formatter used in real-world workflows?

Growth & Marketing Data Analysts

Untangling Complex GA4 `event_params` & `user_properties` Queries

Google Analytics 4 exports deeply nested `UNNEST(event_params)` subqueries—format 200-line GA4 funnel queries into readable, indented blocks.

Analytics Engineers (dbt & Looker)

Formatting BigQuery `ARRAY_AGG` and `STRUCT` Models

Clean up nested `ARRAY_AGG(STRUCT(...))` warehouse transformations before committing `.sql` models to your dbt repository.

Cloud FinOps & Data Warehouse Admins

Auditing Queries to Prevent Full-Table Scan Cost Spikes

Format ad-hoc analyst queries to quickly verify that `_TABLE_SUFFIX` or partition filters are present and `SELECT *` is replaced with explicit columns.

Frequently Asked Questions about Google BigQuery Standard SQL Formatter

Why does BigQuery use backticks (`` ` ``) around table names?

Google Cloud Project IDs frequently contain hyphens (e.g., `my-company-prod.analytics.events`). Without backticks, standard SQL parsers interpret the hyphen as a minus subtraction operator. Our BigQuery formatter preserves backtick-quoted identifiers intact.

Does this formatter support BigQuery `QUALIFY` and `SELECT * EXCEPT()`?

Yes! The `bigquery` dialect engine recognizes Google Standard SQL extensions including `QUALIFY`, `EXCEPT()`, `REPLACE()`, `SAFE_CAST()`, and `STRUCT<...>()`.

How do I reduce BigQuery slot usage and query costs when writing SQL?

Never run `SELECT *` on a columnar warehouse like BigQuery (which bills by bytes scanned per column). Always project only required columns or use `SELECT * EXCEPT(heavy_payload)` and filter on partitioned date columns.

Are my GCP Project IDs or BigQuery datasets uploaded anywhere?

No. Everything runs 100% locally in your browser using client-side JavaScript.

Explore Related SQL Tools

Browse all SQL tools

SQL

Snowflake SQL Formatter

Format Snowflake Data Cloud SQL queries including LATERAL FLATTEN, VARIANT semi-structured paths (v:attr::string), and QUALIFY clauses.

SQL

PostgreSQL Query Formatter

Format and beautify PostgreSQL queries including WITH CTEs, JSONB operators (->>, @>), :: type casts, and window functions.

SQL

Oracle PL/SQL Formatter

Indent and beautify Oracle PL/SQL stored procedures, DECLARE...BEGIN...EXCEPTION...END blocks, packages, and %TYPE declarations.

SQL

SQL Formatter

Format and beautify SQL queries with support for multiple dialects including PostgreSQL, MySQL, SQLite, and more.

JSON

JSON Formatter

Format, validate, and minify JSON data instantly. Detect syntax errors with precise line and column information.

Developer

Mock Data Generator

Generate realistic fake data for testing: JSON, CSV, SQL, XML with 50+ field types — names, emails, UUIDs, dates, addresses. Runs 100% in your browser via Web Worker.