SQL format models In Snowflake, SQL format models (i.e. literals containing format strings) are used to specify how numeric values are converted to text strings and vice versa. As such, they can be specified as
Common data types to use: NUMBER/INTEGER: For whole numbers DECIMAL/NUMERIC: For precise decimal numbers (especially money) VARCHAR: For text with a known maximum length TEXT: For unlimited length text TIMESTAMP_NTZ: For dates and times (no timezone) ...