...
| Source Data Type | Supported |
| ||||
|---|---|---|---|---|---|---|
| string | Y | String | ||||
| bigint | Y | Integer | ||||
| double precision | Y | Decimal | ||||
| bool | Y | Boolean | ||||
| date | Y | DateTime | ||||
| timestamp | Y | DateTime |
...
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
If you are publishing to a pre-existing table, the following data type conversions apply:
- Columns:
D s item item 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 |
