Does this skill support incremental table debugging?

Absolutely. It offers patterns to verify incremental conditions, check snapshot dates, and provides guidance on when to safely perform a full refresh.

What kind of data quality issues can it detect?

The skill includes SQL snippets to diagnose join mismatches caused by case sensitivity, duplicate rows from many-to-many joins, and unexpected NULL values in metrics.

How does this skill help with Dataform compile errors?

It provides specific diagnostic commands and solutions for common issues like circular dependencies, missing table references, and variable resolution errors in workflow_settings.yaml.

Can it help with BigQuery authentication issues?

Yes, it includes quick fixes for insufficient scopes, quota project settings, and service account credential problems using gcloud CLI commands.

Dataform & BigQuery Debugging

Name: Dataform & BigQuery Debugging
Author: Expanly

byExpanly

0•

Database Management

Troubleshoots Dataform workflows and BigQuery environments to resolve compilation, authentication, and data quality issues.

This skill provides a comprehensive troubleshooting framework for developers working with Dataform and BigQuery, specifically tailored for scoring models and complex SQL pipelines. It offers diagnostic checklists for Google Cloud authentication, Dataform compilation errors, and BigQuery runtime exceptions. Beyond simple error fixing, it includes sophisticated patterns for validating data quality, investigating join mismatches, and managing incremental table updates, ensuring data integrity across large-scale analytics environments within the Claude Code interface.

Key Features

01Specialized debugging for scoring rules and percentile-based calculations

02In-depth troubleshooting for Dataform compile errors and circular dependencies

03Logic verification for incremental table updates and full-refresh triggers

040 GitHub stars

05Diagnostic checklists for GCloud authentication and project configuration

06SQL patterns for identifying data quality issues, duplicates, and join mismatches

Use Cases

01Fixing broken Dataform dependency graphs and SQL syntax errors during compilation

02Resolving authentication scopes and project credential errors in GCP environments

03Investigating source-to-target data loss and investigating join-key normalization issues

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add expanly/expanly-claude-code-agents dataform-debugging

For use in Claude.ai and ChatGPT

Download Skill