---
title: Fetch from BigQuery
description: Retrieve data from Google BigQuery using custom SQL queries.
category: Data Integration
tags: [google, bigquery, sql, cloud, data]
---

# Fetch from BigQuery

## **Description**

The **Fetch From BigQuery** activity allows you to retrieve structured data by executing SQL queries on **Google BigQuery**, a serverless, highly scalable, and cost-effective cloud data warehouse.

This activity connects to your Google Cloud project, runs the specified query, and returns the results in tabular format. It is ideal for pulling real-time analytics, data transformations, or integrating cloud data into your workflow pipelines.

> **Use case**:  
> Fetch customer order data by region for the last quarter directly from BigQuery to feed a dashboard or analytics engine.

---

## **Input**

_Not Applicable_

---

## **Output**

| **Output Type** | **Format** | **Description**                            |
| --------------- | ---------- | ------------------------------------------ |
| Data            | Table      | Output of the executed BigQuery SQL query. |

---

## **Configuration Fields**

| **Field Name** | **Description**                                                             |
| -------------- | --------------------------------------------------------------------------- |
| **Connection** | Google BigQuery connection (OAuth or service account). Required for access. |
| **Project**    | Google Cloud Project ID containing the BigQuery datasets.                   |
| **Query**      | The SQL query string to be executed. Supports standard SQL syntax.          |

---

## **Sample Input**

_Not Applicable_

---

## **Sample Configuration**

| Field      | Value                                                                                                  |
| ---------- | ------------------------------------------------------------------------------------------------------ |
| Connection | `Google BigQuery OAuth`                                                                                |
| Project    | `customer-data-analytics`                                                                              |
| Query      | `SELECT region, COUNT(*) AS orders FROM orders_table WHERE order_date >= '2024-01-01' GROUP BY region` |

---

## **Sample Output**

| Region        | Orders |
| ------------- | ------ |
| North America | 15892  |
| Europe        | 10234  |
| APAC          | 7865   |

---