> ## Documentation Index
> Fetch the complete documentation index at: https://vlyai-1c28d863.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# BigQuery

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

[BigQuery](https://cloud.google.com/bigquery) is Google's analytics warehouse. Use for complex SQL analytics on large datasets — think "ten million events" rather than "ten thousand rows".

<Note>
  Full walkthrough being written.
</Note>

## 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

<CardGroup cols={3}>
  <Card title="Snowflake" icon="snowflake" href="/integrations/snowflake">
    Enterprise alternative.
  </Card>

  <Card title="Dashboard recipe" icon="chart-bar" href="/recipes/dashboard-with-charts">
    Where this gets used.
  </Card>

  <Card title="Caching" icon="archive" href="/architecture/caching">
    Materializing aggregates.
  </Card>
</CardGroup>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.