Snowflake to BigQuery SQL Converter

Translate Snowflake queries to BigQuery syntax with inline annotations. Free, 30 per hour.

FromTo

Hourly Limit: 0/30

Source SQL

SELECT user_id, LISTAGG(product, ', ') WITHIN GROUP (ORDER BY ts) AS items
FROM orders QUALIFY ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY ts) = 1;

Translated Result

Key Differences

•Snowflake features commonly rewritten: VARIANT type, QUALIFY clause.
•BigQuery equivalents: STRUCT / ARRAY literals, SAFE. prefix functions.
•Identifier quoting style differs — double quotes → double quotes.
•Date/time function names and casting semantics vary between Snowflake and BigQuery.