Google BigQuery to MySQL mapping
AutoSync maps Google BigQuery object types to the following MySQL column types:
Google BigQuery object type | MySQL column type |
---|---|
varchar |
VARCHAR |
ARRAY |
VARCHAR |
BIGNUMERIC |
VARCHAR |
BOOL |
BIT |
BYTES |
BLOB |
DATE |
DATE |
DATETIME |
DATETIME |
FLOAT64 |
DOUBLE |
GEOGRAPHY |
VARCHAR |
INT64 |
BIGINT |
INTERVAL |
VARCHAR |
JSON |
JSON |
NUMERIC |
DECIMAL |
STRING |
VARCHAR |
STRUCT |
JSON |
TIME |
TIME |
TIMESTAMP |
DATETIME |
sl_timestamp |
DATETIME |