Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
PostgreSQL Source Data Type | Google BigQuery Target Data Type |
|---|---|
bigint | int64 |
bit varying( precision ), 1 <= p <= 83700001 | bytes |
bit( precision ), 1 <= p <= 83886080 | bytes |
boolean | bool |
box | bytes |
character varying( size ), 1 <= s <= 10485760 | string |
character( size ), 1 <= s <= 10485760 | string |
cidr | string |
circle | bytes |
date | date |
daterange | string |
double precision | float64 |
inet | string |
int4range | string |
int8range | string |
integer | int64 |
line | bytes |
lseg | bytes |
macaddr | string |
macaddr8 | string |
money | numeric |
numeric(1) | int64 |
numeric(1,1) | numeric |
numeric(10) | int64 |
numeric(10,10) | bignumeric |
numeric(11) | int64 |
numeric(11,s), 10 <= s <= 11 | bignumeric |
numeric(12) | int64 |
numeric(12,s), 10 <= s <= 12 | bignumeric |
numeric(13) | int64 |
numeric(13,s), 10 <= s <= 13 | bignumeric |
numeric(14) | int64 |
numeric(14,s), 10 <= s <= 14 | bignumeric |
numeric(15) | int64 |
numeric(15,s), 10 <= s <= 15 | bignumeric |
numeric(16) | int64 |
numeric(16,s), 10 <= s <= 16 | bignumeric |
numeric(17) | int64 |
numeric(17,s), 10 <= s <= 17 | bignumeric |
numeric(18) | int64 |
numeric(18,s), 10 <= s <= 18 | bignumeric |
numeric(19,s), 10 <= s <= 19 | bignumeric |
numeric(2) | int64 |
numeric(2,s), 1 <= s <= 2 | numeric |
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(3) | int64 |
numeric(3,s), 1 <= s <= 3 | numeric |
numeric(38,9) | numeric |
numeric(38,s), 10 <= s <= 38 | bignumeric |
numeric(4) | int64 |
numeric(4,s), 1 <= s <= 4 | numeric |
numeric(5) | int64 |
numeric(5,s), 1 <= s <= 5 | numeric |
numeric(6) | int64 |
numeric(6,s), 1 <= s <= 6 | numeric |
numeric(7) | int64 |
numeric(7,s), 1 <= s <= 7 | numeric |
numeric(8) | int64 |
numeric(8,s), 1 <= s <= 8 | numeric |
numeric(9) | int64 |
numeric(p,s), 10 <= 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, 0 <= s <= 9 | numeric |
numeric(p,s), 20 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 21 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 22 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 23 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 24 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 25 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 26 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 27 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 28 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 29 <= p <= 30, 10 <= s <= 29 | bignumeric |
numeric(p,s), 29 <= p <= 38, 0 <= 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 |
numeric(p,s), 39 <= p <= 999, 39 <= s <= 998 | string |
numeric(p,s), 9 <= p <= 38, 1 <= s <= 9 | numeric |
numrange | string |
path | bytes |
point | bytes |
polygon | bytes |
real | float64 |
smallint | int64 |
time( precision ) with time zone, 0 <= p <= 6 | string |
time( precision ) without time zone, 0 <= p <= 6 | time |
timestamp( precision ) with time zone, 0 <= p <= 6 | timestamp |
timestamp( precision ) without time zone, 0 <= p <= 6 | datetime |
tsrange | string |
tstzrange | string |
uuid | string |
