Translation Reference

This page shows how SnowConvert handles the transformation for the grammar part of the SQL ANSI standard. The ANSI SQL Standard specifies common grammar elements in the multiple SQL Dialects out there (Teradata, Oracle, SqlServer, DB2, PostgreSQL, and so on). It is important to notice the fact that a specific syntax being part of the ANSI SQL Standard, does not necessarily imply that is valid syntax for all SQL Dialects; the percentage of ANSI compliance per SQL dialect varies significantly

Because of this, the information provided on this page generally (but not always) applies to the following flavors of SnowConvert.

• SnowConvert for Google BigQuery

• SnowConvert for IBM DB2

• SnowConvert for Greenplum

• SnowConvert for PostgreSQL

• SnowConvert for Apache Hive

• SnowConvert for Amazon RedShift

• SnowConvert for Vertica

Navigate through the following pages to find out how SnowConvert handles the transformation of this common grammar.