Page tree


Contents:

   

Contents:


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

NOTE: The Trifacta® 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 TypeSupported

Trifacta data type

stringYString
bigintYInteger
double precisionYDecimal
boolYBoolean
dateYDateTime
timestampYDateTime

Write/Publish

Create new table

NOTE: By default, the maximum length of values published to VARCHAR columns is 256 characters.

Trifacta Data Type

Redshift Data TypeNotes
Stringvarchar
Integerbigint
Decimaldouble precision
Boolbool
Datetimetimestamp

When you publish results from a job through the Export Results window to Redshift, all Datetime column values are written as String type.

Objectvarchar
Arrayvarchar

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


StringIntegerDatetimeBoolFloatMapArray
TEXTYYYYYYY
VARCHARYYYYYYY
NVARCHARYYYYYYY
BPCHARYYYYYYY
NCHAR






CHAR






CHARACTER VARYINGYYYYYYY
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



This page has no comments.