# Google BigQuery

Friends offers seamless integration with Google Cloud's [BigQuery](https://cloud.google.com/bigquery) service, enabling you to effortlessly connect data flows between your systems and BigQuery.

Frends has tasks for performing all core BigQuery operations.

## Use cases

Below you will find typical use cases for BigQuery integrations and how they are implemented in Frends.

## Insert data into BigQuery table

By using the file trigger and the [Insert](https://github.com/FrendsPlatform/FrendsDocs/blob/FrendsDocs/FrendsTasks/tasks/google-bigquery/insert/.md/README.md) task, we can create an integration that listens for incoming CSV files and inserts the data into the appropriate table.

<figure><img src="https://2096450325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FevBo49UTUjEN84O2WPl6%2Fuploads%2Fgit-blob-3f9ca75d9d12e946a2168c96008af56002348f4e%2Finsert.svg?alt=media" alt=""><figcaption><p>Insert CSV data to BigQuery table</p></figcaption></figure>

## Get data from BigQuery and save as CSV

By using the [ExecuteQuery](https://github.com/FrendsPlatform/FrendsDocs/blob/FrendsDocs/FrendsTasks/tasks/google-bigquery/executequery/.md/README.md) task, we can create an integration that retrieves data from a BigQuery and generates CSV exports for further processing.

<figure><img src="https://2096450325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FevBo49UTUjEN84O2WPl6%2Fuploads%2Fgit-blob-c062df604204b0fba55532cf4d6664f995582f7b%2Fexecute-query.svg?alt=media" alt=""><figcaption><p>Save BigQuery data as CSV</p></figcaption></figure>