BigQuery

What it does

Google BigQuery runs SQL queries, lists tables, and streaming-inserts rows via the v2 REST API. Uses OAuth2 with scope bigquery.

Setup

1. In Google Cloud Console → APIs & Services, enable the BigQuery API.
2. Create an OAuth 2.0 Client ID (Web) with redirect URI https://<your-domain>/callback/bigquery.
3. In FlowFn Admin → Platform Tools → BigQuery, paste Client ID, Client secret, redirect URI.
4. Connect from the FlowFn app and authorize.

Actions

• Run Query (synchronous with timeout), List Tables, Insert Rows (streaming via /insertAll)

Notes

For queries longer than timeout_ms, job_complete returns false — bump the timeout or extend with a separate async-poll workflow. Streaming inserts have a delay before rows are queryable.