MIDA / DATA CONNECTIONS
BigQuery
Build reporting from an approved set of tables or views.
How the connection can work
Review the schema and reporting requirements, then configure a private, read-only extraction path in the agreed project environment.
Access requirements
A database owner provisions restricted access and a suitable network path. Do not submit connection passwords through the public consultation form.
BEFORE A CONNECTION GOES LIVE
- Document the grain and joins before querying.
- Test query cost and source-system impact.
- Define access boundaries and an incremental update strategy.
From access to a checked report
Assess
Confirm the account, reporting question, data coverage and approved access.
Map
Define identifiers, statuses, dates and calculation rules for the report.
Verify
Reconcile records and totals before establishing a recurring update.