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