Skip to main content

Redshift Data Type Conversions

This section covers data type conversions between the Trifacta 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

In this section: