|
Sybase Source Datatype |
Snowflake Target Datatype |
|---|---|
|
BINARY |
Binary(1) |
|
BINARY(p) |
Binary(p) |
|
BIT |
Number(38,0) |
|
CHAR(p) |
Varchar(p) |
|
CHARACTER |
Varchar(1) |
|
DATETIME |
Timestamp_ntz(9) |
|
DECIMAL |
Number(18,0) |
|
DECIMAL(p,s) |
Number(p,s) |
|
DOUBLE PRECISION |
Float |
|
FLOAT |
Float |
|
FLOAT(p) |
Float |
|
IMAGE |
Binary(8388608) |
|
INTEGER |
Number(38,0) |
|
MONEY |
Number(19,4) |
|
NUMERIC |
Number(18,0) |
|
NUMERIC(p,s) |
Number(p,s) |
|
REAL |
Float |
|
SMALLDATETIME |
Timestamp_ntz(9) |
|
SMALLINT |
Number(38,0) |
|
SMALLMONEY |
Number(10,4) |
|
TINYINT |
Number(38,0) |
|
VARBINARY |
Binary(8388608) |
|
VARBINARY(p) |
VARBINARY(p) |
|
VARBINARY(MAX) |
Binary(8388608) |
|
VARCHAR |
Varchar(1) |
|
VARCHAR(p) |
Varchar(p) |
The following table shows the Sybase 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.
|
Sybase Source Datatype |
Snowflake Target Varchar |
|---|---|
|
Bit |
Varchar |
|
Datetime |
Varchar |
|
Decimal |
Varchar |
|
double |
Varchar |
|
float |
Varchar |
|
Integer |
Varchar |
|
Numeric |
Varchar |
|
real |
Varchar |
|
Smalldatetime |
Varchar |
|
Smallint |
Varchar |
|
Tinyint |
Varchar |