Query BigQuery from an Angular App using Callable Firebase Functions.

BigQuery can be queried using either the REST API or using one of the client libraries.

In this post, we look at how to use the BigQuery NodeJS client SDK within a Firebase Function, configured as callable.

We also look at how to use Google Cloud Storage to save the query results as a CSV file, to overcome the response limit and support large number of rows.

Outline:

• Gitlab CI/CD
• Angular
• Firebase Function
• BigQuery
• Google Cloud Storage

Gitlab CI/CD:

Create Firebase keys for CI and add to Gitlab CI environment variables

create gitlab repo firebase init firebase login:ci Add CI token to Gitlab CI/CD Settings

Create a GCP SA with access to BigQuery

This is the SA that the Callable Firebase function will use to access the BigQuery API