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 |