BigQuery

Comprehensive guide to the BigQuery node in StackAI: actions, inputs, configurations, outputs, and usage examples for seamless Google BigQuery integration.

What is BigQuery?

BigQuery is a fully managed, serverless data warehouse by Google Cloud that enables super-fast SQL queries using the processing power of Google's infrastructure. In StackAI workflows, the BigQuery node allows you to connect, query, and interact with your Google BigQuery datasets directly from your automated flows.

---

How to Use the BigQuery Node

The BigQuery node in StackAI is designed to execute SQL queries on your Google BigQuery database. It can be used to retrieve, analyze, and process large datasets as part of your workflow automation. You can connect this node to other nodes to automate data-driven tasks, reporting, or trigger downstream actions based on query results.

---

Example of Usage

Suppose you want to retrieve sales data for the last month from your BigQuery database and use it in a report. You would configure the BigQuery node with your SQL query, connect your Google Cloud credentials, and pass the results to a reporting or output node.

---

Available Actions for BigQuery

1. Database Query (BigQuery)

Description: Run a SQL query against your Google BigQuery database and retrieve the results for use in your workflow.

Inputs

Input Name	Description	Required	Example
query	The SQL query to execute on your BigQuery database.	Yes	SELECT * FROM sales WHERE date > '2025-06-01'
parameters	Optional parameters for parameterized queries.	No	{"region": "US"}

Showing 1-2 of 2 items

Configurations

Configuration Name	Description	Required	Example
connection_id	The ID of your Google BigQuery connection (credentials).	Yes	bq-connection-12345
project_id	The Google Cloud project ID where your BigQuery dataset resides.	Yes	my-gcp-project
dataset_id	The BigQuery dataset ID to query.	Yes	sales_data
location	The location of your BigQuery dataset (e.g., ,US,, ,EU,).	No	US

Showing 1-4 of 4 items

Outputs

Output Name	Description	Required	Example
results	The rows returned by your SQL query, as a list of records.	Yes	[{"date": "2025-06-01", "total": 1000}, ...]
row_count	The number of rows returned by the query.	Yes	100
schema	The schema of the returned data (column names and types).	Yes	[{"name": "date", "type": "DATE"}, ...]

Showing 1-3 of 3 items

---

Example Configuration

{
  "action_id": "database_query_bigquery",
  "action_configurations": {
    "connection_id": "bq-connection-12345",
    "project_id": "my-gcp-project",
    "dataset_id": "sales_data",
    "location": "US"
  },
  "action_input_parameters": {
    "query": "SELECT * FROM sales WHERE date > '2025-06-01'",
    "parameters": {}
  }
}