Mass Ingestion
- Mass Ingestion
- 所有产品
MySQLソースデータ型
| Snowflakeターゲットデータ型
|
---|---|
bigint
| number(19)
|
bigint unsigned
| number(20)
|
binary( size ), 1 <= size <= 255
| binary( size ), 1 <= size <= 255
|
bit( precision ), 1 <= p <= 64
| binary( size ), 1 <= size <= 8
|
blob
| binary(65535)
|
char( size ), 1 <= size <= 255
| varchar( size ), 4 <= size <= 1020
|
date
| date
|
datetime
| timestamp_ntz(0)
|
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
| number(p,s), 1 <= p <= 38, 0 <= s <= 29
|
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29
| char( size ), 40 <= size <= 67
|
double
| float
|
float
| float
|
geomcollection
| binary
|
geometry
| binary
|
geometrycollection
| binary
|
int
| number(10)
|
int unsigned
| number(10)
|
linestring
| binary
|
longblob
| binary
|
longtext
| varchar
|
mediumblob
| binary
|
mediumint
| number(7)
|
mediumint unsigned
| number(8)
|
mediumtext
| varchar
|
multilinestring
| binary
|
multipoint
| binary
|
multipolygon
| binary
|
numeric(10,0)
| integer
|
point
| binary
|
polygon
| binary
|
smallint
| number(5)
|
smallint unsigned
| number(5)
|
text
| varchar(87380)
|
time( precision ), 0 <= p <= 6
| varchar( size ), 10 <= size <= 17
|
timestamp( precision ), 0 <= p <= 6
| timestamp_ntz( precision ), 0 <= p <= 6
|
tinyblob
| binary(255)
|
tinyint
| number(3)
|
tinyint unsigned
| number(3)
|
tinytext
| varchar(340)
|
varbinary( size ), 1 <= size <= 65535
| binary( size ), 1 <= size <= 65535
|
varchar( size ), 1 <= size <= 21844
| varchar( size ), 4 <= size <= 87376
|
year
| number(4)
|