Are project.dataset.table paths preserved?

Backtick-quoted table paths are handled by the BigQuery dialect and copied without renaming their contents. The sample includes `project.dataset.events`.

Does it support triple-quoted literals?

BigQuery triple-quoted literal text is recognized and protected. Newlines inside the literal are part of its value and are not compacted away.

Does it estimate scanned bytes or validate against BigQuery?

No. Formatting does not connect to a project, run a dry query or estimate scanned bytes. Check validity, permissions and query cost in your BigQuery environment.

BigQuery SQL Formatter

This page selects the BigQuery dialect and starts with an aggregate query over a backtick-quoted project.dataset.events table. Paste GoogleSQL statements and keep their quoted table paths and literal values while changing layout, keyword case and indentation. No BigQuery account, project connection or query execution is involved.

SQL dialect

SQL input150 characters

Formatted

Preparing current SQL output…

Output

Keywords

Indent

Formatting arranges SQL statements for the selected dialect. It does not execute queries, validate database objects or optimize performance. Stored procedures and client batch directives are outside this formatter’s scope. SQL stays in this browser. Your input and settings are remembered in local browser storage; Start over clears them.

Common questions

Are project.dataset.table paths preserved?: Backtick-quoted table paths are handled by the BigQuery dialect and copied without renaming their contents. The sample includes `project.dataset.events`.
Does it support triple-quoted literals?: BigQuery triple-quoted literal text is recognized and protected. Newlines inside the literal are part of its value and are not compacted away.
Does it estimate scanned bytes or validate against BigQuery?: No. Formatting does not connect to a project, run a dry query or estimate scanned bytes. Check validity, permissions and query cost in your BigQuery environment.

Formats SQL statements for the selected dialect; it does not execute SQL, check database objects, optimize queries or validate a complete SQL grammar. Stored procedures and client batch directives are outside its scope. Minify preserves comments and quoted values and can retain meaningful newlines.