Google BigQuery

Google BigQuery is a fast, scalable, and serverless cloud data warehouse for analytics and insights.

Friends offers seamless integration with Google Cloud's 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 task, we can create an integration that listens for incoming CSV files and inserts the data into the appropriate table.

Insert CSV data to BigQuery table

Get data from BigQuery and save as CSV

By using the ExecuteQuery task, we can create an integration that retrieves data from a BigQuery and generates CSV exports for further processing.

Save BigQuery data as CSV