Microsoft SQL Server or Azure SQL Database Source Data Type | Snowflake Target Data Type |
|---|---|
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 |
varbinary(max) | binary |
varchar(size), 1 <= size <= 8000 | varchar(size), 1 <= size <= 8000 |
varchar(max) | varchar |
xml | varchar |