BigQuery tests

We could create a BigQuery project dedicated for unit tests. We could use pytest's [mark](https://docs.pytest.org/en/7.1.x/example/markers.html) feature to select these unit tests. That way, they could be triggered during CI, and optionally during local development.