Google BigQuery to Google BigQuery mapping
AutoSync maps data from a Google BigQuery source to a BigQuery destination as follows:
Source BigQuery type | Destination BigQuery typee |
---|---|
varchar |
STRING |
ARRAY |
STRING |
BIGNUMERIC |
BIGNUMERIC |
BOOL |
BOOL |
BYTES |
BYTES |
DATE |
DATE |
DATETIME |
DATETIME |
FLOAT64 |
FLOAT64 |
GEOGRAPHY |
STRING |
INT64 |
INT64 |
INTERVAL |
STRING |
JSON |
JSON |
NUMERIC |
NUMERIC |
STRING |
STRING |
STRUCT |
JSON |
TIME |
TIME |
TIMESTAMP |
TIMESTAMP |
sl_timestamp |
TIMESTAMP |