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