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.