Databricks to BigQuery SQL Converter

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

FromTo

Hourly Limit: 0/30

Source SQL

SELECT /*+ BROADCAST(d) */ f.*, d.region
FROM fact_sales f JOIN dim_store d USING (store_id);

Translated Result

Key Differences

•Databricks features commonly rewritten: DELTA table DDL, struct<> types.
•BigQuery equivalents: STRUCT / ARRAY literals, SAFE. prefix functions.
•Identifier quoting style differs — backticks → double quotes.
•Date/time function names and casting semantics vary between Databricks and BigQuery.