CodeNeat

SQL Formatter for BigQuery

Your data never leaves your browser

BigQuery includes STRUCT, ARRAY, and wildcard tables.

Example

SELECT user_id, ARRAY_AGG(STRUCT(event_name, timestamp)) as events, COUNT(DISTINCT session_id) as sessions FROM `project.analytics.events_*` WHERE _TABLE_SUFFIX BETWEEN '20260401' AND '20260413' GROUP BY user_id LIMIT 1000;
Try Sql Formatter Now

Tips

  1. 1Backtick project.dataset.table preserved.
  2. 2Format CTEs for analytics.
  3. 3UPPERCASE keywords.

Frequently Asked Questions

BQ syntax?

STRUCT, ARRAY_AGG, UNNEST, wildcards.

Scripting?

SQL formats. Variables: basic support.

Safe?

Yes. Queries stay in browser.