28 Jan 21 ·  Cpaul in Guides ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

Teradata Datatype to BigQuery Datatype Equivalents

Here are the Teradata datatypes and its Big Query equivalents

TeradataBigQuery
INTEGERINT64
SMALLINTINT64
BYTEINTINT64
BIGINTINT64
DECIMALNUMERIC

You cannot specify Scale and precision. BigQuery automatically detects and assigns it. NUMERIC can have up to 9 digits after the dot
FLOATFLOAT64
NUMERICNUMERIC
NUMBERNUMERIC
REALFLOAT64
CHAR / CHARACTERSTRING
VARCHARSTRING
CLOBSTRING
JSONSTRING
BLOBBYTES
BYTEBYTES
VARBYTEBYTES
DATEDATE
TIMETIME
TIME WITH TIME ZONETIME (Only UTC Supported)
TIMESTAMPTIMESTAMP
TIMESTAMP WITH TIME ZONE
TIMESTAMP
ARRAYARRAY
MULT DIMENSIONAL ARRAYARRAY (Use ARRAY OF STRUCTS)
INTERVAL HOURINT64
INTERVAL MINUTEINT64
INTERVAL SECONDINT64
INTERVAL DAY / INTERVAL MONTH / INTERVAL YEARINT64
PERIOD(DATE)Not Supported (Split it into two DATE columns)
PERIOD(TIMESTAMP), PERIOD(TIME), PERIOD(TIME WITH TIME ZONE)Not Supported (eg. Split into two TIMESTAMP Columns)
UDTSTRING
XMLSTRING
TD_ANYTYPESTRING

The Roboquery Query Converter automatically converts the datatypes - Its fast and free. Try it now!