What problem does it solve? Building Dataform pipelines for BigQuery requires precise SQLX syntax, correct incremental configurations, and valid DAG dependencies, and mistakes lead to failed compiles or broken production pipelines. This Skill guides the creation, modification, and validation of Dataform projects so pipelines compile cleanly and follow BigQuery best practices. ## Core Features & Use Cases - Pipeline Generation: Creates SQLX actions, source declarations, incremental tables, and GCS ingestion operations with proper configuration blocks. - Validation Workflow: Runs dataform compile, dry-run executions, and bq query checks to catch syntax and dependency errors before deployment. - Automatic Optimization: Applies data cleaning protocols and SQL optimizations like column pruning and predicate filtering on every pipeline. - Use Case: When asked to ingest CSV files from GCS into an existing BigQuery table, it creates an external table declaration, an incremental SQLX action matching the target schema, and validates the result with a dry run. ## Quick Start Ask the assistant to create a Dataform pipeline that loads data from a GCS bucket into a BigQuery table using incremental updates.
