Page tree

Release 8.2.2


Contents:

   

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 TypeSupported

Alteryx Data Type

BYTE[(n)]N 
VARBYTE[(n)]N 
BYTEINTY Integer
SMALLINTYInteger 
BIGINTYInteger 
INTEGERYInteger 
DECIMAL [(n[,m])]YDecimal 
NUMERIC [(n[,m])]YDecimal
REALYDecimal
DOUBLE PRECISIONYDecimal
FLOATYDecimal
NUMBER(n[,m])YDecimal 
NUMBER[(*[,m])]YDecimal
DATEYString 
Time(0)YDatetime 
Time(0) WITH TIME ZONEYDatetime 
TIME (n)YString
TIME (n) WITH TIME ZONEYString
TIMESTAMP (0)YString
Timestamp(0) WITH TIME ZONEYDatetime
TIMESTAMP (n)YDatetime
TIMESTAMP (n) WITH TIME ZONEYString
INTERVAL DAY [(n)]YString
INTERVAL DAY [(n)] TO HOURYString
INTERVAL DAY [(n)] TO MINUTEYString
INTERVAL DAY [(n)] TO SECONDYString
INTERVAL HOUR [(n)]YString
INTERVAL HOUR [(n)] TO MINUTEYString
INTERVAL HOUR [(n)] TO SECONDYString
INTERVAL MINUTE [(n)]YString
INTERVAL MINUTE [(n)] TO SECOND [(m)]YString
INTERVAL MONTHYString
INTERVAL SECOND [(n,[m])]YString
INTERVAL YEAR [(n)]YString
INTERVAL YEAR [(n)] TO MONTHYString
CHAR[(n)]YString
CHARACTER(n) CHARACTER SET GRAPHICN 
VARCHAR(n)YString
CHAR VARYING(n)YString
LONG VARCHARYString
LONG VARGRAPHICN 
VARGRAPHICN 
PERIOD(DATE)N 
PERIOD(TIME (0))N 
PERIOD(TIME (0)) WITH TIME ZONEN 
PERIOD(TIME (n))N 
PERIOD(TIME (n)) WITH TIME ZONEN 
PERIOD(TIMESTAMP(0))N 
PERIOD(TIMESTAMP(0)) WITH TIME ZONEN 
PERIOD(TIMESTAMP(n))N 
PERIOD(TIMESTAMP(n)) WITH TIME ZONEN 
BLOBN 
CLOBYString
XMLYString
ARRAYYArray
VARARRAYYArray
TD_ANYTYPEN 
VARIANT_TYPEN 
DistinctN 
StructuredN 
ST_CircularStringN 
ST_CompoundCurveN 
ST_CurveN 
ST_CurvePolygonN 
ST_GeomCollectionN 
ST_GeometryN 
ST_LineStringN 
ST_MultiCurveN 
ST_MultiLineStringN 
ST_MultiPointN 
ST_MultiPolygonN 
ST_MultiSurfaceN 
ST_PointN 
ST_PolygonN 
ST_SurfaceN 
JSONYString

Write/Publish

Alteryx Data Type

Teradata Column TypeNotes
BoolVARCHAR(256) 
IntegerINT 
 INTEGER 
 SMALLINT 
 VARCHAR(256) 
StringVARCHAR(256) 
DatetimeTIMESTAMP 
 VARCHAR(256) 
TimestampVARCHAR(256) 
FloatFLOAT 
 DECIMAL 
 NUMERIC 
 VARCHAR(256) 
MapVARCHAR(256) 
ArrayVARCHAR(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.