/

Loading...
DataChonk generates a well-organized dbt project following best practices.
my_dbt_project/
├── dbt_project.yml
├── packages.yml
├── profiles.yml.example
│
├── models/
│ ├── staging/
│ │ ├── ecommerce/
│ │ │ ├── _ecommerce__sources.yml
│ │ │ ├── _ecommerce__models.yml
│ │ │ ├── stg_ecommerce__customers.sql
│ │ │ └── stg_ecommerce__orders.sql
│ │ └── stripe/
│ │ └── ...
│ │
│ ├── intermediate/
│ │ └── ...
│ │
│ └── marts/
│ ├── core/
│ │ ├── _core__models.yml
│ │ ├── dim_customers.sql
│ │ └── fct_orders.sql
│ └── marketing/
│ └── ...
│
├── macros/
│ └── ...
│
├── seeds/
│ └── ...
│
├── tests/
│ └── ...
│
└── analyses/
└── ...Main project configuration including model paths, materializations, and variables.
Dependencies on dbt packages like dbt_utils and dbt_expectations.
Template for database connection configuration.
| Layer | Purpose | Materialization |
|---|---|---|
| staging/ | Clean and standardize sources | view |
| intermediate/ | Complex transformations | ephemeral |
| marts/ | Business-ready tables | table |
_[source]__sources.ymlstg_[source]__[entity].sqldim_[entity].sqlfct_[event].sqlint_[description].sql