I'm pretty new in the ODK/GCP world. For my project I am considering to import ODK data from Aggregate to Google BigQuery. ODK Aggregate is installed on Google App Engine. As you write in your post, it should be possible to import data to BigQuery via Google Cloud Storage. Right now, I'd like to figure out 1) how to export the ODK Forms and Submissions from Aggregate to a Google Cloud Storage Bucket (e.g. as JSON-Files) and 2) How to export and import media files to Google BigQuery. Do you have any experience doing that?
Any help would be greatly appreciated. Thank you!