bigquery-predeploy-e2e-gate

Runs a 4-tier verification gate covering TDD tests, local E2E pipeline, git safety, and Cloud Run deployment.

Updated Jul 7, 2026
One-click install
npx skills add https://github.com/ricardolui/gcp-custom-agent-skills --skill bigquery-predeploy-e2e-gate-ricardolui
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: bigquery-predeploy-e2e-gate
Source: https://github.com/ricardolui/gcp-custom-agent-skills/tree/main/bigquery-predeploy-e2e-gate
Command: npx skills add https://github.com/ricardolui/gcp-custom-agent-skills --skill bigquery-predeploy-e2e-gate-ricardolui

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve? Deploying BigQuery agentic applications to Cloud Run without verification risks shipping broken conversational agents, missing table schemas, and unverified queries to production. This Skill enforces a mandatory 4-tier quality gate that blocks commits and deployments until all checks pass. ## Core Features & Use Cases - Tiered Verification Pipeline: Runs TDD unit tests for property graph DDL and A2A agent protocols, then an isolated local server E2E pipeline covering research, Medallion data generation, BigQuery deployment, verified query registration, and Gemini Enterprise A2A registration. - Git Safety & Automated Commit: Validates the working tree and automatically stages and commits changes when a commit message is provided. - Cloud Run Deployment with Smoke Checks: Builds and deploys the container to Cloud Run (bq-agents-v2 in us-central1) and runs a live smoke test against the deployed revision. - Use Case: Before merging a feature branch that adds a new reverse ETL continuous query, run the gate with a commit message to validate all tiers and deploy safely in one command. ## Quick Start Run the deployment gate with a commit message, for example: python3 scripts/deploy_with_e2e_gate.py --commit-msg "feat: add new verified query", or use --skip-deploy to validate without deploying.

Frequently Asked Questions about bigquery-predeploy-e2e-gate

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run pre-deployment E2E tests before deploying to Cloud Run?

Run python3 scripts/deploy_with_e2e_gate.py with a commit message to execute all four tiers and deploy. Use the --skip-deploy flag to run only the TDD and local E2E validation tiers without triggering a Cloud Run build.

How do I validate changes locally without deploying to production?

Use the --skip-deploy flag to run Tiers 1 through 3 only, covering TDD unit tests, the isolated local server E2E pipeline, and git commit safety. This is recommended before opening pull requests or committing large refactors.

What does the isolated local E2E pipeline test?

It launches a temporary Node.js backend on a dynamic local port and tests real Google Cloud interactions: research generation, Medallion Lakehouse data creation, BigQuery dataset deployment, verified golden query registration, and Gemini Enterprise A2A agent registration, then cleans up test assets.

Can I skip the E2E tests for an emergency hotfix?

Yes, the --skip-e2e flag bypasses the local server E2E test, but it is intended only for emergency hotfixes. The documentation warns against deploying directly with gcloud run deploy without running the pre-deploy gate.

Where do I find logs when the E2E stage fails?

Inspect tests/e2e_runs/latest_run.json when any stage in Tier 2 returns unexpected responses. The pipeline aborts immediately on failure, so this file contains the most recent run details for debugging.