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`