bigquery-isolated-e2e-runner

Runs isolated end-to-end tests validating BigQuery agents and Gemini Enterprise A2A deployments.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve? Manually verifying a full BigQuery agentic pipeline—data generation, conversational agents, verified golden queries, and Gemini Enterprise A2A bindings—is slow and error-prone, and leftover cloud resources create cost and hygiene risks. This Skill automates the entire validation cycle against an isolated local server and tracks every provisioned asset for cleanup. ## Core Features & Use Cases - Isolated E2E Execution: Spawns a temporary Node.js backend on an auto-allocated local port and runs the full five-stage pipeline (research, lakehouse generation, Bronze deployment, Conversational Agent creation, Gemini Enterprise A2A registration). - Verified Golden Queries: Generates and compiler dry-run validates three verified queries (ranking, time series, distribution) persisted to the BigQuery Data Agent's published and staging contexts. - Manifest Ledger & 1-Click Cleanup: Logs all created datasets, tables, and agents to a timestamped JSON manifest, with dry-run, single-run, or all-runs teardown of GCP resources. - Use Case: A data engineer validating a demo for a Brazilian telecom runs the runner with the company domain and project IDs, receives console links to the live Conversational Agent and Gemini Enterprise assistant, then deletes all provisioned assets with one cleanup command. ## Quick Start Run the isolated end-to-end test for company www.vivo.com.br against my BigQuery data project and Gemini Enterprise project, then clean up all provisioned resources afterward.

Frequently Asked Questions about bigquery-isolated-e2e-runner

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

FAQPage Schema
How do I run an end-to-end test of a BigQuery conversational agent pipeline?

Run scripts/run_e2e_local_isolated.py with --company, --data-project, and --ge-project flags. It launches an isolated local Node.js server on a temporary port and executes the full pipeline from research through Gemini Enterprise A2A agent registration.

How do I clean up Google Cloud resources created during E2E testing?

Run scripts/cleanup_e2e_run.py to delete assets from the latest run, pass --manifest for a specific run, --all for every recorded run, or --dry-run to preview deletions. All provisioned assets are tracked in a JSON manifest ledger under tests/e2e_runs/.

What does the BigQuery E2E test validate in each stage?

It validates five stages: enterprise research, medallion lakehouse generation with Property Graph DDL, Bronze table materialization, Conversational Agent creation with three compiler-validated golden queries, and Gemini Enterprise A2A agent binding with OAuth cloud-platform scope.

Can I keep the local test server running after the E2E test finishes?

Yes, pass the --keep-server flag to prevent automatic teardown of the local Node.js backend after test completion. This allows manual inspection of the API endpoints; otherwise the server process terminates automatically.

Does the E2E runner support languages other than Portuguese?

Yes, the --language flag controls the language used for agent instructions, prompts, and verified queries. Portuguese is the default, but you can specify another language when invoking the runner script.