View Source

NOTE: The 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
string	Y	String
bigint	Y	Integer
double precision	Y	Decimal
bool	Y	Boolean
date	Y	DateTime
timestamp	Y	DateTime

Notes:

After a dataset has been imported using custom SQL from Redshift, disabling type inference may not revert to the source data types for some columns. The workaround is to create a new imported dataset using the same custom SQL with type inference disabled before import. After the dataset is created, use it as a replacement for the corrupted instances of the previous Redshift dataset.

Write/Publish

Create new table

	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:
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