Mass Ingestion

Back Next

PostgreSQL Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for Mass Ingestion Databases configurations with a PostgreSQL source and a Microsoft Azure Synapse Analytics target:

PostgreSQL Source Data Type	Synapse Analytics Target Data Type
bigint	bigint
bit varying(1)	bit
bit varying(`precision`), 2 <= p <= 83700001	varbinary(`size`), 1 <= s <= max
bit(1)	bit
bit(`precision`), 2 <= p <= 63501	binary(`size`), 1 <= s <= 7938
bit(`precision`), 64001 <= p <= 83886080	varbinary(max)
boolean	bit
box	varbinary(115)
character varying(`size`), 1 <= s <= 10485760	varchar(`size`), 4 <= s <= max
character(`size`), 1 <= s <= 10485760	varchar(`size`), 4 <= s <= max
cidr	varchar(45)
circle	varbinary(87)
date	date
daterange	varchar(29)
double precision	float
inet	varchar(45)
int4range	varchar(25)
int8range	varchar(43)
integer	int
line	varbinary(85)
lseg	varbinary(117)
macaddr	varchar(17)
macaddr8	varchar(23)
money	decimal(19,2)
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38	decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
numeric(p,s), 39 <= p <= 999, 39 <= s <= 998	varchar(`size`), 42 <= s <= max
numrange	varchar(max)
path	varbinary(max)
point	varbinary(57)
polygon	varbinary(max)
real	real
smallint	smallint
time(`precision`) with time zone, 0 <= p <= 6	datetimeoffset(`precision`), 0 <= p <= 6
time(`precision`) without time zone, 0 <= p <= 6	time(`precision`), 0 <= p <= 6
timestamp(`precision`) with time zone, 0 <= p <= 6	datetimeoffset(`precision`), 0 <= p <= 6
timestamp(`precision`) without time zone, 0 <= p <= 6	datetime2(`precision`), 0 <= p <= 6
tsrange	varchar(63)
tstzrange	varchar(75)
uuid	uniqueidentifier