Empty results for BigQuery in Google Cloud serverless mode

[landyrev]

Describe the bug
BigQuery cubes return empty datasets while running in Google Cloud serverless mode

To Reproduce
Steps to reproduce the behavior:

1. Setup CobeJs in serverless mode (for example)
2. Deploy it to Google Cloud
3. Try to query any BigQuery cube (for example {"measures":["Orders.count"]})
4. Get empty result, without any errors

Expected behavior
Query result is not empty (as if you run it locally)

Version:
@cubejs-backend/bigquery-driver 0.10.11
@cubejs-backend/serverless 0.10.11
@cubejs-backend/serverless-google 0.10.11
@google-cloud/bigquery 2.1

[landyrev]

Thanks to this thread I found workaround: downgrading @google-cloud/bigquery to 1.3.x and forking @cubejs-backend/bigquery-driver (because it’s in incompatible with older version) helped me to get non empty results from bigquery cubes

[landyrev]

Updating @google-cloud/bigquery to 4.1.4 version (latest for now) solves problem too.

Maybe it's good idea to update bigquery client version in bigquery-driver's package.json dependencies?

[paveltiunov]

@landyrev That's a great catch! Yeah. Definitely makes sense to upgrade version in driver. Would love if you provide PR for that.

[landyrev]

And here is related @google-cloud/bigquery issue: googleapis/nodejs-bigquery#463