SQL Server DatatypeFirebolt DatatypeSnowflake Datatype
Numbers
TINYINTINTEGERTINYINT
SMALLINTINTEGERSMALLINT
INTINTEGERINT
BIGINTBIGINTBIGINT
NUMERICNUMERICNUMBER
DECIMALNUMERICNUMBER
SMALLMONEYNUMERICNUMBER
MONEYNUMERICNUMBER
FLOATDOUBLEFLOAT
REALREALFLOAT
BITBOOLEANBOOLEAN
Times
DATEDATEDATE
TIMETEXTTIME
DATETIMETIMESTAMPTIMESTAMP_NTZ
DATETIME2TIMESTAMPTIMESTAMP_NTZ
DATETIMEOFFSETTIMESTAMPTZTIMESTAMP_TZ
Strings
CHARTEXTVARCHAR
VARCHARTEXTVARCHAR
TEXTTEXTVARCHAR
NCHARTEXTVARCHAR
NVARCHARTEXTVARCHAR
NTEXTTEXTVARCHAR
Blobs
BINARYBYTEABINARY
VARBINARYBYTEABINARY
IMAGEBYTEABINARY