Mass Ingestion
- Mass Ingestion
- 所有产品
Teradataソースデータ型
| Snowflakeターゲットデータ型
|
---|---|
array
| binary
|
bigint
| integer
|
blob
| binary
|
byte( precision ), 1 <= p <= 64000
| binary( size ), 1 <= size <= 64000
|
byteint
| integer
|
char( size ), 1 <= size <= 64000
| varchar( size ), 4 <= size <= 256000
|
clob
| varchar
|
date
| date
|
decimal( precision ), 1 <= p <= 38
| integer
|
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
| number(p,s), 1 <= p <= 38, 1 <= s <= 37
|
float
| float
|
integer
| integer
|
interval day( precision ) to hour, 1 <= p <= 4
| varchar( size ), 5 <= size <= 8
|
interval day( precision ) to minute, 1 <= p <= 4
| varchar( size ), 8 <= size <= 11
|
interval day( precision ) to second (s), 1 <= p <= 4, 0 <= s <= 6
| varchar( size ), 12 <= size <= 21
|
interval day( precision ), 1 <= p <= 4
| varchar( size ), 2 <= size <= 5
|
interval hour( precision ) to minute, 1 <= p <= 4
| varchar( size ), 5 <= size <= 8
|
interval hour( precision ) to second (s), 1 <= p <= 4, 0 <= s <= 6
| varchar( size ), 9 <= size <= 18
|
interval hour( precision ), 1 <= p <= 4
| varchar( size ), 2 <= size <= 5
|
interval minute( precision ) to second (s), 1 <= p <= 4, 0 <= s <= 6
| varchar( size ), 9 <= size <= 18
|
interval minute( precision ), 1 <= p <= 4
| varchar( size ), 2 <= size <= 5
|
interval month( precision ), 1 <= p <= 4
| varchar( size ), 2 <= size <= 5
|
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6
| varchar( size ), 3 <= size <= 12
|
interval year( precision ) to month, 1 <= p <= 4
| varchar( size ), 5 <= size <= 8
|
interval year( precision ), 1 <= p <= 4
| varchar( size ), 2 <= size <= 5
|
json
| varchar
|
mbr
| binary(256)
|
number(*,s), 0 <= s <= 37
| char(255)
|
number( precision ), 1 <= p <= 36
| integer
|
number(p,s), 1 <= p <= 38, 1 <= s <= 37
| number(p,s), 1 <= p <= 38, 1 <= s <= 37
|
numeric( precision ), 1 <= p <= 36
| integer
|
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37
| number(p,s), 1 <= p <= 38, 1 <= s <= 37
|
period(date)
| varchar(28)
|
period(time( precision ) with time zone), 0 <= p <= 6
| varchar( size ), 36 <= size <= 50
|
period(time( precision ) ), 0 <= p <= 6
| varchar( size ), 24 <= size <= 38
|
period(timestamp( precision ) with time zone), 0 <= p <= 6
| varchar( size ), 58 <= size <= 72
|
period(timestamp( precision ) ), 0 <= p <= 6
| varchar( size ), 46 <= size <= 60
|
smallint
| integer
|
time( precision ) with time zone, 0 <= p <= 6
| timestamp_tz( precision ), 0 <= p <= 6
|
time( precision ), 0 <= p <= 6
| time( precision ), 0 <= p <= 6
|
timestamp( precision ) with time zone, 0 <= p <= 6
| timestamp_tz( precision ), 0 <= p <= 6
|
timestamp( precision ), 0 <= p <= 6
| timestamp_ntz( precision ), 0 <= p <= 6
|
varbyte( precision ), 1 <= p <= 64000
| binary( size ), 1 <= size <= 64000
|
varchar( size ), 1 <= size <= 64000
| varchar( size ), 4 <= size <= 256000
|
varray
| binary
|
xml
| varchar
|