Data Type Mapping for Migration from Teradata to DWS

**Table 1** Data type mapping for migration from Teradata to DWS
Teradata Data Type	DWS Data Type	Mapping Supported or Not
BIGINT	BIGINT	Yes
BYTEINT	SMALLINT	Yes
DECIMAL [(n[,m])]	DECIMAL [(n[,m])]	Yes
DOUBLE PRECISION	DOUBLE PRECISION	Yes
FLOAT	DOUBLE PRECISION	Yes
INT / INTEGER	INTEGER	Yes
NUMBER / NUMERIC	NUMERIC	Yes
NUMBER(n[,m])	NUMERIC (n[,m])	Yes
REAL	REAL	Yes
SMALLINT	SMALLINT	Yes
CHAR[(n)] / CHARACTER [(n)]	CHAR(n)	Yes
CLOB	CLOB	Yes
LONG VARCHAR	TEXT	Yes
VARCHAR(n) / CHAR VARYING(n) / CHARACTER VARYING(n)	VARCHAR(n)	Yes
DATE	DATE	Yes
TIME [(n)]	TIME [(n)]	Yes
TIME [(n)] WITH TIME ZONE	TIME [(n)] WITH TIME ZONE	Yes
TIMESTAMP [(n)]	TIMESTAMP [(n)]	Yes
TIMESTAMP [(n)] WITH TIME ZONE	TIMESTAMP [(n)] WITH TIME ZONE	Yes
PERIOD(DATE)	daterange	Yes
PERIOD(TIME [(n)])	tsrange [(n)]	Yes
PERIOD(TIME WITH TIME ZONE)	tstzrange	Yes
PERIOD(TIMESTAMP [(n)])	tsrange [(n)]	Yes
PERIOD(TIMESTAMP WITH TIME ZONE)	tstzrange	Yes
BLOB[(n)]	blob	Yes
BYTE[(n)]	bytea	Yes
VARBYTE[(n)]	bytea	Yes