Mass Ingestion

Back Next

Oracle Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Mass Ingestion Databases configurations with a Oracle source and a Google BigQuery target:

Oracle Source Data Type	Google BigQuery Target Data Type
binary_double	float64
binary_float	float64
char(s byte), 1 <= s <= 2000	string
char(s char), 1 <= s <= 2000	string
date	datetime
float(`precision`), 1 <= p <= 126	string
integer	string
long raw	bytes
long(2147483648 byte)	string
nchar(s char), 1 <= s <= 2000	string
number	string
number(*,s), -84 <= s <= 127	string
number(1,-38)	bignumeric
number(1,s), -37 <= s <= -29	bignumeric
number(1,s), -84 <= s <= -39	string
number(10,-29)	bignumeric
number(11,-28)	bignumeric
number(12,-27)	bignumeric
number(13,-26)	bignumeric
number(14,-25)	bignumeric
number(15,-24)	bignumeric
number(16,-23)	bignumeric
number(17,-22)	bignumeric
number(18,-21)	bignumeric
number(19,-20)	bignumeric
number(2,-37)	bignumeric
number(20,-19)	bignumeric
number(21,-18)	bignumeric
number(22,-17)	bignumeric
number(23,-16)	bignumeric
number(24,-15)	bignumeric
number(25,-14)	bignumeric
number(26,-13)	bignumeric
number(27,-12)	bignumeric
number(28,-11)	bignumeric
number(29,-10)	bignumeric
number(3,-36)	bignumeric
number(30,-9)	bignumeric
number(31,-8)	bignumeric
number(32,-7)	bignumeric
number(33,-6)	bignumeric
number(34,-5)	bignumeric
number(35,-4)	bignumeric
number(36,-3)	bignumeric
number(37,-2)	bignumeric
number(38,-1)	bignumeric
number(38,9)	numeric
number(38,s), 10 <= s <= 38	bignumeric
number(4,-35)	bignumeric
number(5,-34)	bignumeric
number(6,-33)	bignumeric
number(7,-32)	bignumeric
number(8,-31)	bignumeric
number(9,-30)	bignumeric
number(p,s), 1 <= p <= 38, -28 <= s <= 9	numeric
number(p,s), 1 <= p <= 38, -36 <= s <= 38	bignumeric
number(p,s), 1 <= p <= 38, -84 <= s <= 127	string
number(p,s), 10 <= p <= 38, -19 <= s <= 9	numeric
number(p,s), 10 <= p <= 38, -27 <= s <= 38	bignumeric
number(p,s), 10 <= p <= 38, -84 <= s <= 127	string
number(p,s), 11 <= p <= 38, -18 <= s <= 9	numeric
number(p,s), 11 <= p <= 38, -26 <= s <= 38	bignumeric
number(p,s), 11 <= p <= 38, -84 <= s <= 127	string
number(p,s), 12 <= p <= 38, -17 <= s <= 9	numeric
number(p,s), 12 <= p <= 38, -25 <= s <= 38	bignumeric
number(p,s), 12 <= p <= 38, -84 <= s <= 127	string
number(p,s), 13 <= p <= 38, -16 <= s <= 9	numeric
number(p,s), 13 <= p <= 38, -24 <= s <= 38	bignumeric
number(p,s), 13 <= p <= 38, -84 <= s <= 127	string
number(p,s), 14 <= p <= 38, -15 <= s <= 9	numeric
number(p,s), 14 <= p <= 38, -23 <= s <= 38	bignumeric
number(p,s), 14 <= p <= 38, -84 <= s <= 127	string
number(p,s), 15 <= p <= 38, -14 <= s <= 9	numeric
number(p,s), 15 <= p <= 38, -22 <= s <= 38	bignumeric
number(p,s), 15 <= p <= 38, -84 <= s <= 127	string
number(p,s), 16 <= p <= 38, -13 <= s <= 9	numeric
number(p,s), 16 <= p <= 38, -21 <= s <= 38	bignumeric
number(p,s), 16 <= p <= 38, -84 <= s <= 127	string
number(p,s), 17 <= p <= 38, -12 <= s <= 9	numeric
number(p,s), 17 <= p <= 38, -20 <= s <= 38	bignumeric
number(p,s), 17 <= p <= 38, -84 <= s <= 127	string
number(p,s), 18 <= p <= 38, -11 <= s <= 9	numeric
number(p,s), 18 <= p <= 38, -19 <= s <= 38	bignumeric
number(p,s), 18 <= p <= 38, -84 <= s <= 127	string
number(p,s), 19 <= p <= 38, -10 <= s <= 9	numeric
number(p,s), 19 <= p <= 38, -18 <= s <= 38	bignumeric
number(p,s), 19 <= p <= 38, -84 <= s <= 127	string
number(p,s), 2 <= p <= 38, -27 <= s <= 9	numeric
number(p,s), 2 <= p <= 38, -35 <= s <= 38	bignumeric
number(p,s), 2 <= p <= 38, -84 <= s <= 127	string
number(p,s), 20 <= p <= 38, -17 <= s <= 38	bignumeric
number(p,s), 20 <= p <= 38, -84 <= s <= 127	string
number(p,s), 20 <= p <= 38, -9 <= s <= 9	numeric
number(p,s), 21 <= p <= 38, -16 <= s <= 38	bignumeric
number(p,s), 21 <= p <= 38, -8 <= s <= 9	numeric
number(p,s), 21 <= p <= 38, -84 <= s <= 127	string
number(p,s), 22 <= p <= 38, -15 <= s <= 38	bignumeric
number(p,s), 22 <= p <= 38, -7 <= s <= 9	numeric
number(p,s), 22 <= p <= 38, -84 <= s <= 127	string
number(p,s), 23 <= p <= 38, -14 <= s <= 38	bignumeric
number(p,s), 23 <= p <= 38, -6 <= s <= 9	numeric
number(p,s), 23 <= p <= 38, -84 <= s <= 127	string
number(p,s), 24 <= p <= 38, -13 <= s <= 38	bignumeric
number(p,s), 24 <= p <= 38, -5 <= s <= 9	numeric
number(p,s), 24 <= p <= 38, -84 <= s <= 127	string
number(p,s), 25 <= p <= 38, -12 <= s <= 38	bignumeric
number(p,s), 25 <= p <= 38, -4 <= s <= 9	numeric
number(p,s), 25 <= p <= 38, -84 <= s <= 127	string
number(p,s), 26 <= p <= 38, -11 <= s <= 38	bignumeric
number(p,s), 26 <= p <= 38, -3 <= s <= 9	numeric
number(p,s), 26 <= p <= 38, -84 <= s <= 127	string
number(p,s), 27 <= p <= 38, -10 <= s <= 38	bignumeric
number(p,s), 27 <= p <= 38, -2 <= s <= 9	numeric
number(p,s), 27 <= p <= 38, -84 <= s <= 127	string
number(p,s), 28 <= p <= 38, -1 <= s <= 9	numeric
number(p,s), 28 <= p <= 38, -84 <= s <= 127	string
number(p,s), 28 <= p <= 38, -9 <= s <= 38	bignumeric
number(p,s), 29 <= p <= 38, -8 <= s <= 38	bignumeric
number(p,s), 29 <= p <= 38, -84 <= s <= 127	string
number(p,s), 29 <= p <= 38, 0 <= s <= 9	numeric
number(p,s), 3 <= p <= 38, -26 <= s <= 9	numeric
number(p,s), 3 <= p <= 38, -34 <= s <= 38	bignumeric
number(p,s), 3 <= p <= 38, -84 <= s <= 127	string
number(p,s), 30 <= p <= 38, -7 <= s <= 38	bignumeric
number(p,s), 30 <= p <= 38, -84 <= s <= 127	string
number(p,s), 30 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 31 <= p <= 38, -6 <= s <= 38	bignumeric
number(p,s), 31 <= p <= 38, -84 <= s <= 127	string
number(p,s), 31 <= p <= 38, 2 <= s <= 9	numeric
number(p,s), 32 <= p <= 38, -5 <= s <= 38	bignumeric
number(p,s), 32 <= p <= 38, -84 <= s <= 127	string
number(p,s), 32 <= p <= 38, 3 <= s <= 9	numeric
number(p,s), 33 <= p <= 38, -4 <= s <= 38	bignumeric
number(p,s), 33 <= p <= 38, -84 <= s <= 127	string
number(p,s), 33 <= p <= 38, 4 <= s <= 9	numeric
number(p,s), 34 <= p <= 38, -3 <= s <= 38	bignumeric
number(p,s), 34 <= p <= 38, -84 <= s <= 127	string
number(p,s), 34 <= p <= 38, 5 <= s <= 9	numeric
number(p,s), 35 <= p <= 38, -2 <= s <= 38	bignumeric
number(p,s), 35 <= p <= 38, -84 <= s <= 127	string
number(p,s), 35 <= p <= 38, 6 <= s <= 9	numeric
number(p,s), 36 <= p <= 37, -1 <= s <= 38	bignumeric
number(p,s), 36 <= p <= 38, -84 <= s <= 127	string
number(p,s), 36 <= p <= 38, 7 <= s <= 9	numeric
number(p,s), 37 <= p <= 38, -84 <= s <= 127	string
number(p,s), 37 <= p <= 38, 1 <= s <= 38	bignumeric
number(p,s), 37 <= p <= 38, 8 <= s <= 9	numeric
number(p,s), 4 <= p <= 38, -25 <= s <= 9	numeric
number(p,s), 4 <= p <= 38, -33 <= s <= 38	bignumeric
number(p,s), 4 <= p <= 38, -84 <= s <= 127	string
number(p,s), 5 <= p <= 38, -24 <= s <= 9	numeric
number(p,s), 5 <= p <= 38, -32 <= s <= 38	bignumeric
number(p,s), 5 <= p <= 38, -84 <= s <= 127	string
number(p,s), 6 <= p <= 38, -23 <= s <= 9	numeric
number(p,s), 6 <= p <= 38, -31 <= s <= 38	bignumeric
number(p,s), 6 <= p <= 38, -84 <= s <= 127	string
number(p,s), 7 <= p <= 38, -22 <= s <= 9	numeric
number(p,s), 7 <= p <= 38, -30 <= s <= 38	bignumeric
number(p,s), 7 <= p <= 38, -84 <= s <= 127	string
number(p,s), 8 <= p <= 38, -21 <= s <= 9	numeric
number(p,s), 8 <= p <= 38, -29 <= s <= 38	bignumeric
number(p,s), 8 <= p <= 38, -84 <= s <= 127	string
number(p,s), 9 <= p <= 38, -20 <= s <= 9	numeric
number(p,s), 9 <= p <= 38, -28 <= s <= 38	bignumeric
number(p,s), 9 <= p <= 38, -84 <= s <= 127	string
nvarchar2(s char), 1 <= s <= 4000	string
raw(`size`), 1 <= s <= 4000	bytes
rowid	string
timestamp(`precision`) with time zone, 0 <= p <= 6	timestamp
timestamp(`precision`) with time zone, 7 <= p <= 9	string
timestamp(`precision`), 1 <= p <= 6	datetime
timestamp(`precision`), 7 <= p <= 9	string
varchar2(s byte), 1 <= s <= 4000	string
varchar2(s char), 1 <= s <= 4000	string

Rename Saved Search

Table of Contents

Mass Ingestion

Mass Ingestion

Oracle Source and Google BigQuery Target

Oracle Source and Google BigQuery Target