AgentSkillsCN

Edit Models

编辑模型

SKILL.md

Edit Models

Skill for configuring dbt models as Lightdash tables/explores using dbt 1.10+ and Fusion standards.

Purpose

Enables the configuration of entity-level metadata, joins, and explores in dbt YAML.

Behavior

  1. •Model Registration: Documentation in dbt YAML is required for model visibility.
  2. •dbt 1.10+ Configuration: Use the config.meta block.
  3. •Relationship Mapping: Define primary_key and joins with correct relationships.
  4. •Reference Consultation: ALWAYS check references/basics.md and references/advanced.md for syntax patterns.

References

  • •Basics: Table labels, primary keys, and visibility.
  • •Advanced: Joins, relationships, and custom explores.
  • •Best Practices: Wide, flat tables and materialization.
  • •SQL Templating: Using ${field} and user attributes.

Rules

  • •ALWAYS define a primary_key for every model.
  • •Prefer wide, flat tables (Wide Table Pattern).
  • •Refer to read-models to verify existing joins and structure before modification.