dbt-labs/jaffle_shop_duckdb — reverse-engineered prompt
Reverse engineered prompt
Build me a super simple dbt demo project for a fictional ecommerce shop called jaffle shop. I want it to run fully on my laptop with DuckDB and fake seed data, no cloud setup, and be something a beginner can clone and get working in about a minute. Use raw data for customers, orders, and payments, then create a few clean analytics models like customers and orders, plus basic tests and generated docs so I can run dbt build, dbt docs generate, and dbt docs serve and immediately explore the lineage and model descriptions.
Please keep it intentionally small and self contained, more like a playground than a production example. Add whatever setup and local config are needed so the default experience just works with Python. A short README with exact copy paste commands to install, run, and view the docs would be great. If anything is unclear, look up the current dbt and DuckDB docs online.
Want more depth? Deep Reverse