BigQuery

Google Cloud’s analytics warehouse. For complex analytics queries on large datasets.

BigQuery is Google’s analytics warehouse. Use for complex SQL analytics on large datasets — think “ten million events” rather than “ten thousand rows”.

Full walkthrough being written.

Common uses

• Stream events from Convex to BigQuery for analytics.
• Run ad-hoc analytical queries without slowing your app DB.
• Power dashboards that aggregate over millions of rows.

Setup

Service account JSON in vly secrets as GOOGLE_CLOUD_CREDENTIALS. Stream from Convex actions via the BigQuery insert API.

Related

Snowflake

Enterprise alternative.

Dashboard recipe

Where this gets used.

Caching

Materializing aggregates.