Amazon Redshift to BigQuery SQL translation reference

This document details the similarities and differences in SQL syntax between Redshift and BigQuery. The document can help accelerate the planning and execution of moving your enterprise data warehouse (EDW) to BigQuery. Redshift data warehousing is designed to work with Redshift-specific SQL syntax. Scripts written for Redshift might need to be altered before you can use them in BigQuery because the SQL dialects vary between the services.

This document is part of a series that discusses migrating data from Redshift to BigQuery. It is a companion to the Amazon Redshift to BigQuery migration guide.

Highlights
Purpose To detail common similarities and differences in SQL syntax between Redshift and BigQuery and help accelerate the planning and execution of moving your EDW to BigQuery.
Intended audience Enterprise architects, DBAs, application developers, and IT security.
Key assumptions That the audience is familiar with Redshift and is looking for guidance on transitioning to BigQuery.

To read the full document, click the button:

Download the PDF