Data Types
Current Data types conversion for Redshift in snowconvert.
This article is a work in progress.
It is being updated based on the progress made for Snowconvert Redshift.
Snowflake supports most basic SQL data types (with some restrictions) for use in columns, local variables, expressions, parameters, and any other appropriate/suitable locations.
For the data types defined by the ANSI standard check: ANSI Data Types.
Numeric Data Types
| Redshift | Snowflake | Notes |
|---|---|---|
INTEGER | INTEGER | |
BIGINT | BIGINT | |
DOUBLE PRECISION | DOUBLE PRECISION | |
FLOAT | FLOAT | |
FLOAT4 | FLOAT4 | |
FLOAT8 | FLOAT8 | |
INT | INT | |
INT2 | SMALLINT | |
INT4 | INTEGER | |
INT8 | INTEGER | |
NUMERIC | NUMERIC | |
DECIMAL | DECIMAL | |
REAL | REAL | |
SMALLINT | SMALLINT |
Character Types
| Redshift | Snowflake | Notes |
|---|---|---|
CHAR | CHAR | |
CHARACTER | CHARACTER | |
NCHAR | NCHAR | |
BPCHAR | VARCHAR | BPCHAR data type is not supported in Snowflake. VARCHAR is used instead. |
VARCHAR | VARCHAR | |
NVARCHAR | NVARCHAR | MSCEWI1073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW |
CHARACTER VARYING | CHARACTER VARYING | |
TEXT | TEXT |
Boolean Types
| Redshift | Snowflake | Notes |
|---|---|---|
BOOL | BOOL | This is a flawed migration that will generate an error in Snowflake. Pending review. |
BOOLEAN | BOOLEAN |
Binary Data Types
| Redshift | Snowflake | Notes |
|---|---|---|
VARBYTE | TBD | Unsupported on Snowconvert |
VARBINARY | VARBINARY | |
BINARY | BINARY | |
VARYING | TBD | Unsupported on Snowconvert |
Date & Time Data Types
| Redshift | Snowflake | Notes |
|---|---|---|
DATE | DATE | |
TIME | TIME | |
TIMETZ | TIME | Time zone not supported for time data type |
TIMESTAMP | TIMESTAMP | |
TIMESTAMPTZ | TIMESTAMPTZ | |
TIMESTAMP WITH TIME ZONE | TIME | Time zone not supported for time data type |
TIMESTAMP WITHOUT TIME ZONE | TIME | Not applicable in snowflake. |
Other data types
| Redshift | Snowflake | Notes |
|---|---|---|
GEOMETRY | TBD | MSCEWI1073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW |
GEOGRAPHY | TBD | MSCEWI1073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW |
HLLSKETCH | TBD | Unsupported on Snowconvert |
SUPER | SUPER | This is a flawed migration that will generate an error in Snowflake. Pending review. |
Related EWIs
MSC-PG0002: Bpchar converted to varchar
MSCEWI1073: Pending functional equivalence review
Last updated