NOTE: The Alteryx® data types 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 | Alteryx data type |
|---|---|---|
| string | Y | String |
| bigint | Y | Integer |
| double precision | Y | Decimal |
| bool | Y | Boolean |
| date | Y | DateTime |
| timestamp | Y | DateTime |
Export
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.
Alteryx Data Type | Redshift Data Type | Notes |
|---|---|---|
| String | varchar | |
| Integer | bigint | |
| Decimal | double precision | |
| Bool | bool | |
| Datetime | varchar | |
| Object | varchar | |
| Array | varchar |
NOTE: Object and Array types are written in the supported format, if escaped commas and backslashes are unescaped in your recipe.
This page has no comments.