Skip to main content

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