Google Cloud Storage (GCS) to BigQuery the simple way

Because simple is better than complex.

The first Cloud Function I ever deployed was to achieve exactly this task. We had a number of CSV files being dropped into a Google Cloud Storage bucket every night, which needed to be available for transformation and analysis in BigQuery.

Spending some time on Google brought me to this how-to guide, which was a little different (JSON files instead of CSV), but I figured I could tweak it a bit and get it to work. After all, it’s a pretty common workflow in the world of…