Integration guideAPI integration

Google BigQuery

Set up per project on the vendor’s API: query operational datasets and turn the results into referenced charts and reports.

Illustration of a seal beside a benchtop bioreactor and a laptop displaying culture trends.

Review quality trends. Use the permitted Google BigQuery records and show me the supporting evidence.

Neil

Once the API connection is configured, I’ll query defined populations and chart rates with their denominators visible.

Tables and query results in the projects and datasets allowed by your IAM configuration.

What you get

Review quality trends

  • Findings linked to source records
  • Missing evidence and unresolved questions
  • Follow-up work for your team
Illustrative work with Google BigQuery: a request to Neil, the source it reads and what it returns.

1What’s connected.

Query operational datasets and turn the results into referenced charts and reports. Scope an API integration so Neil can use the permitted records to prepare analysis, reports and follow-up work.

Connection setup and permissions

Use the BigQuery REST API with a scoped service identity. Set query, cost and data-access limits, and record the dataset and query used.

We scope this connection against the provider’s documented interface for your environment. Start with read access; any source-system changes need separately configured actions and controls.

2Start with the job.

Records in scope: Tables and query results in the projects and datasets allowed by your IAM configuration. Tell us the job, and we’ll confirm the interface, permissions and implementation scope with your team.

Discuss this connection →

3What Neil can do with Google BigQuery once connected

Once the relevant API access and data mappings are configured:

Review quality trends
Query defined populations and chart rates with their denominators visible.
Reconcile operational data
Compare selected material or batch datasets and report unmatched records.
Write a performance brief
Bring query results and supplied operational context into a reviewable report.

4Connection questions

Will this work with our Google BigQuery environment?

We check your product edition, API availability, authentication and permitted records against the job you want Neil to do. The linked provider documentation describes the interface; Seal does not yet have a guided connector for it.

5Before it goes live.

Access and any write-back

Define which records are in scope and whose permissions apply. Whether the connection writes back at all is a separate decision, with its own mapping and approval.

Data and failure handling

Agree the field mapping, identifiers, units and source of record. Test missing or duplicate data, interrupted transfers and recovery before relying on the connection.

Verification and release

Review the configured connection for its intended use. Keep the requirements, checks and evidence with the change, and approve the release through your team’s controls.

Read the assurance detail →