Mass Ingestion
- Mass Ingestion
- 所有产品
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
|