Skip to main content

Teradata Data Type Conversions

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

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.

In this section: