Mass Ingestion

Back Next

Teradata Source and Google BigQuery Target

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

Teradata Source Data Type	Google BigQuery Target Data Type
array	bytes
bigint	int64
blob	bytes
byte(`precision`), 1 <= p <= 64000	bytes
byteint	int64
char(`size`), 4 <= s <= 256000	string
clob	string
date	date
decimal(10,10)	bignumeric
decimal(11,s), 10 <= s <= 11	bignumeric
decimal(12,s), 10 <= s <= 12	bignumeric
decimal(13,s), 10 <= s <= 13	bignumeric
decimal(14,s), 10 <= s <= 14	bignumeric
decimal(15,s), 10 <= s <= 15	bignumeric
decimal(16,s), 10 <= s <= 16	bignumeric
decimal(17,s), 10 <= s <= 17	bignumeric
decimal(18,s), 10 <= s <= 18	bignumeric
decimal(19,s), 10 <= s <= 19	bignumeric
decimal(20,s), 10 <= s <= 20	bignumeric
decimal(21,s), 10 <= s <= 21	bignumeric
decimal(22,s), 10 <= s <= 22	bignumeric
decimal(23,s), 10 <= s <= 23	bignumeric
decimal(24,s), 10 <= s <= 24	bignumeric
decimal(25,s), 10 <= s <= 25	bignumeric
decimal(26,s), 10 <= s <= 26	bignumeric
decimal(27,s), 10 <= s <= 27	bignumeric
decimal(28,s), 10 <= s <= 28	bignumeric
decimal(29,s), 10 <= s <= 29	bignumeric
decimal(38,9)	numeric
decimal(`precision`), 1 <= p <= 18	int64
decimal(`precision`), 19 <= p <= 29	numeric
decimal(`precision`), 30 <= p <= 38	bignumeric
decimal(p,s), 1 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 11 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 12 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 13 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 14 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 15 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 16 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 17 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 18 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 19 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 20 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 21 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 22 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 23 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 24 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 25 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 26 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 27 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 28 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 29 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 30 <= p <= 31, 1 <= s <= 30	bignumeric
decimal(p,s), 30 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 31 <= p <= 32, 1 <= s <= 31	bignumeric
decimal(p,s), 31 <= p <= 38, 2 <= s <= 9	numeric
decimal(p,s), 32 <= p <= 33, 1 <= s <= 32	bignumeric
decimal(p,s), 32 <= p <= 38, 3 <= s <= 9	numeric
decimal(p,s), 33 <= p <= 34, 1 <= s <= 33	bignumeric
decimal(p,s), 33 <= p <= 38, 4 <= s <= 9	numeric
decimal(p,s), 34 <= p <= 35, 1 <= s <= 34	bignumeric
decimal(p,s), 34 <= p <= 38, 5 <= s <= 9	numeric
decimal(p,s), 35 <= p <= 36, 1 <= s <= 35	bignumeric
decimal(p,s), 35 <= p <= 38, 6 <= s <= 9	numeric
decimal(p,s), 36 <= p <= 37, 1 <= s <= 36	bignumeric
decimal(p,s), 36 <= p <= 38, 7 <= s <= 9	numeric
decimal(p,s), 37 <= p <= 38, 1 <= s <= 37	bignumeric
decimal(p,s), 37 <= p <= 38, 8 <= s <= 9	numeric
float	float64
integer	int64
interval day(`precision`) to hour, 1 <= p <= 4	string
interval day(`precision`) to minute, 1 <= p <= 4	string
interval day(`precision`) to second (s), 1 <= p <= 4, 0 <= s <= 6	string
interval day(`precision`), 1 <= p <= 4	string
interval hour(`precision`) to minute, 1 <= p <= 4	string
interval hour(`precision`) to second (s), 1 <= p <= 4, 0 <= s <= 6	string
interval hour(`precision`), 1 <= p <= 4	string
interval minute(`precision`) to second (s), 1 <= p <= 4, 0 <= s <= 6	string
interval minute(`precision`), 1 <= p <= 4	string
interval month(`precision`), 1 <= p <= 4	string
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6	string
interval year(`precision`) to month, 1 <= p <= 4	string
interval year(`precision`), 1 <= p <= 4	string
json	string
mbr	bytes
number(*,s), 0 <= s <= 37	string
number(10,10)	bignumeric
number(11,s), 10 <= s <= 11	bignumeric
number(12,s), 10 <= s <= 12	bignumeric
number(13,s), 10 <= s <= 13	bignumeric
number(14,s), 10 <= s <= 14	bignumeric
number(15,s), 10 <= s <= 15	bignumeric
number(16,s), 10 <= s <= 16	bignumeric
number(17,s), 10 <= s <= 17	bignumeric
number(18,s), 10 <= s <= 18	bignumeric
number(19,s), 10 <= s <= 19	bignumeric
number(20,s), 10 <= s <= 20	bignumeric
number(21,s), 10 <= s <= 21	bignumeric
number(22,s), 10 <= s <= 22	bignumeric
number(23,s), 10 <= s <= 23	bignumeric
number(24,s), 10 <= s <= 24	bignumeric
number(25,s), 10 <= s <= 25	bignumeric
number(26,s), 10 <= s <= 26	bignumeric
number(27,s), 10 <= s <= 27	bignumeric
number(28,s), 10 <= s <= 28	bignumeric
number(29,s), 10 <= s <= 29	bignumeric
number(38,9)	numeric
number(`precision`), 1 <= p <= 18	int64
number(`precision`), 19 <= p <= 29	numeric
number(`precision`), 30 <= p <= 36	bignumeric
number(p,s), 1 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 11 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 12 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 13 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 14 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 15 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 16 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 17 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 18 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 19 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 20 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 21 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 22 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 23 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 24 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 25 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 26 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 27 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 28 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 29 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 30 <= p <= 31, 1 <= s <= 30	bignumeric
number(p,s), 30 <= p <= 38, 1 <= s <= 9	numeric
number(p,s), 31 <= p <= 32, 1 <= s <= 31	bignumeric
number(p,s), 31 <= p <= 38, 2 <= s <= 9	numeric
number(p,s), 32 <= p <= 33, 1 <= s <= 32	bignumeric
number(p,s), 32 <= p <= 38, 3 <= s <= 9	numeric
number(p,s), 33 <= p <= 34, 1 <= s <= 33	bignumeric
number(p,s), 33 <= p <= 38, 4 <= s <= 9	numeric
number(p,s), 34 <= p <= 35, 1 <= s <= 34	bignumeric
number(p,s), 34 <= p <= 38, 5 <= s <= 9	numeric
number(p,s), 35 <= p <= 36, 1 <= s <= 35	bignumeric
number(p,s), 35 <= p <= 38, 6 <= s <= 9	numeric
number(p,s), 36 <= p <= 37, 1 <= s <= 36	bignumeric
number(p,s), 36 <= p <= 38, 7 <= s <= 9	numeric
number(p,s), 37 <= p <= 38, 1 <= s <= 37	bignumeric
number(p,s), 37 <= p <= 38, 8 <= s <= 9	numeric
numeric(10,10)	bignumeric
numeric(11,s), 10 <= s <= 11	bignumeric
numeric(12,s), 10 <= s <= 12	bignumeric
numeric(13,s), 10 <= s <= 13	bignumeric
numeric(14,s), 10 <= s <= 14	bignumeric
numeric(15,s), 10 <= s <= 15	bignumeric
numeric(16,s), 10 <= s <= 16	bignumeric
numeric(17,s), 10 <= s <= 17	bignumeric
numeric(18,s), 10 <= s <= 18	bignumeric
numeric(19,s), 10 <= s <= 19	bignumeric
numeric(20,s), 10 <= s <= 20	bignumeric
numeric(21,s), 10 <= s <= 21	bignumeric
numeric(22,s), 10 <= s <= 22	bignumeric
numeric(23,s), 10 <= s <= 23	bignumeric
numeric(24,s), 10 <= s <= 24	bignumeric
numeric(25,s), 10 <= s <= 25	bignumeric
numeric(26,s), 10 <= s <= 26	bignumeric
numeric(27,s), 10 <= s <= 27	bignumeric
numeric(28,s), 10 <= s <= 28	bignumeric
numeric(29,s), 10 <= s <= 29	bignumeric
numeric(38,9)	numeric
numeric(`precision`), 1 <= p <= 18	int64
numeric(`precision`), 19 <= p <= 29	numeric
numeric(`precision`), 30 <= p <= 36	bignumeric
numeric(p,s), 1 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 11 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 12 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 13 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 14 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 15 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 16 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 17 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 18 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 19 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 20 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 21 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 22 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 23 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 24 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 25 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 26 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 27 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 28 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 29 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 30 <= p <= 31, 1 <= s <= 30	bignumeric
numeric(p,s), 30 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 31 <= p <= 32, 1 <= s <= 31	bignumeric
numeric(p,s), 31 <= p <= 38, 2 <= s <= 9	numeric
numeric(p,s), 32 <= p <= 33, 1 <= s <= 32	bignumeric
numeric(p,s), 32 <= p <= 38, 3 <= s <= 9	numeric
numeric(p,s), 33 <= p <= 34, 1 <= s <= 33	bignumeric
numeric(p,s), 33 <= p <= 38, 4 <= s <= 9	numeric
numeric(p,s), 34 <= p <= 35, 1 <= s <= 34	bignumeric
numeric(p,s), 34 <= p <= 38, 5 <= s <= 9	numeric
numeric(p,s), 35 <= p <= 36, 1 <= s <= 35	bignumeric
numeric(p,s), 35 <= p <= 38, 6 <= s <= 9	numeric
numeric(p,s), 36 <= p <= 37, 1 <= s <= 36	bignumeric
numeric(p,s), 36 <= p <= 38, 7 <= s <= 9	numeric
numeric(p,s), 37 <= p <= 38, 1 <= s <= 37	bignumeric
numeric(p,s), 37 <= p <= 38, 8 <= s <= 9	numeric
period(date)	string
period(time(`precision`) with time zone), 0 <= p <= 6	string
period(time(`precision`) ), 0 <= p <= 6	string
period(timestamp(`precision`) with time zone), 0 <= p <= 6	string
period(timestamp(`precision`) ), 0 <= p <= 6	string
smallint	int64
time(`precision`) with time zone, 0 <= p <= 6	timestamp
time(`precision`), 0 <= p <= 6	time
timestamp(`precision`) with time zone, 0 <= p <= 6	timestamp
timestamp(`precision`), 0 <= p <= 6	datetime
varbyte(`precision`), 1 <= p <= 64000	bytes
varchar(`size`), 4 <= s <= 256000	string
varray	bytes
xml	string

Rename Saved Search

Table of Contents

Mass Ingestion

Mass Ingestion

Teradata Source and Google BigQuery Target

Teradata Source and Google BigQuery Target