|
Oracle Source Datatype |
Snowflake Target Datatype |
|---|---|
|
BLOB |
Binary(8388608) |
|
CHAR |
Varchar(1) |
|
CHAR VARYING(p) |
Varchar(p) |
|
CHAR(p) |
Varchar(p) |
|
CLOB |
Varchar(16777216) |
|
DATE |
Date |
|
DECIMAL |
Number(38,0) |
|
DECIMAL(p,s) |
Number(p,s) |
|
DOUBLE PRECISION |
Float |
|
FLOAT |
Float |
|
FLOAT(p) |
Float |
|
INTEGER |
Number(38,0) |
|
LONG |
Binary(8388608) |
|
NCHAR |
Varchar(1) |
|
NCHAR VARYING(p) |
Varchar(p) |
|
NCHAR(p) |
Varchar(p) |
|
NCLOB |
Varchar(16777216) |
|
NUMBER |
Number(38,0) |
|
NUMBER(p) |
Number(p,0) |
|
NUMERIC |
Number(38,0) |
|
NUMERIC(p,s) |
Number(p,s) |
|
NVARCHAR2 |
Varchar(1) |
|
NVARCHAR2(p) |
Varchar(p) |
|
RAW(p) |
Binary(p) |
|
REAL |
Float |
|
SMALLINT |
Number(38,0) |
|
TIMESTAMP |
TimeStamp_ntz(9) |
|
TIMESTAMP(3) |
TimeStamp_ntz(9) |
|
VARCHAR(p) |
Varchar(p) |
|
VARCHAR2(p) |
Varchar(p) |
|
XMLTYPE |
Varchar(16777216) |
The following table shows the Oracle 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.
|
Oracle Source Datatype |
Snowflake Target Varchar |
|---|---|
|
Date |
Varchar |
|
Decimal |
Varchar |
|
Double |
Varchar |
|
Float |
Varchar |
|
Integer |
Varchar |
|
Number |
Varchar |
|
Numeric |
Varchar |
|
Real |
Varchar |
|
Smallint |
Varchar |
|
Timestamp |
Varchar |