SQL Server to Snowflake mapping

AutoSync maps SQL Server data types to the following Snowflake column types:

SQL Server data type Snowflake column type
bit boolean
date date
datetime timestamp_ntz
datetime2 timestamp_ntz
datetimeoffset timestamp_tz
smalldatetime timestamp_ntz
time time
decimal number
numeric number
float float
real float
int number
integer number
bigint number
smallint number
tinyint number
money number
smallmoney number
char varchar
hierarchyid varchar
nchar varchar
ntext varchar
nvarchar varchar
text varchar
uniqueidentifier varchar
varchar varchar
binary binary
image binary
varbinary binary
sql_variant varchar
table varchar
xml varchar
geometry varchar
geography varchar