dbt-strategy

Name: dbt-strategy
Rating: 5 (7 reviews)
Author: yeaight7

Use when creating or modifying dimensional dbt models in warehouse-backed analytics projects. Covers a four-layer warehouse architecture (sources/staging/core/marts), naming conventions, no-alias SQL rule, surrogate-key and missing-record patterns, incremental strategies, deduplication, and common project macros. Use when building fact tables, dimension tables, staging models, writing SQL, or desi

7stars

Updated 13 days ago

View on GitHub ↗License: Apache-2.0

How to add

/plugin marketplace add yeaight7/agent-powerups

The exact command may vary by repository. Check the README on GitHub.

For the skill author

Drop this on your repo README

Shows your skill is listed on Skillteca, generates a backlink and trackable traffic.

[![Listada na Skillteca](https://www.skillteca.com.br/api/badge/dbt-strategy/svg)](https://www.skillteca.com.br/skills/dbt-strategy?utm_source=badge&utm_medium=readme&utm_campaign=badge)

#sql #mcp

Related skills

See all in Dados e Análise →

xlsx

143.8k

Use this skill for any task involving spreadsheet files as primary input or output, such as opening, reading, editing, fixing, creating, or converting .xlsx, .xlsm, .csv, or .tsv files.

Dados e Análise#xlsxby anthropics

mem-search

79.7k

Searches claude-mem's persistent cross-session memory database. Use this to answer questions about previous solutions or retrieve work from past sessions.

Dados e Análise#aiby thedotmack

weekly-digests

79.7k

Generates a week-by-week narrative digest of a project's Claude-mem timeline, splitting it into ISO-week files and using subagents to produce weekly chapters. Ideal for "weekly digests" or "narrative chapters" of a project's history.

Dados e Análise#aiby thedotmack

how-it-works

79.7k

This skill explains how claude-mem captures observations, when memory injection occurs, and where its data is stored.

Dados e Análise#aiby thedotmack

Category alert

Get new Dados e Análise skills every Monday

One short email with only the new Dados e Análise skills. 4 minutes of reading, no spam, unsubscribe with one click.

You confirm your email on the first send. No spam. Unsubscribe with one click.

dbt Strategy

Patterns for building dbt models in warehouse-backed analytics projects using Kimball-style dimensional modeling.

Layer Architecture

sources/     Source views — raw data from app DB, event stream, billing, CRM, LMS
    ↓
staging/     Intermediate transformations (keep minimal — new models go directly to core/)
    ↓
core/        Fact and dimension tables (main transformation layer)   → tables
    ↓
marts/       Business aggregations built on top of core             → tab

[Description truncada. Veja o README completo no GitHub.]

ShareX LinkedIn

Comments · No comments

No comments yet. Be the first.