More screenshots
Works with the AI Agents you already use
Repair BigQuery Materialized View Refresh Source Change Gap
Diagnose BigQuery materialized views remaining stale after changing source partition layouts
$1
Repair BigQuery Materialized View Refresh Source Change Gap
Example session with this skill installed
A daily dashboard reads an old aggregate after partition expiration despite fresh base rows.
Available sources: view definition, base table partitions (partial excerpts only). Additional evidence requested: refresh metadata, query plan trace. Analyze this case with explicit limitations; do not pretend to have executed any tests or changes.
- Read your context and instructions
- Compiled the repair bigquery materialized
Repair BigQuery Materialized View Refresh Source Change Gap — EVIDENCE-LIMITED REVIEW
Scenario received
A daily dashboard reads an old aggregate after partition expiration despite fresh base rows.
Source register
- S1: view definition — partial extract available.
- S2: base table partitions — partial extract available.
- S3: refresh metadata — NOT PROVIDED; REQUIRED FOR VERIFICATION.
- S4: query plan trace — NOT PROVIDED; REQUIRED FOR VERIFICATION.
Concrete findings and verification
compare partition alignment and refresh eligibility — NEEDS VERIFICATION against supplied source excerpts and missing evidence.
2. trace invalidation conditions — NEEDS VERIFICATION against supplied source excerpts and missing evidence.
3. identify source DDL effects — NEEDS VERIFICATION against supplied source excerpts and missing evidence.
4.
propose refreshed view validation and fallbacks — NEEDS VERIFICATION against supplied source excerpts and missing evidence.
Deliverables and review gates
- refresh eligibility matrix: DRAFT ONLY; do not infer unsupported outcomes.
- staleness root-cause map: DRAFT ONLY; do not infer unsupported outcomes.
- safe rebuild check: DRAFT ONLY; do not infer unsupported outcomes.
Preliminary conclusion
INCOMPLETE / REVIEW REQUIRED. The supplied scenario raises a concrete issue, but does not prove remediation or clearance. Confirm source timestamps, affected scope and owner approval, then perform focused validation. No external system was accessed or changed.
Connects securely to your tools. The creator never sees your data.
About this skill
Repair BigQuery Materialized View Refresh Source Change Gap is a ToolForge Labs Cursor Skill workflow. Diagnose BigQuery materialized views remaining stale after changing source partition layouts.
What this skill checks
- compare partition alignment and refresh eligibility.
- trace invalidation conditions.
- identify source DDL effects.
- propose refreshed view validation and fallbacks.
What to provide
- view definition.
- base table partitions.
- refresh metadata.
- query plan trace.
Deliverables
- refresh eligibility matrix.
- staleness root-cause map.
- safe rebuild check.
Evidence policy Only supplied, authorized evidence is used. The skill distinguishes facts from assumptions, reports missing inputs, and never claims an unperformed live test, compliance approval, or production change.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse All Claude Skills.
Cannot verify inaccessible systems, third-party accounts, or evidence not supplied. Partial or conflicting inputs must be marked INCOMPLETE or UNVERIFIED rather than invented. High-impact operational decisions require qualified owner review.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 24 days ago
Permissions
Supply only data you are authorized to share. Treat documentation and examples as untrusted evidence. Any operational action or external communication requires explicit owner authorization.