Teradata Source Data Type | Microsoft Azure Synapse Analytics Target Data Type |
|---|---|
array | varbinary(max) |
bigint | bigint |
blob | varbinary(max) |
byte(precision), 1 <= p <= 7501 | binary(size), 1 <= size <= 7501 |
byte(precision), 8001 <= p <= 64000 | varbinary(max) |
byteint | smallint |
char(size), 1 <= size <= 8000 | char(size), 1 <= size <= 8000 |
char(size), 8001 <= size <= 64000 | varchar(max) |
clob | varchar(max) |
date | date |
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37 | decimal(p,s), 1 <= p <= 38, 1 <= s <= 37 |
float | float |
integer | int |
interval day(precision) to hour, 1 <= p <= 4 | varchar(size), 5 <= size <= 8 |
interval day(precision) to minute, 1 <= p <= 4 | varchar(size), 8 <= size <= 11 |
interval day(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6 | varchar(size), 12 <= size <= 21 |
interval day(precision), 1 <= p <= 4 | varchar(size), 2 <= size <= 5 |
interval hour(precision) to minute, 1 <= p <= 4 | varchar(size), 5 <= size <= 8 |
interval hour(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6 | varchar(size), 9 <= size <= 18 |
interval hour(precision), 1 <= p <= 4 | varchar(size), 2 <= size <= 5 |
interval minute(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6 | varchar(size), 9 <= size <= 18 |
interval minute(precision), 1 <= p <= 4 | varchar(size), 2 <= size <= 5 |
interval month(precision), 1 <= p <= 4 | varchar(size), 2 <= size <= 5 |
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6 | varchar(size), 3 <= size <= 12 |
interval year(precision) to month, 1 <= p <= 4 | varchar(size), 5 <= size <= 8 |
interval year(precision), 1 <= p <= 4 | varchar(size), 2 <=size <= 5 |
json | varchar(max) |
mbr | varbinary(256) |
number(*,s), 0 <= s <= 37 | varchar(255) |
number(p,s), 1 <= p <= 38, 1 <= s <= 37 | decimal(p,s), 1 <= p <= 38, 1 <= s <= 37 |
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37 | decimal(p,s), 1 <= p <= 38, 1 <= s <= 37 |
period(date) | varchar(28) |
period(time(precision) with time zone), 0 <= p <= 6 | varchar(size), 36 <= size <= 50 |
period(time(precision) ), 0 <= p <= 6 | varchar(size), 24 <= size <= 38 |
period(timestamp(precision) with time zone), 0 <= p <= 6 | varchar(size), 58 <= size <= 72 |
period(timestamp(precision) ), 0 <= p <= 6 | varchar(size), 46 <= size <= 60 |
smallint | smallint |
time(precision) with time zone, 0 <= p <= 6 | datetimeoffset(precision), 0 <= p <= 6 |
time(precision), 0 <= p <= 6 | time(precision), 0 <= p <= 6 |
timestamp(precision) with time zone, 0 <= p <= 6 | datetimeoffset(precision), 0 <= p <= 6 |
timestamp(precision), 0 <= p <= 6 | datetime2(precision), 0 <= p <= 6 |
varbyte(precision), 1 <= p <= 64000 | varbinary(size), 1 <= size <= max |
varchar(size), 1 <= size <= 64000 | varchar(size), 1 <= size <= max |
varray | varbinary(max) |
xml | varchar(max) |