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`