Database Ingestion and Replication

Back Next

Teradata Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for

configurations with a Teradata source and a Microsoft Azure Synapse Analytics target:

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)