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 |