To move data from Affinity to Google BigQuery automatically, use a ready-made scenario — no manual exports.
You can launch this Affinity + Google BigQuery integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.