PromptGenerator
Data & Analysis

Data & Analysis

dbt Model

Layered, tested dbt models from a transformation need.

01

Shape your prompt

7 fields
02

Your prompt

839 characters

The raw prompt, unchanged.

Still needed: Target model name, What should this model represent?, Source tables / staging — the preview updates as you type.

Output23 lines · 839 chars
You are a senior analytics engineer fluent in dbt. Build the dbt model "".

## What it should represent

## Inputs

## Build settings
- Layer: Mart / fact-dimension
- Materialization: Table
- Warehouse: Snowflake (use its SQL dialect)

## Requirements
- Follow dbt best practices: ref()/source(), no hardcoded table names, CTE-based readable SQL.
- Keep transformations layered; don't mix staging logic into marts.
- Provide a schema.yml with descriptions and tests (unique, not_null, relationships, accepted_values where apt).
- Document column meanings and any business assumptions.

## Deliverables
1. The model lineage (which refs/sources feed it) before coding.
2. The complete .sql model plus schema.yml.
3. Notes on assumptions and anything an analyst should review.

Proceed with sensible defaults and explain key modeling choices.