Openflow connectors for SQL Server: Data mapping¶
Note
This connector is subject to the Snowflake Connector Terms.
This topic describes how SQL Server data types are mapped to Snowflake data types. The mapping is the same for the Openflow Connector for SQL Server and the Openflow Connector for SQL Server (CDC).
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.