> For the complete documentation index, see [llms.txt](https://ciusji.gitbook.io/luden/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://ciusji.gitbook.io/luden/configuration/destinations-conf/google-bigquery.md).

# Google BigQuery

Luden supports [BigQuery](https://console.cloud.google.com/bigquery) as a destination. For more information about BigQuery [see docs](https://cloud.google.com/bigquery/docs). BigQuery destination can work in stream and batch modes. In stream mode Luden uses [BigQuery Streaming API](https://cloud.google.com/bigquery/streaming-data-into-bigquery). In batch mode Luden writes incoming events in formatted file on the Google Cloud Storage and creates a [loading job](https://cloud.google.com/bigquery/docs/loading-data) to store data from GCP files into BigQuery.

## Configuration

BigQuery destination config consists of the following schema:

```
destinations:
  my_bigquery:
    type: bigquery
    google:
      gcs_bucket: google_cloud_storage_bucket
      bq_project: big_query_project
      bq_dataset: big_query_dataset
      key_file: path_to_bqkey.json # or json string of key e.g. "{"service_account":...}"
```

<br>