---
title: Insert to BigQuery
description: Insert data into a specified Google BigQuery table within your workflow.
category: Applications
tags: [google bigquery, bigquery insert, gcp, data warehouse, integration]
---

# Insert to BigQuery

## Description

The **Insert to BigQuery** activity allows you to insert structured data into a specified table within a Google BigQuery dataset.

This activity is typically used to store processed or cleaned data for further querying, analytics, or archival in BigQuery—a highly scalable, serverless data warehouse by Google Cloud.

Use this activity to:

- Insert transformed data into BigQuery tables
- Store data for BI dashboards or long-term analytics
- Build a pipeline that automatically sends data to the warehouse after processing

> **Use case**:  
> After transforming product and sales data using `DataTransforms` like `Group Longtail Values`etc.. , this activity can insert the cleaned results into a BigQuery table for analytics and reporting via tools like Looker Studio or Power BI.

## Input

| **Type** | **Required** |
| -------- | ------------ |
| Value1   | Yes          |

## Output

| Output Type | Format | Description                                                          |
| ----------- | ------ | -------------------------------------------------------------------- |
| **Data**    | Table  | A reflection of the inserted data for verification or downstream use |

## Configuration Fields

| Field Name     | Description                                                            |
| -------------- | ---------------------------------------------------------------------- |
| **Connection** | Select a Google BigQuery connection. Required for authentication.      |
| **Project**    | Google Cloud project ID where the dataset resides.                     |
| **Dataset**    | The BigQuery dataset to insert data into.                              |
| **Table**      | The BigQuery table within the dataset where the data will be inserted. |

## Sample Input

| customer_id | customer_name | region     | total_spent |
| ----------- | ------------- | ---------- | ----------- |
| C001        | Alice         | North-East | 5400        |
| C002        | Bob           | West       | 3200        |

## Sample Configuration

| Field           | Value                     |
| --------------- | ------------------------- |
| `connection.id` | `google-bigquery-conn`    |
| `project`       | `sales-analytics-project` |
| `dataset`       | `customer_insights`       |
| `table`         | `monthly_sales_summary`   |

## Sample Output

| customer_id | customer_name | region     | total_spent |
| ----------- | ------------- | ---------- | ----------- |
| C001        | Alice         | North-East | 5400        |
| C002        | Bob           | West       | 3200        |