This article will show you how to create an API with API Gateway and a Cloud Functions backend that queries BigQuery. It will return all rows in a BigQuery table for a date specified in the API query.

When I had to set up an API that returned the contents of a BigQuery table for a given date, I couldn’t find a tutorial that gave me enough specific information, even in Google’s docs, so I wanted to write up how I did it in the hope that it might help someone else save some time!

Make two new service accounts

I always forget to do…

Thoughts from a 30 year old who has been unemployed for a year and a half

I never thought I would be in this position. When I graduated from university, I thought, worst-case scenario, that it would take me six months to find a job. Oh how wrong I was. Through the highs and lows of job applications and rejections I have learned a few things that have made day-to-day life a bit less awful, which I want to share with you.

Photo by Julia M Cameron from Pexels

1. Ask yourself — what does feeling productive mean to you?

There has been a lot of debate about the pressure to feel ‘productive’ during lockdown. I understand both sides of this debate, but for me, productivity doesn’t have to be a large overwhelming pressure.


Data Engineer. PhD in Marine Ecology. I love writing, data, science and crafts (not always in that order)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store