Connect Codex to Google BigQuery

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

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

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

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

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

Request cancellation of a running job.

Delete a job's metadata.

List datasets in the project.

Fetch dataset metadata.

Create a new dataset.

Full replace of dataset metadata (PUT).

Partial update of dataset metadata (PATCH).

Delete a dataset.

List tables/views in a dataset.

Fetch table metadata/schema.

Create a table or view with a schema.

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

Full replace of table metadata (PUT).

Delete a table or view.

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

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

List stored procedures / UDFs / TVFs in a dataset.

Fetch a routine definition.

Create a stored procedure / UDF / TVF.

List BigQuery ML models in a dataset.

Fetch BQML model metadata.

Delete a BQML model.

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

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

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

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

Delete a routine (routines.delete).

Update mutable BQML model metadata (models.patch).

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

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

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

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

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