...
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. |
| 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 |
| Info |
|---|
NOTE: Object and Array types are written in the supported format, if escaped commas and backslashes are unescaped in your recipe. |
...
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 |
