搜索技能.../

Dbt Best Practices | Skills Pool

技能档案

Dbt Best Practices

dbt data modeling best practices following Kimball/dimensional modeling. Use when writing or reviewing dbt models, adding tests, choosing materializations, or following SQL/YAML/Jinja style conventions. Covers architecture layers, naming conventions, testing strategy, SQL style, and BigQuery optimization.

acrulopez0 星标2026年3月4日

职业
分类: 数据工程

技能内容

Approach: Kimball / dimensional modeling (star schema).

Creating New Models

Step 1: Decide what to build

Read Architecture to determine:

Which models to create (layer, prefix, naming convention)
What each model queries (flow rules)
Where to place files (folder structure)

Step 2: Write the `.sql` and `.yml` files

Read these three references, then create the files:

General Rules — key rules, BigQuery optimization, testing by column pattern, severity, useful packages
Naming & Style — column naming conventions, SQL/YAML/Jinja style

相关技能

快速安装

Dbt Best Practices

npx skills add acrulopez/dotfiles

下载 Skill 打开源码仓库

作者: acrulopez
星标: 0
更新时间: 2026年3月4日
职业

本页内容

01Creating New Models

The corresponding layer file:

Model prefix	Layer file
`seed_`, `raw_`	Raw
`snp_`, `stg_`	Staging
`int_`	Intermediate
`dim_`, `fct_`, `brg_`, `mart_`, `agg_`, `rpt_`, `util_`	Datamart

Editing Existing Models

Identify the layer from the model's prefix, then read:

General Rules
Naming & Style
The corresponding layer file (see table above)

02

Step 1: Decide what to build

03Step 2: Write the .sql and .yml files

04Editing Existing Models

数据科学家

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

Clickhouse Io

고성능 분석 워크로드를 위한 ClickHouse 데이터베이스 패턴, 쿼리 최적화, 분석 및 데이터 엔지니어링 모범 사례.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.

Claude Devfleet

通过Claude DevFleet协调多智能体编码任务——规划项目、在隔离的工作树中并行调度智能体、监控进度并读取结构化报告。

Ai First Engineering

团队中人工智能代理生成大部分实施输出的工程运营模型。

数据科学家