Oracle to Google BigQuery mapping

AutoSync maps Oracle object types to the following Google BigQuery column types:

Oracle object type Google BigQuery column type
char STRING
varchar2 STRING
nchar STRING
nvarchar2 STRING
number NUMERIC
number (without scale and precision) FLOAT64
float FLOAT64
binary_float FLOAT64
binary_double FLOAT64
long STRING
long raw BYTES
raw BYTES
date DATE
timestamp TIMESTAMP
timestamp with time zone TIMESTAMP
timestamp with local time zone TIMESTAMP
interval year to month STRING
interval day to second STRING
blob BYTES
clob STRING
nclob STRING
bfile BYTES
rowid STRING
urowid STRING
anydata STRING
xmltype STRING