Openflow Connector for SQL Server: Data mapping¶
Note
This connector is subject to the Snowflake Connector Terms.
This topic describes how the SQL Server data types are mapped to Snowflake data types.
SQL Server to Snowflake data type mapping¶
The following table shows how SQL Server data types are mapped to Snowflake data types when replicating data.
| SQL Server type | Snowflake type | Notes |
|---|---|---|
| TINYINT | INT | |
| SMALLINT | INT | |
| INT | INT | |
| BIGINT | INT | |
| DECIMAL | NUMBER | If precision exceeds Snowflake limitations (precision > 38), the value is stored as TEXT. |
| NUMERIC | NUMBER | If precision exceeds Snowflake limitations (precision > 38), the value is stored as TEXT. |
| SMALLMONEY | NUMBER | |
| MONEY | NUMBER | |
| REAL | FLOAT | |
| FLOAT | FLOAT | |
| BIT | BOOLEAN | |
| CHAR | TEXT | |
| VARCHAR | TEXT | |
| NCHAR | TEXT | |
| NVARCHAR | TEXT | |
| TEXT | TEXT | |
| NTEXT | TEXT | |
| DATE | DATE | |
| TIME | TIME | |
| SMALLDATETIME | TIMESTAMP_NTZ | |
| DATETIME | TIMESTAMP_NTZ | |
| DATETIME2 | TIMESTAMP_NTZ | |
| DATETIMEOFFSET | TIMESTAMP_TZ | |
| BINARY | BINARY | |
| VARBINARY | BINARY | |
| IMAGE | BINARY | Supported up to the maximum entry size in Snowflake (16 MB). |
| JSON | VARIANT | Supported up to the maximum entry size in Snowflake (16 MB). |
| VECTOR | VARIANT | |
| XML | TEXT | |
| UNIQUEIDENTIFIER | TEXT | |
| ROWVERSION / TIMESTAMP | TEXT | |
| SQL_VARIANT | TEXT | |
| GEOGRAPHY | TEXT | Values of this type are inserted as NULL. |
| GEOMETRY | TEXT | Values of this type are inserted as NULL. |
Note
Any SQL Server data types not listed in this table are mapped to TEXT by default.