> ## Documentation Index
> Fetch the complete documentation index at: https://docs.markifact.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Run Query

> Executes SQL queries on Google BigQuery datasets and returns query results

Executes SQL queries on Google BigQuery datasets and returns query results

|                      |                       |
| -------------------- | --------------------- |
| **App**              | BigQuery              |
| **Operation ID**     | `bigquery_run_query`  |
| **Type**             | Action                |
| **Connection**       | `bigquery` (required) |
| **Credits per run**  | 1                     |
| **Agent / MCP tool** | Yes                   |

## Inputs

| Field               | Type                 | Required | Default | Description                                                                                                    |
| ------------------- | -------------------- | -------- | ------- | -------------------------------------------------------------------------------------------------------------- |
| `project`           | string or SelectItem | Yes      | -       | Select the Google BigQuery project, ask the user for it if not provided                                        |
| `query`             | string               | Yes      | -       | Enter the SQL query to execute (e.g., SELECT \* FROM `project.dataset.table`)                                  |
| `enable_write_mode` | boolean              | No       | `False` | Allow queries that modify data (INSERT, UPDATE, DELETE, etc.). Use with caution to avoid accidental data loss. |

### SelectItem

| Field   | Type   | Required | Default | Description                                                                                          |
| ------- | ------ | -------- | ------- | ---------------------------------------------------------------------------------------------------- |
| `value` | string | Yes      | -       | The value of the selectable item.                                                                    |
| `label` | string | Yes      | -       | The label of the selectable item, used for display purposes. If not provided, defaults to the value. |

## Output

**Type**: `List[Dict]`

Returns query results as rows.

**Fields**: dynamic (depend on the inputs)