Skip to main content

BigQuery for Analytics Services

Recommendation
Updated
Moved
USE
2022-05-02

What is it

BigQuery for backend services is a technique that involves leveraging BigQuery to develop user-facing insights features, without any other, intermediate persistent storage.

When to use it

Use BigQuery for backend services to speed up development of insights features, especially at the prototyping stage, but we've found through experience that a surprising amount of use cases can be implemented directly on top of BigQuery. Consider speeding up repeated queries by adding caching when needed.

Consider data ownership

When reading directly from BigQuery in a backend service, make sure that the Data Mesh node you read from is part of the same system as your backend service. Avoid building dependencies on data that is not under the same ownership as your service, or may not be in the future.