DBT_project: MySQL Data Transformation Fundamentals

This repository contains a beginner-level dbt (Data Build Tool) project focused on transforming data stored in a MySQL database.

---

Project Description

This is a simple ETL (Extract, Transform, Load) step designed for foundational sales analysis. The transformation logic joins the raw customer order data (orders) with customer details (customers) to calculate the total number of orders and the total amount spent per customer.

Technologies Used

• Transformation Tool: dbt Core (using Jinja SQL)
• Database: MySQL

---

Key Project Files

The core logic resides in the models/ directory:

1. sources.yml: Defines the two source tables (orders and customers) from the MySQL database.
2. orders_summary.sql: Contains the SQL logic that performs the JOIN and GROUP BY operations to create the final analytical model.

Resources:

• Learn more about dbt in the docs
• Check out Discourse for commonly asked questions and answers
• Join the chat on Slack for live discussions and support
• Find dbt events near you
• Check out the blog for the latest news on dbt's development and best practices