bigquery▌

Audits Python + BigQuery pipelines for cost safety, idempotency, and production readiness with exact patch locations. \n \n Analyzes every BigQuery job trigger and external API call to identify cost exposure, loop-driven query multiplication, and missing maximum_bytes_billed limits \n Enforces dry-run and execute modes with explicit prod confirmation, partition filter validation, and scan-size optimization \n Validates idempotent writes using MERGE, staging tables, or dedup logic; flags unsafe a

Design and deploy analytics dashboards connecting BigQuery data to Looker Studio visualizations. \n \n Supports native BigQuery connector with custom SQL queries, scheduled queries for performance optimization, and multi-table joins for complex data transformations \n Includes F-pattern dashboard layout guidance with KPI tiles, trend charts, comparison visualizations, and interactive filters for user-driven exploration \n Provides performance optimization strategies using partition keys, data ex