bigquery-pipeline-audit

スキルの内容

A review prompt packaged as a skill in GitHub's awesome-copilot collection. It has the agent audit a Python pipeline that uses BigQuery and report in six parts: where billed jobs are triggered and whether a bytes-billed limit is set, whether dry-run and execute modes exist, how backfills loop over dates, whether queries prune partitions and avoid SELECT star and exploding joins, whether writes are idempotent through MERGE or staging tables, and whether failures and job statistics are logged. It ends with a pass or fail verdict, a patch list ordered by risk and worst-case cost estimates. It reads code only and does not connect to BigQuery.

できること

詳細