Netezza to BigQuery SQL translation reference

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

Introduction

Netezza data warehousing is designed to work with Netezza-specific SQL syntax. Netezza SQL is based on Postgres 7.2. SQL scripts written for Netezza can't be used in a BigQuery data warehouse without alterations because the SQL dialects vary.

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

  • Data types
  • SQL language elements
  • Query syntax
  • DML
  • DDL
  • Stored procedures
  • Functions

To read the full document, click the button:

Download the PDF