|
SQL Server Source Datatype |
Snowflake Target Datatype |
|---|---|
|
BIGINT |
Number(38,0) |
|
BINARY |
Binary(1) |
|
BINARY(p) |
Binary(p) |
|
BIT |
Number(38,0) |
|
CHAR |
Varchar(1) |
|
CHAR VARYING(p) |
Varchar(p) |
|
CHAR(p) |
Varchar(p) |
|
DATE |
Date |
|
DATETIME |
TimeStamp_ntz(9) |
|
DATETIME2 |
TimeStamp_ntz(9) |
|
DATETIME2(6) |
TimeStamp_ntz(9) |
|
DATETIMEOFFSET |
TimeStamp_ntz(9) |
|
DATETIMEOFFSET(6) |
TimeStamp_ntz(9) |
|
DECIMAL |
Number(18,0) |
|
DECIMAL(p,s) |
Number(p,s) |
|
DECIMAL(p) |
Number(p) |
|
DECIMAL(p,s) |
Number(p,s) |
|
DOUBLE PRECISION |
Float |
|
FLOAT |
Float |
|
FLOAT(10) |
Float |
|
IMAGE |
Binary(8388608) |
|
INTEGER |
Number(38,0) |
|
MONEY |
Number(19,4) |
|
NCHAR |
Varchar(1) |
|
NCHAR VARYING(p) |
Varchar(p) |
|
NCHAR(p) |
Varchar(p) |
|
NTEXT |
Varchar(16777216) |
|
NUMERIC |
Number(18,0) |
|
NUMERIC(p,s) |
Number(p,s) |
|
NVARCHAR |
Varchar(1) |
|
NVARCHAR(p) |
Varchar(p) |
|
NVARCHAR(MAX) |
Varchar(16777216) |
|
REAL |
Float |
|
SMALLDATETIME |
Timestamp_ntz(9) |
|
SMALLINT |
Number(38,0) |
|
SMALLMONEY |
Number(10,4) |
|
TEXT |
Varchar(16777216) |
|
TIME |
Time(9) |
|
TIME(p) |
Time(9) |
|
TINYINT |
Number(38,0) |
|
UNIQUEIDENTIFIER |
Varchar(36) |
|
VARBINARY |
Binary(8388608) |
|
VARBINARY(p) |
Binary(8388608) |
|
VARBINARY(MAX) |
Binary(8388608) |
|
VARCHAR |
Varchar(1) |
|
VARCHAR(p) |
Varchar(p) |
|
VARCHAR(MAX) |
Varchar(16777216) |
|
XML |
Varchar(16777216) |
The following table shows the SQL Server source datatypes that are available to map to a varchar target column in a table you create manually on the Snowflake target. If you create the varchar with no precision, by default the size will be 16777216. If you create a fixed-length varchar datatype, ensure this target definition is large enough to accommodate the data sent from the source column.
|
SQL Server Source Datatype |
Snowflake Target Varchar |
|---|---|
|
BIG INT |
Varchar |
|
BIT |
Varchar |
|
Date |
Varchar |
|
Datetime |
Varchar |
|
Datetime2 |
Varchar |
|
Datetimeoffset |
Varchar |
|
Decimal |
Varchar |
|
Double |
Varchar |
|
Float |
Varchar |
|
Integer |
Varchar |
|
Numeric |
Varchar |
|
Real |
Varchar |
|
Small Datetime |
Varchar |
|
Smallint |
Varchar |
|
Time |
Varchar |
|
Tinyint |
Varchar |