Welcome to your new dbt project!

dbt + Snowflake: eCommerce Analytics Project

This project models customer and order data for an eCommerce platform using dbt and Snowflake.

🔧 Tech Stack

• Warehouse: Snowflake
• Modeling: dbt Cloud
• Source Tables: customers, orders
• Staging Models: stg_customers, stg_orders
• Intermediate: int_customer_orders
• Marts: dim_customers, fct_orders

📊 Metrics Modeled

• Customer total orders and total spend
• Order-level fact table
• Clean, documented staging layers

📁 Folder Structure

. ├── models/ │ ├── stg_customers.sql │ ├── stg_orders.sql │ ├── int_customer_orders.sql │ ├── dim_customers.sql │ └── fct_orders.sql ├── dbt_project.yml └── README.md

🧪 How to Run

dbt run dbt test dbt docs generate && dbt docs serve

Resources:

• Learn more about dbt in the docs
• Check out Discourse for commonly asked questions and answers
• Join the dbt community to learn from other analytics engineers
• Find dbt events near you
• Check out the blog for the latest news on dbt's development and best practices