Oracle to Snowflake mapping
AutoSync maps Oracle object types to the following Snowflake column types:
Oracle object type | Snowflake column type |
---|---|
char |
varchar |
varchar2 |
varchar |
nchar |
varchar |
nvarchar2 |
varchar |
number |
number |
number (without precision and scale) |
float |
float |
float |
binary_float |
float |
binary_double |
float |
long |
varchar |
long raw |
binary |
raw |
binary |
date |
date |
timestamp |
timestamp_ntz |
timestamp with time zone |
timestamp_tz |
timestamp with local time zone |
timestamp_ntz |
interval year to month |
varchar |
interval day to second |
varchar |
blob |
binary |
clob |
varchar |
nclob |
varchar |
bfile |
binary |
rowid |
varchar |
urowid |
varchar |
anydata |
varchar |
xmltype |
varchar |