SnowflakeDocumentation Home

Redshift

Welcome to Snowflake SnowConvert for Redshift. Let us be your guide on the road to a successful migration.

What is SnowConvert for Redshift?

SnowConvert is a software that understands SQL Redshift scripts and converts this source code into functionally equivalent Snowflake code.

Preview Feature - Open

SnowConvert for Redshift is available as a preview. Assessment and translation are available for TABLES and VIEWS, and although SnowConvert can recognize other types of statements, they are not fully supported yet.

Conversion Types

Specifically, SnowConvert for Redshift performs the following conversions:

Redshift to Snowflake SQL

SnowConvert recognizes the Redshift source code and converts the different statements into the appropriate SQL for the Snowflake target.

Sample code

Input Code:

IN -> Redshift_01.sql
CREATE TABLE table1 (
    col1 INTEGER GENERATED BY DEFAULT AS IDENTITY(1,1)
);

Output Code:

OUT -> Redshift_01.sql
CREATE TABLE table1 (
    col1 INTEGER IDENTITY(1,1) ORDER
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "09/17/2024" }}'
;

As you can see, most of the structure remains the same, but some column properties have to be transformed to Snowflake equivalents. For more information please refer to Redshift Translation References documentation.

SnowConvert Terminology

Before we get lost in the magic of these code conversions, here are a few terms/definitions so you know what we mean when we start dropping them all over the documentation:

  • SQL (Structured Query Language): the standard language for storing, manipulating, and retrieving data in most modern database architectures.

  • SnowConvert: the software that converts securely and automatically your Redshift files to the Snowflake cloud data platform.

  • Conversion rule or transformation rule: rules that allow SnowConvert to convert from a portion of source code to the expected target code.

  • Parse: parse or parsing is an initial process done by SnowConvert to understand the source code and build up an internal data structure required for executing the conversion rules.

In the next few pages, you'll learn more about the kind of conversions that SnowConvert for Redshift is capable of. If you're ready to get started, visit the Getting Started page in this documentation.

PreviousSQL ServerNextValidation

Last updated