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 next

...

Source Data TypeSupported

D s item
itemdata type

stringYString
bigintYInteger
double precisionYDecimal
boolYBoolean
dateYDateTime
timestampYDateTime

...

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.

...

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

d-s-wip

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