PostgreSQLソースデータ型 | Snowflakeターゲットデータ型 |
|---|---|
bigint | number |
bit varying(precision), 1 <= p <= 83886080 | binary(size), 1 <= size <= 6291457 |
bit(precision), 1 <= p <= 83886080 | binary(size), 1 <= size <= 6291457 |
boolean | boolean |
box | binary(115) |
character varying(size), 1 <= size <= 10485760 | varchar(size), 4 <= size <= 16776004 |
character(size), 1 <= size <= 10485760 | varchar(size), 4 <= size <= 16776004 |
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 |
json | variant |
jsonb | variant |
line | binary(85) |
lseg | binary(117) |
macaddr | varchar(17) |
macaddr8 | varchar(23) |
money | number(19,2) |
numeric | varchar（131074） |
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37 | number(p,s), 1 <= p <= 38, 0 <= s <= 37 |
numeric(p,s), 38 <= p <= 1000, 38 <= s <= 1000 | varchar(size), 41 <= size <= 1003 |
numrange | varchar(294917) |
path | binary |
point | binary(57) |
polygon | binary |
real | float |
smallint | number |
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 | varchar |
xml | variant |