Mass Ingestion

Back Next

MySQL Source and Google BigQuery Target

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

MySQL Source Data Type	Google BigQuery Target Data Type
bigint	int64
bigint unsigned	bignumeric
binary(`size`), 1 <= s <= 255	bytes
bit(`precision`), 1 <= p <= 64	bytes
blob	bytes
char(`size`), 1 <= s <= 255	string
date	date
datetime	datetime
decimal	int64
decimal(1)	int64
decimal(1,1)	numeric
decimal(10,10)	bignumeric
decimal(11)	int64
decimal(11,s), 10 <= s <= 11	bignumeric
decimal(12)	int64
decimal(12,s), 10 <= s <= 12	bignumeric
decimal(13)	int64
decimal(13,s), 10 <= s <= 13	bignumeric
decimal(14)	int64
decimal(14,s), 10 <= s <= 14	bignumeric
decimal(15)	int64
decimal(15,s), 10 <= s <= 15	bignumeric
decimal(16)	int64
decimal(16,s), 10 <= s <= 16	bignumeric
decimal(17)	int64
decimal(17,s), 10 <= s <= 17	bignumeric
decimal(18)	int64
decimal(18,s), 10 <= s <= 18	bignumeric
decimal(19,s), 10 <= s <= 19	bignumeric
decimal(2)	int64
decimal(2,s), 1 <= s <= 2	numeric
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(3)	int64
decimal(3,s), 1 <= s <= 3	numeric
decimal(38,9)	numeric
decimal(4)	int64
decimal(4,s), 1 <= s <= 4	numeric
decimal(40)	string
decimal(40,s), 1 <= s <= 21	bignumeric
decimal(41,s), 0 <= s <= 1	string
decimal(41,s), 2 <= s <= 22	bignumeric
decimal(42,s), 0 <= s <= 2	string
decimal(42,s), 3 <= s <= 23	bignumeric
decimal(43,s), 0 <= s <= 3	string
decimal(43,s), 4 <= s <= 24	bignumeric
decimal(44,s), 0 <= s <= 4	string
decimal(44,s), 5 <= s <= 25	bignumeric
decimal(45,s), 0 <= s <= 5	string
decimal(45,s), 6 <= s <= 26	bignumeric
decimal(46,s), 0 <= s <= 6	string
decimal(46,s), 7 <= s <= 27	bignumeric
decimal(47,s), 0 <= s <= 7	string
decimal(47,s), 8 <= s <= 28	bignumeric
decimal(48,s), 0 <= s <= 8	string
decimal(49,s), 0 <= s <= 9	string
decimal(5)	int64
decimal(5,s), 1 <= s <= 5	numeric
decimal(50,s), 0 <= s <= 10	string
decimal(51,s), 0 <= s <= 11	string
decimal(52,s), 0 <= s <= 12	string
decimal(53,s), 0 <= s <= 13	string
decimal(54,s), 0 <= s <= 14	string
decimal(55,s), 0 <= s <= 15	string
decimal(56,s), 0 <= s <= 16	string
decimal(57,s), 0 <= s <= 17	string
decimal(58,s), 0 <= s <= 18	string
decimal(59,s), 0 <= s <= 19	string
decimal(6)	int64
decimal(6,s), 1 <= s <= 6	numeric
decimal(60,s), 0 <= s <= 20	string
decimal(61,s), 0 <= s <= 21	string
decimal(62,s), 0 <= s <= 22	string
decimal(63,s), 0 <= s <= 23	string
decimal(64,s), 0 <= s <= 24	string
decimal(64,s), 25 <= s <= 29	bignumeric
decimal(65,s), 0 <= s <= 25	string
decimal(7)	int64
decimal(7,s), 1 <= s <= 7	numeric
decimal(8)	int64
decimal(8,s), 1 <= s <= 8	numeric
decimal(9)	int64
decimal(p,s), 10 <= 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, 0 <= s <= 9	numeric
decimal(p,s), 20 <= p <= 38, 0 <= s <= 9	numeric
decimal(p,s), 21 <= p <= 38, 0 <= s <= 9	numeric
decimal(p,s), 22 <= p <= 38, 0 <= s <= 9	numeric
decimal(p,s), 23 <= p <= 38, 0 <= s <= 9	numeric
decimal(p,s), 24 <= p <= 38, 0 <= s <= 9	numeric
decimal(p,s), 25 <= p <= 38, 0 <= s <= 9	numeric
decimal(p,s), 26 <= p <= 38, 0 <= s <= 9	numeric
decimal(p,s), 27 <= p <= 38, 0 <= s <= 9	numeric
decimal(p,s), 28 <= p <= 38, 0 <= s <= 9	numeric
decimal(p,s), 29 <= p <= 38, 0 <= s <= 9	numeric
decimal(p,s), 29 <= p <= 64, 10 <= s <= 29	bignumeric
decimal(p,s), 30 <= p <= 38, 1 <= s <= 9	numeric
decimal(p,s), 30 <= p <= 64, 1 <= s <= 29	bignumeric
decimal(p,s), 31 <= p <= 38, 2 <= s <= 9	numeric
decimal(p,s), 31 <= p <= 64, 1 <= s <= 29	bignumeric
decimal(p,s), 32 <= p <= 38, 3 <= s <= 9	numeric
decimal(p,s), 32 <= p <= 64, 1 <= s <= 29	bignumeric
decimal(p,s), 33 <= p <= 38, 4 <= s <= 9	numeric
decimal(p,s), 33 <= p <= 64, 1 <= s <= 29	bignumeric
decimal(p,s), 34 <= p <= 38, 5 <= s <= 9	numeric
decimal(p,s), 34 <= p <= 64, 1 <= s <= 29	bignumeric
decimal(p,s), 35 <= p <= 38, 6 <= s <= 9	numeric
decimal(p,s), 35 <= p <= 64, 1 <= s <= 29	bignumeric
decimal(p,s), 36 <= p <= 38, 7 <= s <= 9	numeric
decimal(p,s), 36 <= p <= 64, 1 <= s <= 29	bignumeric
decimal(p,s), 37 <= p <= 38, 8 <= s <= 9	numeric
decimal(p,s), 37 <= p <= 64, 1 <= s <= 29	bignumeric
decimal(p,s), 38 <= p <= 64, 1 <= s <= 29	bignumeric
decimal(p,s), 39 <= p <= 65, 21 <= s <= 29	bignumeric
decimal(p,s), 48 <= p <= 64, 9 <= s <= 29	bignumeric
decimal(p,s), 49 <= p <= 64, 10 <= s <= 29	bignumeric
decimal(p,s), 50 <= p <= 64, 11 <= s <= 29	bignumeric
decimal(p,s), 51 <= p <= 64, 12 <= s <= 29	bignumeric
decimal(p,s), 52 <= p <= 64, 13 <= s <= 29	bignumeric
decimal(p,s), 53 <= p <= 64, 14 <= s <= 29	bignumeric
decimal(p,s), 54 <= p <= 64, 15 <= s <= 29	bignumeric
decimal(p,s), 55 <= p <= 64, 16 <= s <= 29	bignumeric
decimal(p,s), 56 <= p <= 64, 17 <= s <= 29	bignumeric
decimal(p,s), 57 <= p <= 64, 18 <= s <= 29	bignumeric
decimal(p,s), 58 <= p <= 64, 19 <= s <= 29	bignumeric
decimal(p,s), 59 <= p <= 64, 20 <= s <= 29	bignumeric
decimal(p,s), 60 <= p <= 64, 21 <= s <= 29	bignumeric
decimal(p,s), 61 <= p <= 64, 22 <= s <= 29	bignumeric
decimal(p,s), 62 <= p <= 64, 23 <= s <= 29	bignumeric
decimal(p,s), 63 <= p <= 64, 24 <= s <= 29	bignumeric
decimal(p,s), 9 <= p <= 38, 1 <= s <= 9	numeric
double	float64
float	float64
geomcollection	bytes
geometry	bytes
geometrycollection	bytes
int	int64
int unsigned	int64
json	string
linestring	bytes
longblob	bytes
longtext	string
mediumblob	bytes
mediumint	int64
mediumint unsigned	int64
mediumtext	string
multilinestring	bytes
multipoint	bytes
multipolygon	bytes
numeric	int64
point	bytes
polygon	bytes
smallint	int64
smallint unsigned	int64
text	string
time(`precision`), 0 <= p <= 6	string
timestamp(`precision`), 0 <= p <= 6	datetime
tinyblob	bytes
tinyint	int64
tinyint unsigned	int64
tinytext	string
varbinary(`size`), 1 <= s <= 65535	bytes
varchar(`size`), 1 <= s <= 21844	string
year	int64

Rename Saved Search

Table of Contents

Mass Ingestion

Mass Ingestion

MySQL Source and Google BigQuery Target

MySQL Source and Google BigQuery Target