Mass Ingestion

Back Next

PostgreSQL Source and Snowflake Target

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

PostgreSQL Source Data Type	Snowflake Target Data Type
bigint	integer
bit varying(`precision`), 1 <= p <= 83700001	binary(`size`), 1 <= s <= 8387501
bit(`precision`), 1 <= p <= 83886080	binary(`size`), 1 <= s <= 8388563
boolean	boolean
box	binary(115)
bytea	binary(8388608) for initial loads only
character varying(`size`), 1 <= s <= 10485760	varchar(`size`), 4 <= s <= 16776004
character(`size`), 1 <= s <= 10485760	char(`size`), 4 <= s <= 16777216
cidr	varchar(45)
circle	binary(87)
date	date
daterange	varchar(29)
double precision	float
inet	varchar(45)
int4range	varchar(25)
int8range	varchar(43)
integer	integer
line	binary(85)
lseg	binary(117)
macaddr	varchar(17)
macaddr8	varchar(23)
money	number(19,2)
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37	number(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 38 <= p <= 999, 38 <= s <= 998	varchar(`size`), 41 <= s <= 131074
numrange	varchar(294917)
path	binary
point	binary(57)
polygon	binary
real	float
smallint	integer
text	varchar(16777216) for initial loads only
time(`precision`) with time zone, 0 <= p <= 6	timestamp_tz(`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	timestamp_tz(`precision`), 0 <= p <= 6
timestamp(`precision`) without time zone, 0 <= p <= 6	timestamp_ntz(`precision`), 0 <= p <= 6
tsrange	varchar(63)
tstzrange	varchar(75)
uuid	char(36)
xml	varchar(16777216) for initial loads only