Google BigQuery Integration

Poll-based trigger: run a SQL query on a schedule and emit NEW rows. BigQuery has no native webhooks, so this acts as a scheduled query: on each tick the user's SQL runs and only rows whose ``cursor_column`` is greater than the last-seen cursor are emitted. The cursor is persisted in ``last_cursor`` so already-seen rows are never re-emitted.

8 fields

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

6 fields

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

5 fields

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

2 fields

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

3 fields

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

4 fields

Request cancellation of a running job.

3 fields

Delete a job's metadata.

3 fields

List datasets in the project.

2 fields

Fetch dataset metadata.

2 fields

Create a new dataset.

5 fields

Full replace of dataset metadata (PUT).

3 fields

Partial update of dataset metadata (PATCH).

3 fields

Delete a dataset.

3 fields

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

3 fields

List tables/views in a dataset.

3 fields

Fetch table metadata/schema.

3 fields

Create a table or view with a schema.

5 fields

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

4 fields

Full replace of table metadata (PUT).

4 fields

Delete a table or view.

3 fields

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

5 fields

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

5 fields

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

3 fields

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

4 fields

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

4 fields

List stored procedures / UDFs / TVFs in a dataset.

2 fields

Fetch a routine definition.

3 fields

Create a stored procedure / UDF / TVF.

3 fields

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

4 fields

Delete a routine (routines.delete).

3 fields

List BigQuery ML models in a dataset.

2 fields

Fetch BQML model metadata.

3 fields

Delete a BQML model.

3 fields

Update mutable BQML model metadata (models.patch).

4 fields

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

1 field

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

1 field

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

4 fields

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

4 fields