| 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 | | | | |
