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 |