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

1. MSC-PG0002: Bpchar converted to varchar

2. MSCEWI1073: Pending functional equivalence review