Snowflake SQL Formatter
Paste a Snowflake query and get clean, readable SQL. Snowflake-specific syntax such as QUALIFY, FLATTEN and VARIANT path access is preserved, and :name bind variables are detected as parameters.
Snowflake syntax it handles
A generic formatter mangles dialect-specific syntax or refuses it outright. These are the Snowflake constructs this formatter is tested against.
QUALIFY Recognised as a clause boundary, so editing a WHERE never runs past it.
src:path.to.field VARIANT path access is preserved and is not mistaken for a :name bind variable.
:name Bind variables are detected and grouped as fillable parameters.
LATERAL FLATTEN(...) Semi-structured expansion keeps its clause shape.
Snowflake formatter FAQ
Does it support QUALIFY?
Yes. QUALIFY is treated as a proper clause, so it is formatted correctly and a WHERE clause you edit stops before it.
Will VARIANT paths be confused with bind variables?
Colon paths into semi-structured data are handled as part of the expression, so ordinary VARIANT access is not reported as a parameter.