Skip to main content

SQL Translator

Overview​

Datafold's SQL Translator allows users to easily convert SQL code between different dialects. It addresses one of the most time-consuming aspects of database migration by simplifying the process of converting SQL and ensuring it runs correctly.

How to use​

To get started, click on SQL Translator in the main menu. From there, select the source and target dialects, and paste or write your SQL code.

Supported dialects​

  • BigQuery
  • ClickHouse
  • Databricks
  • Apache Doris
  • Apache Drill
  • DuckDB
  • Apache Hive
  • MySQL
  • Oracle
  • PostgreSQL
  • Presto
  • Redshift
  • Snowflake
  • Apache Spark/Spark2
  • SQLite
  • StarRocks
  • Tableau
  • Teradata
  • Trino
  • T-SQL/MS SQL Server

Translation errors​

Translation can encounter errors in both parsing the original statement block and later in target query generation. While parsing errors prevent the entire statement block from being translated, any queries causing generation errors are omitted from the output and displayed below with the error messages.