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 |
|---|---|---|
| BYTE[(n)] | N | |
| VARBYTE[(n)] | N | |
| BYTEINT | Y | Integer |
| SMALLINT | Y | Integer |
| BIGINT | Y | Integer |
| INTEGER | Y | Integer |
| DECIMAL [(n[,m])] | Y | Decimal |
| NUMERIC [(n[,m])] | Y | Decimal |
| REAL | Y | Decimal |
| DOUBLE PRECISION | Y | Decimal |
| FLOAT | Y | Decimal |
| NUMBER(n[,m]) | Y | Decimal |
| NUMBER[(*[,m])] | Y | Decimal |
| DATE | Y | String |
| Time(0) | Y | Datetime |
| Time(0) WITH TIME ZONE | Y | Datetime |
| TIME (n) | Y | String |
| TIME (n) WITH TIME ZONE | Y | String |
| TIMESTAMP (0) | Y | String |
| Timestamp(0) WITH TIME ZONE | Y | Datetime |
| TIMESTAMP (n) | Y | Datetime |
| TIMESTAMP (n) WITH TIME ZONE | Y | String |
| INTERVAL DAY [(n)] | Y | String |
| INTERVAL DAY [(n)] TO HOUR | Y | String |
| INTERVAL DAY [(n)] TO MINUTE | Y | String |
| INTERVAL DAY [(n)] TO SECOND | Y | String |
| INTERVAL HOUR [(n)] | Y | String |
| INTERVAL HOUR [(n)] TO MINUTE | Y | String |
| INTERVAL HOUR [(n)] TO SECOND | Y | String |
| INTERVAL MINUTE [(n)] | Y | String |
| INTERVAL MINUTE [(n)] TO SECOND [(m)] | Y | String |
| INTERVAL MONTH | Y | String |
| INTERVAL SECOND [(n,[m])] | Y | String |
| INTERVAL YEAR [(n)] | Y | String |
| INTERVAL YEAR [(n)] TO MONTH | Y | String |
| CHAR[(n)] | Y | String |
| CHARACTER(n) CHARACTER SET GRAPHIC | N | |
| VARCHAR(n) | Y | String |
| CHAR VARYING(n) | Y | String |
| LONG VARCHAR | Y | String |
| LONG VARGRAPHIC | N | |
| VARGRAPHIC | N | |
| PERIOD(DATE) | N | |
| PERIOD(TIME (0)) | N | |
| PERIOD(TIME (0)) WITH TIME ZONE | N | |
| PERIOD(TIME (n)) | N | |
| PERIOD(TIME (n)) WITH TIME ZONE | N | |
| PERIOD(TIMESTAMP(0)) | N | |
| PERIOD(TIMESTAMP(0)) WITH TIME ZONE | N | |
| PERIOD(TIMESTAMP(n)) | N | |
| PERIOD(TIMESTAMP(n)) WITH TIME ZONE | N | |
| BLOB | N | |
| CLOB | Y | String |
| XML | Y | String |
| ARRAY | Y | Array |
| VARARRAY | Y | Array |
| TD_ANYTYPE | N | |
| VARIANT_TYPE | N | |
| Distinct | N | |
| Structured | N | |
| ST_CircularString | N | |
| ST_CompoundCurve | N | |
| ST_Curve | N | |
| ST_CurvePolygon | N | |
| ST_GeomCollection | N | |
| ST_Geometry | N | |
| ST_LineString | N | |
| ST_MultiCurve | N | |
| ST_MultiLineString | N | |
| ST_MultiPoint | N | |
| ST_MultiPolygon | N | |
| ST_MultiSurface | N | |
| ST_Point | N | |
| ST_Polygon | N | |
| ST_Surface | N | |
| JSON | Y | String |
Write/Publish
Alteryx Data Type | Teradata Column Type | Notes |
|---|---|---|
| Bool | VARCHAR(256) | |
| Integer | INT | |
| INTEGER | ||
| SMALLINT | ||
| VARCHAR(256) | ||
| String | VARCHAR(256) | |
| Datetime | TIMESTAMP | |
| VARCHAR(256) | ||
| Timestamp | VARCHAR(256) | |
| Float | FLOAT | |
| DECIMAL | ||
| NUMERIC | ||
| VARCHAR(256) | ||
| Map | VARCHAR(256) | |
| Array | VARCHAR(256) |
NOTE: If you are appending to an existing table where a column's Alteryx data type is not mapped to the column data type in the target table, a validation error is thrown, as the Designer Cloud Powered by Trifacta platform writes unmapped types as String data type.
This page has no comments.