Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0681

D toc

Info

NOTE: The

D s item
itemdata types
rtrue
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

D s item
itemdata type

stringYString
bigintYInteger
double precisionYDecimal
boolYBoolean
dateYDateTime
timestampYDateTime

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

Info

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.

D s item
itemData 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 
Info

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: 
    D s item
    itemdata 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