OpenAICodex

Connect Codex 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.

Tools Codex 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).

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.

About Codex

Codex is OpenAI's command-line coding agent. NoClick runs it as a hosted agent and lets you connect your apps to it as tools, turning it from a coding assistant into an operator that can act across your systems. Connect an integration to the agent and Codex can query, create, and update records in that app directly. You keep the Codex experience and give it real reach into the tools your team already uses.

Fast, capable code generation and editing
Good at well-scoped, concrete tasks
Strong at API and data manipulation
Familiar to teams already on OpenAI tooling

Frequently asked questions

Build a custom Codex agentGoogle BigQuery integration

Open your Codex agent in one click

NoClick runs Codex for you with Google BigQuery wired in as tools. Connect your account and run.