BigQuery to Snowflake SQL Converter

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

FromTo

Hourly Limit: 0/30

Source SQL

SELECT user_id, SAFE.PARSE_JSON(payload) AS p
FROM raw_events WHERE DATE(_PARTITIONTIME) = CURRENT_DATE();

Translated Result

Key Differences

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