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 | Supported by default up to 16 MB. |
| VARCHAR | TEXT | Supported by default up to 16 MB. |
| NCHAR | TEXT | Supported by default up to 16 MB. |
| NVARCHAR | TEXT | Supported by default up to 16 MB. |
| TEXT | TEXT | Supported by default up to 16 MB. |
| NTEXT | TEXT | Supported by default up to 16 MB. |
| DATE | DATE | |
| TIME | TIME | |
| SMALLDATETIME | TIMESTAMP_NTZ | |
| DATETIME | TIMESTAMP_NTZ | |
| DATETIME2 | TIMESTAMP_NTZ | |
| DATETIMEOFFSET | TIMESTAMP_TZ | |
| BINARY | BINARY | Supported by default up to 8 MB. |
| VARBINARY | BINARY | Supported by default up to 8 MB. |
| IMAGE | BINARY | Supported by default up to 8 MB. |
| JSON | VARIANT | Supported by default up to 16 MB. |
| VECTOR | VARIANT | Supported by default up to 16 MB. |
| XML | TEXT | Supported by default up to 16 MB. |
| UNIQUEIDENTIFIER | TEXT | Supported by default up to 16 MB. |
| ROWVERSION / TIMESTAMP | TEXT | Supported by default up to 16 MB. |
| SQL_VARIANT | TEXT | Supported by default up to 16 MB. |
| GEOGRAPHY | TEXT | Values of this type are inserted as NULL. |
| GEOMETRY | TEXT | Values of this type are inserted as NULL. |
Note
For types with default size limits (8 MB / 16 MB) in this table, it is possible to raise these limits. For details of the Openflow Connector for SQL Server (CDC), see Oversized values and for Openflow Connector for SQL Server, see Oversized values.
Note
Any SQL Server data types not listed in this table are mapped to TEXT by default.