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 Valuesetc.. , this activity can insert the cleaned results into a BigQuery table for analytics and reporting via tools like Looker Studio or Power BI.
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. |
| 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 |
