This page explains how data types are mapped from a source SQL Server database to the target databases. Please visit the SQL Server Data Types Documentation to get a primer on the various SQL Server datatypes.
SQL Server Datatype | Firebolt Datatype | Snowflake Datatype |
---|---|---|
Numbers | ||
TINYINT | INTEGER | TINYINT |
SMALLINT | INTEGER | SMALLINT |
INT | INTEGER | INT |
BIGINT | BIGINT | BIGINT |
NUMERIC | NUMERIC | NUMBER |
DECIMAL | NUMERIC | NUMBER |
SMALLMONEY | NUMERIC | NUMBER |
MONEY | NUMERIC | NUMBER |
FLOAT | DOUBLE | FLOAT |
REAL | REAL | FLOAT |
BIT | BOOLEAN | BOOLEAN |
Times | ||
DATE | DATE | DATE |
TIME | TEXT | TIME |
DATETIME | TIMESTAMP | TIMESTAMP_NTZ |
DATETIME2 | TIMESTAMP | TIMESTAMP_NTZ |
DATETIMEOFFSET | TIMESTAMPTZ | TIMESTAMP_TZ |
Strings | ||
CHAR | TEXT | VARCHAR |
VARCHAR | TEXT | VARCHAR |
TEXT | TEXT | VARCHAR |
NCHAR | TEXT | VARCHAR |
NVARCHAR | TEXT | VARCHAR |
NTEXT | TEXT | VARCHAR |
Blobs | ||
BINARY | BYTEA | BINARY |
VARBINARY | BYTEA | BINARY |
IMAGE | BYTEA | BINARY |