CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

dataform-bigquery

Expertise in generating clean, correct, and efficient Dataform pipeline code for BigQuery ELT. Use this when creating or modifying Dataform pipelines, actions, or source declarations, when Dataform, SQLX, or BigQuery are mentioned in a transformation, when data needs to be ingested from GCS into BigQuery via Dataform, or when setting up a new Dataform project or configuring workflow_settings.yaml.

Quality

84%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

70%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A highly actionable, well-sequenced workflow guide with genuine Dataform-specific rules (incremental vs. operations, declaration configs, dry-run error triage) and strong validation feedback loops. Its main weaknesses are redundancy (duplicated credentials/execution-rule content, persona filler), a couple of missing executable examples for GCS ingestion and incremental models, and a monolithic single-file structure that inlines content suited to reference files.

Suggestions

Consolidate the standalone "Credentials for dataform run and dataform run --dry-run" section into Step 1/Step 6 and state the real-run execution rule once, removing the two repeated restatements (conciseness).

Add complete SQLX code examples for the two underspecified flows: an external-table creation for GCS ingestion and a minimal type: "incremental" model with its SELECT-only body and ${ref(...)} usage (actionability).

Move deep-dive material — BigLake Iceberg 4-part naming, the incremental operations rules table, and coding standards — into reference files linked from the body, keeping SKILL.md as the workflow overview (progressive_disclosure).

DimensionReasoningScore

Conciseness

The body is mostly dense, imperative, Dataform-specific guidance, but the standalone "Credentials for dataform run" section restates Step 1 and Step 6 content, the real-run prohibition ("MUST NOT execute a real dataform run") appears three times, and the "Role & Persona" section is generic agent filler. This lands on anchor 3 (mostly efficient but could be tightened) rather than 4 because the duplicated credentials section is more than a minor trim.

3 / 5

Actionability

Provides copy-paste commands throughout ("dataform init my-repo my-gcp-project us-central1", "bq ls --project_id=<PROJECT_ID>", "npm i -g @dataform/cli"), concrete SQLX declaration config blocks, a JSON credentials template, and a specific CSV options table (allow_jagged_rows, allow_quoted_newlines, ignore_unknown_values). Not 5 because GCS ingestion ("Create an external table in a SQLX operations file. Use rawData from schema detection") and incremental models are given rules/prose but no complete executable SQLX example.

4 / 5

Workflow Clarity

Steps 0–7 are clearly sequenced with explicit validation checkpoints (dataform compile, dataform run --dry-run, bq query --dry_run fallback), a nuanced error-triage rule for dry-run failures (ignorable "Table not found" vs. errors that MUST be addressed), and iterate/fix feedback loops ("Fix all validation errors and repeat until the request is satisfied"). This matches the anchor for clear sequence with explicit validation, error recovery, and feedback loops.

5 / 5

Progressive Disclosure

Section headers are clear and the @skill: cross-references (data-autocleaning, developing-with-bigquery, discovering-gcp-data-assets) are clearly signaled and one level deep, but all ~290 lines live in a single file with no reference layer — deep-dives like "BigLake Iceberg Support (4-Part Naming)", the incremental operations rules table, and coding standards are inline candidates for separate reference files. This matches anchor 3 (some structure, content that should be separate is inline) better than 4.

3 / 5

Total

15

/

20

Passed

Description

91%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong description: it states a clear capability, provides an explicit multi-trigger "Use when" clause, and uses the domain's natural terminology including the key config filename. Its only weaknesses are the adjective-laden capability phrase and a slightly over-broad BigQuery trigger that could collide with a general BigQuery skill.

DimensionReasoningScore

Specificity

Explicitly enumerates several concrete activities — "creating or modifying Dataform pipelines, actions, or source declarations", "ingested from GCS into BigQuery", "setting up a new Dataform project or configuring workflow_settings.yaml" — matching the anchor for several specific actions with minor gaps. Not 5 because the core capability statement rests on one action ("generating... Dataform pipeline code") padded with adjectives ("clean, correct, and efficient") rather than additional distinct capabilities.

4 / 5

Completeness

Clearly answers "what" ("generating clean, correct, and efficient Dataform pipeline code for BigQuery ELT") and "when" with an explicit "Use this when..." clause containing multiple concrete trigger phrases (pipeline creation/modification, Dataform/SQLX/BigQuery mentions in a transformation, GCS ingestion, project setup). This mirrors the anchor-5 example structure; the "when" is fully explicit, so 4 does not fit.

5 / 5

Trigger Term Quality

Covers the natural vocabulary of this domain comprehensively: "Dataform", "SQLX", "BigQuery", "GCS", "ELT", "transformation", and the config filename "workflow_settings.yaml". These are exactly the terms a user with this need would say; no common synonym or variation is missing, matching the comprehensive anchor.

5 / 5

Distinctiveness Conflict Risk

Dataform/SQLX/workflow_settings.yaml triggers establish a clear niche, but the trigger "when... BigQuery are mentioned in a transformation" would also fire for general BigQuery transformation questions, creating minor overlap with a closely related BigQuery skill (the body itself defers to @skill:developing-with-bigquery). Mostly distinct with minor overlap risk matches anchor 4 rather than 5.

4 / 5

Total

18

/

20

Passed

Validation

100%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository

saski/arnesto

Path

.agents/skills/dataform-bigquery/SKILL.md

Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.