darshilparmar/zomato-ai-data-engineering-end-to-end-project ? reverse-engineered prompt

Build me an end to end Zomato style data pipeline and AI dashboard project.

I want raw food delivery CSVs to land in cloud storage, load into a warehouse, get cleaned and modeled into usable reporting tables, and then be orchestrated as one daily workflow. Please include a proper bronze, silver, and gold setup, with cleaned staging views, dimension tables, incremental fact tables, and a few business friendly marts like revenue, restaurant performance, and delivery timing.

Also add an AI layer for review analysis. I want free text reviews turned into structured fields like sentiment and topic, plus a simple chat style app that can answer questions from the review data, and another one that can answer questions about the warehouse in plain English.

Make it work with a warehouse, dbt, Airflow, and a small web app for the AI pieces. Use environment variables for secrets, include setup instructions, and if you need current docs for any service, look them up online.