XSD Datatype Mapping

Snowflake supports many alias and synonyms for datatypes. The following table shows how those datatypes are mapped to XSD data types in the plug-in.

Snowflake Column Definition	XSD Type
Number(N,10)	integer
Number(N,2)	decimal
Decimal(N,2)	decimal
Numeric(N,2)	decimal
Int	integer
Integer	integer
Bigint	integer
Smallint	integer
Double	double
Float	double
Double Precision	double
Real	double
Varchar	string
Varchar(N)	string
Char	string
Char(N)	string
Character	string
Character(N)	string
String	string
String(N)	string
Text	string
Text(N)	string
Binary	base64Binary
Binary(N)	base64Binary
varbinary	base64Binary
Boolean	boolean
Date	date
Time	time
Timestamp	dateTime
Timestamp_LTZ	dateTime
Timestamp_NTZ	dateTime
Timestamp_TZ	dateTime
Variant	anyType
Object	anyType
ARRAY	anyType