bigquery-pipeline-audit
Audits Python + BigQuery pipelines for cost safety, idempotency, and production readiness with exact patch locations.
What it does
- Is this inside a loop, retry block, or async gather?
- What is the realistic worst-case call count?
- For each client.query, is QueryJobConfig.maximumbytesbilled set?
- Is the same SQL and params being executed more than once in a single run?
- Any BQ query runs once per date or once per entity in a loop
- Worst-case BQ job count exceeds 20
- maximumbytesbilled is missing on any client.query call
Requirements & configuration
- execute requires explicit confirmation for prod (--env=prod --confirm)
Configuration: GENERATE_DATE_ARRAYMAX_CHUNKSDATECASTSELECTREGEXPJSON_EXTRACTINSERT
Derived from the skill's own SKILL.md documentation · extracted 2026-07-23
Audits Python + BigQuery pipelines for cost safety, idempotency, and production readiness with exact patch locations.
Source
Repository: https://github.com/github/awesome-copilot
bigquery-pipeline-audit FAQ
What does the bigquery-pipeline-audit skill do?
Audits Python + BigQuery pipelines for cost safety, idempotency, and production readiness. Returns a structured report with exact patch locations. Is this inside a loop, retry block, or async gather? What is the realistic worst-case call count?
What does bigquery-pipeline-audit require?
execute requires explicit confirmation for prod (--env=prod --confirm) Configuration keys: GENERATE_DATE_ARRAY, MAX_CHUNKS, DATE, CAST, SELECT, REGEXP, JSON_EXTRACT, INSERT.
How do I install bigquery-pipeline-audit?
Run: npx -y skills add https://github.com/github/awesome-copilot --skill bigquery-pipeline-audit --agent claude-code — the source lives at github.com/github/awesome-copilot.
Maintain bigquery-pipeline-audit?
Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.
[](https://getagentictools.com/skills/github-awesome-copilot-bigquery-pipeline-audit?ref=badge) npx agentictools info skills/github-awesome-copilot-bigquery-pipeline-audit The second line is the CLI lookup for this page — handy in READMEs and docs.