Mass Ingestion
- Mass Ingestion
- 所有产品
Microsoft SQL ServerまたはAzure SQL Databaseソースデータ型
| Snowflakeターゲットデータ型
|
---|---|
bigint
| number(38,0)
|
binary( size ), 1 <= size <= 8000
| binary( size ), 1 <= size <= 8000
|
bit
| boolean
|
char( size ), 1 <= size <= 8000
| varchar( size ), 1 <= size <= 8000
|
date
| date
|
datetime
| timestamp_ntz(3)
|
datetime2( precision ), 0 <= p <= 7
| timestamp_ntz(7)
|
datetimeoffset( precision ), 0 <= p <= 7
| timestamp_tz( precision ), 0 <= p <= 7
|
decimal(38,38)
| char(41)
|
decimal(p,s), 1 <= p <= 38, 0 <= s <= 37
| number(p,s), 1 <= p <= 38, 0 <= s <= 37
|
float
| float
|
geography
| binary
|
geometry
| binary
|
hierarchyid
| binary(892)
|
image
| binary
|
int
| number(38,0)
|
money
| number(19,4)
|
nchar( size ), 1 <= size <= 4000
| varchar( size ), 4 <= size <= 16000
|
ntext
| varchar
|
numeric(38,38)
| char(41)
|
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
| number(p,s), 1 <= p <= 38, 0 <= s <= 37
|
nvarchar( size ), 1 <= size <= 4000
| varchar( size ), 4 <= size <= 16000
|
real
| float
|
smalldatetime
| timestamp_ntz(0)
|
smallint
| number(38,0)
|
smallmoney
| number(10,4)
|
sql_variant
| binary(8016)
|
text
| varchar
|
time( precision ), 0 <= p <= 7
| time( precision ), 0 <= p <= 7
|
timestamp(8)
| binary(8)
|
tinyint
| number(38,0)
|
uniqueidentifier
| char(36)
|
varbinary( size ), 1 <= size <= 8000
| binary( size ), 1 <= size <= 8000
|
varchar( size ), 1 <= size <= 8000
| varchar( size ), 1 <= size <= 8000
|
xml
| varchar
|