effective-dbt-sql

对 dbt 模型 SQL 提供语义正确性与重构优先级的实践规则。

给 dbt 模型的 SQL 提供实用规则：什么时候复用已有字段、什么时候写子查询或重构为可复用的 dimension/metric，优先用 CTEs 而不是相关子查询，并要求显式的 join 和列清单。用在编写或修改 dbt 模型、重构指标或决定查询结构时。特点是把语义正确性和可维护性放在第一位，降低重复和意外破坏。

---
name: effective-dbt-sql
description: Use when writing or modifying dbt model SQL — deciding whether to add a subquery or reuse an existing dimension/metric, structuring a query, joining models, or refactoring a metric's SQL. Encodes SQL semantic-correctness rules: reuse existing fields, prefer CTEs over correlated subqueries, and make joins and column lists explicit.
---

# Effective dbt SQL

Write dbt model SQL that is correct, readable, and idiomatic. This skill is about the **semantics** of the SQL you write — not naming or formatting.

## Scope

**Use this when** you are about to write or change SQL inside a dbt model (`.sql`), or a metric/dimension whose value is defined by SQL.

**