Redshift Data Type Conversions

Contents:

Expand all Collapse all

Contents:

This section covers data type conversions between the Designer Cloud® application and Redshift.

NOTE: The Alteryx® data types listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

Access/Read

Source Data Type	Supported	Alteryx data type
string	Y	String
bigint	Y	Integer
double precision	Y	Decimal
bool	Y	Boolean
date	Y	DateTime
timestamp	Y	DateTime

Write/Publish

Create new table

Alteryx Data Type	Redshift Data Type	Notes
String	varchar
Integer	bigint
Decimal	double precision
Bool	bool
Datetime	timestamp	When you publish results from a job through the Export Results window to Redshift, all Datetime column values are written as String type.
Object	varchar
Array	varchar

NOTE: Object and Array types are written in the supported format, if escaped commas and backslashes are unescaped in your recipe.

Append to existing table

If you are publishing to a pre-existing table, the following data type conversions apply:

Columns: Alteryx data types
Rows: Target table data types

In any table cell, a Y indicates that the append operation for that data type mapping is supported.

	String	Integer	Datetime	Bool	Float	Map	Array
TEXT	Y	Y	Y	Y	Y	Y	Y
VARCHAR	Y	Y	Y	Y	Y	Y	Y
NVARCHAR	Y	Y	Y	Y	Y	Y	Y
BPCHAR	Y	Y	Y	Y	Y	Y	Y
NCHAR
CHAR
CHARACTER VARYING	Y	Y	Y	Y	Y	Y	Y
SMALLINT
INT2
INTEGER
INT
INT4
BIGINT		Y
INT8		Y
DECIMAL		Y			Y
NUMERIC		Y			Y
DOUBLE_PRECISION		Y			Y
FLOAT		Y			Y
FLOAT4
FLOAT8					Y
REAL
BOOL				Y
BOOLEAN				Y
TIMESTAMP			Y
TIMESTAMPTZ			Y

See Also for Redshift Data Type Conversions:

Page:

Enable Access to S3 and AWS Resources
Page:

Amazon Redshift Connections
Page:

Snowflake Connections
Page:

Redshift Table Settings
Page:

Connection Types

Send Feedback

Page tree

Redshift Data Type Conversions

Access/Read

Write/Publish

Create new table

Append to existing table