Snowflake to BigQuery SQL translation reference

This document details similarities and differences in SQL syntax between Snowflake and BigQuery. The document is intended to help you accelerate the planning and execution of moving your enterprise data warehouse (EDW) to BigQuery.

Introduction

Snowflake data warehousing is designed to work with Snowflake-specific SQL syntax. You might need to alter scripts that are written for Snowflake before you can use them in BigQuery because the SQL dialects vary between the services.

This document details the similarities and differences in SQL syntax between Snowflake and BigQuery in the following areas:

  • Data types
  • Query syntax and query operators
  • DML syntax
  • DDL syntax
  • User-defined functions
  • Stored procedures
  • Metadata and transaction SQL statements
  • Consistency guarantees and transaction isolation
  • Database limits

To read the full document, click the button:

Download the PDF