Connecting ODK Central form submissions data to BQ

[Matthew_White]

@akt01

using Cloud SQL (not sure if ODK central can support this, i.e., external postgres, perhaps this could be a solution?).

You can use an external database with Central, but we don't recommend accessing the database directly: the database is not considered user-facing, so its structure may change at any time. I haven't worked with BigQuery, and I'm not sure whether Cloud SQL is the right approach, but you could consider looking into this approach to populating a Postgres database using the Central API:

Central2pg : PostgreSQL set of functions to get data from Central

Hi to all, here is a first shared version of a recent hard work, which allow us to automate data retrieval from Central into PostgreSQL/PostGIS database. Functions dynamically create PostgreSQL tables from Central's json and keep geojson fields as geojson. Functions are here : https://framagit.org/mathieubossaert/central2pg Feel free to comment, criticize and improve the work. Coming features into central will facilitate its improvement. I will have some questions about some details ; I ju…

Maybe Cloud SQL could pull from such a database once it's set up?

I also wanted to link to Getting Data Out in case that discussion is useful.