Redshift Data Type Conversions
This section covers data type conversions between the Cloud Portal 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 |