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

Write/Publish

Create new table

NOTE: By default, the maximum length of values published to VARCHAR columns is 256 characters. As needed, this limit can be changed for multiple publication targets. For more information, see Configure Application Limits.

	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