dataform-engineering-fundamentals

What problem does it solve?

This Skill prevents common Dataform development pitfalls, ensuring robust, maintainable, and safe data transformation pipelines, even under pressure.

Core Features & Use Cases

• TDD Enforcement: Guarantees tests are written before implementation for Dataform SQLX files.
• Safety Practices: Mandates --schema-suffix dev and --dry-run for all development.
• Dependency Management: Enforces the use of ${ref()} over hardcoded table paths.
• Documentation Standards: Requires comprehensive columns: {} documentation for all tables.
• Architecture Patterns: Promotes layered structures and proper use of incremental vs. full refresh.
• Use Case: When tasked with creating a new data mart table under a tight deadline, this Skill ensures you write assertions first, use safe development commands, and document columns properly, preventing costly production errors and technical debt.

Quick Start

Use the dataform-engineering-fundamentals skill to develop BigQuery Dataform transformations, ensuring TDD, safety practices, and proper documentation.