Teradata Data Type Conversions
Note
This feature may not be available in all product editions. For more information on available features, see Compare Editions.
This section covers data type conversions between the Trifacta Application and Teradata databases.
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 |