Mass Ingestion
- Mass Ingestion
- 所有产品
DB2 for LUWソースデータ型
| Snowflakeターゲットデータ型
|
---|---|
bigint
| integer
|
binary( size ), 1 <= size <= 255
| binary( size ), 1 <= size <= 255
|
boolean
| boolean
|
char for bit data
| binary(1)
|
char( size ) for bit data, 2 <= size <= 255
| binary( size ), 2 <= size <= 255
|
character( size ), 1 <= size <= 255
| char( size ), 4 <= size <= 1020
|
date
| date
|
decfloat( precision ), 16 <= p <= 34
| char(255)
|
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
| number(p,s), 1 <= p <= 31, 0 <= s <= 31
|
double
| float
|
integer
| integer
|
long varchar
| varchar(130816)
|
long varchar for bit data
| binary(32700)
|
real
| float
|
smallint
| integer
|
time
| time(0)
|
timestamp( precision ), 0 <= p <= 9
| timestamp_ntz( precision ), 0 <= p <= 9
|
timestamp( precision ), 10 <= p <= 12
| char( size ), 30 <= size <= 32
|
varbinary( size ), 1 <= size <= 32672
| binary( size ), 1 <= size <= 32672
|
varchar( size ) for bit data, 1 <= size <= 32672
| binary( size ), 1 <= size <= 32672
|
varchar( size ), 1 <= size <= 32672
| varchar( size ), 4 <= size <= 130688
|