Data Types
Snowflake supports most basic SQL data types (with some restrictions) for use in columns, local variables, expressions, parameters, and any other appropriate/suitable locations.
Exact and approximate numerics
NOTE:
For the conversion of integer data types (INT, SMALLINT, BIGINT, TINYINT), each is converted to the alias in Snowflake with the same name. Each of those aliases is actually converted to NUMBER(38,0), a data type that is considerably larger than the integer datatype. Below is a comparison of the range of values that can be present in each data type:
Snowflake NUMBER(38,0): -99999999999999999999999999999999999999 to +99999999999999999999999999999999999999
SQLServer TINYINT: 0 to 255
SQLServer INT: -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)
SQLServer BIGINT: -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)
SQLServer SMALLINT: -2^15 (-32,768) to 2^15-1 (32,767)
For Money and Smallmoney:
Currency or monetary data does not need to be enclosed in single quotation marks ( ' ). It is important to remember that while you can specify monetary values preceded by a currency symbol, SQL Server does not store any currency information associated with the symbol, it only stores the numeric value.
Please take care on the translations for the DMLs
Date and time
Character strings
Unicode character strings
Binary strings
Other data types
Last updated