dbt-example

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

★ 11 Open GitHub ↗

This is an example dbt project prepared by Pipeline To Insights for tutorial purposes.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Example dbt Project

This is an example dbt project prepared by [Pipeline To Insights](https://pipeline2insights.substack.com/) for tutorial purposes. Check out full blog post for more details.

🔗 [Full Post](https://open.substack.com/pub/pipeline2insights/p/dbt-in-action-1-fundamentals?r=p5bpr&utm_campaign=post&utm_medium=web&showWelcomeOnShare=false)

## Overview

This dbt project transforms raw e-commerce data into clean, analytics-ready tables by following a layered approach:

- Staging Layer → Standardises raw data
- Intermediate Layer → Aggregates and processes data
- Marts Layer → Provides final business-ready tables

## Project Structure

```bash
ecommerce_project/
│-- models/
│   ├── staging/      
│   │   ├── stg_orders.sql
│   │   ├── stg_customers.sql
│   │   ├── stg_payments.sql
│   │   ├── sources.yml
│   │   └── schema.yml
│   ├── intermediate/   
│   │   ├── int_order_summary.sql
│   │   ├── int_payment_summary.sql
│   │   └── schema.yml
│   ├── marts/         
│   │   ├── mart_customer_lifetime_value.sql
│   │   ├── mart_orders_payments.sql
│   │   └── schema.yml
│   ├── data/
│   │   ├── orders.csv
│   │   ├── customers.csv
│   │   ├── payments.csv
│   ├── analyses/  
│   ├── macros/  
│   ├── seeds/  
│   ├── snapshots/ 
│   ├── tests/ 
│-- .gitignore 
│-- dbt_project.yml
│-- profiles.yml
│-- README.md
```

## Installation & Setup

1. Install dbt:

```bash
pip install dbt-core dbt-postgres
```

2. Configure profiles.yml(update database credentials):

```yaml
ecommerce_project:
  target: dev
  outputs:
    dev:
      type: postgres
      host: localhost
      user: my_user
      password: my_password
      port: 5432
      dbname: my_db
      schema: public
```

3. Test the connection:

```bash
dbt debug
```

4. Run the models:

```bash
dbt run
```

5. Run the tests:

```bash
dbt test
```

6. Generate and serve documentation:

```bash
dbt docs generate
dbt docs serve
```

dbt-example

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

dbt-example

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README