Skip to main content| 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 |