Can NoClick run a SQL query in BigQuery and use the results?

Yes. The node submits your query as a job with Insert Job and reads the output with Get Query Results, so a workflow can run SQL and hand the rows to the next step. You can also check progress with Get Job or stop a running query with Cancel Job.

How do I connect BigQuery to NoClick?

You authorize the node with your Google account, and it calls the BigQuery REST API for your Google Cloud project. From there it can reach your datasets, tables, jobs, and routines. It can also return the project's BigQuery service account with Get Service Account when you need it for permissions.

Can a workflow react to a scheduled query in BigQuery?

Yes. The On Scheduled Query Results trigger starts a workflow when a scheduled query produces results, so fresh data can flow into Slack, a spreadsheet, or another system without polling. Pair it with Get Query Results to read the exact rows the query returned.

Can it create and delete datasets and tables?

It creates datasets and tables, reads their metadata with Get Dataset and Get Table, lists datasets, and deletes datasets and tables when you need to tear them down. That makes it easy to stand up scratch tables for a pipeline and clean them up when the run finishes.

Does the node handle routines and models?

Yes. It manages routines with Create Routine, Get Routine, and Delete Routine, and it can read a model with Get Model or remove one with Delete Model. For governance, it also inspects a table's IAM policy and row access policy so you can audit who can see what.

How does OpenClaw act on my apps?

You connect an integration to the agent's tools handle and select operations. OpenClaw calls those operations as tools while it runs.

Is there anything to install?

No. NoClick runs the OpenClaw harness for you in a hosted sandbox.

Can I run it on a schedule?

Yes. A hosted agent can be started from a schedule, a webhook, or another app event.

Which apps can it use?

Any of NoClick’s tool-provider integrations across communication, CRM, developer tools, databases, and more.

Connect OpenClaw to Google BigQuery

Give an AI agent your BigQuery as a tool and it can query the warehouse itself instead of asking you to. It submits SQL jobs, reads the query results, creates tables and datasets, and checks or cancels job status on its own, calling each operation as a tool while it works through a task. Wire it into a coding agent in NoClick and it can investigate data, build a table, and load results without a human running each query.

Loading preview…

Opens a workflow with 38 tools ready to use.

What happens next

Set up in minutes

The open button drops you into a guided setup. It asks exactly this, nothing else:

Choose where it runs
On your computer through your own OpenClaw, or hosted in the cloud. The rest of setup adapts to your choice:
Pick what it can do in Google BigQuery
A preset of real Google BigQuery operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.
Connect Google BigQuery
One sign-in. The agent acts through your account, scoped to the operations you picked.
Add your personal MCP link
The last step mints a private MCP URL for this agent and walks you through exactly this, with your real link filled in. The page flips to Connected the moment your OpenClaw first calls in.
Run this in your terminal
$openclaw mcp add noclick --url https://mcp.noclick.app/s/<your-link>
<your-link> is your personal server URL — setup mints it for you.

Exact capabilities

Tools OpenClaw gets

Pick the operations you want and each becomes a tool the agent can call directly while it works.

Google BigQuery

38 tools

Run Query

Run a SQL query and return results inline (synchronous, bounded by timeout).

Get Query Results

Page through the results of a (possibly async) query job.

Insert Job

Start a query / load / extract / copy job (async).

Get Job

Fetch a job's status and statistics (poll until DONE).

List Jobs

List jobs in a project (filter by state, time range).

Cancel Job

Request cancellation of a running job.

Delete Job

Delete a job's metadata.

List Datasets

List datasets in the project.

Get Dataset

Fetch dataset metadata.

Create Dataset

Create a new dataset.

Update Dataset

Full replace of dataset metadata (PUT).

Patch Dataset

Partial update of dataset metadata (PATCH).

Delete Dataset

Delete a dataset.

List Tables

List tables/views in a dataset.

Get Table

Fetch table metadata/schema.

Create Table

Create a table or view with a schema.

Patch Table

Partial update of a table (add columns, set expiration, etc.).

Update Table

Full replace of table metadata (PUT).

Delete Table

Delete a table or view.

Stream Insert Rows

Streaming insert of JSON rows into a table (real-time append).

List Table Data

Read rows from a table directly (paginated, no SQL).

List Routines

List stored procedures / UDFs / TVFs in a dataset.

Get Routine

Fetch a routine definition.

Create Routine

Create a stored procedure / UDF / TVF.

List Models

List BigQuery ML models in a dataset.

Get Model

Fetch BQML model metadata.

Delete Model

Delete a BQML model.

Get Service Account

Return the BigQuery service account for the project (KMS/transfer grants).

List Projects

List projects the caller can access (for project picker UIs).

Undelete Dataset

Restore a dataset within its time-travel window (datasets.undelete).

Update Routine

Replace a routine's full definition (routines.update, PUT).

Delete Routine

Delete a routine (routines.delete).

Patch Model

Update mutable BQML model metadata (models.patch).

Get Table IAM Policy

Get the IAM policy for a table (tables.getIamPolicy).

Set Table IAM Policy

Set the IAM policy for a table (tables.setIamPolicy).

Test Table IAM Permissions

Test the caller's permissions on a table (tables.testIamPermissions).

List Row Access Policies

List row access policies on a table (rowAccessPolicies.list).

Get Row Access Policy

Get a single row access policy (rowAccessPolicies.get).

Starting points

What you can build

When a scheduled query finishes, take its results and post a summary to your team channel automatically.

Run a SQL job on a schedule, wait for it to complete, then read the query results into the next step for reporting.

Spin up a fresh dataset and tables at the start of a pipeline, then delete the dataset once the run is done.

Let an AI step turn a plain-English request into SQL, submit it as a job, and return the answer from the results.

Cancel a long-running BigQuery job automatically when a workflow detects it has been running past its budget.

Before a nightly load, check a table's metadata and IAM policy so the workflow only writes when the schema and permissions match what you expect.

Meet the runner

About OpenClaw

OpenClaw is an open command-line agent. NoClick runs it hosted and lets you connect your apps to it as tools, so it can take real actions across your systems. Wire an integration into the agent and OpenClaw can call that app’s operations directly. It is a good fit when you want an open, no-fuss agent with real tool access and nothing to install.

Open and approachable

Simple to point at a task

Solid general tool use

Hosted, with nothing to install

Good to know