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