anshlambagit/Airbnb_Snowflake_DBT_Data_Engineer_Project — reverse-engineered prompt

Build me an end to end Airbnb data engineering project using sample CSV files for bookings, hosts, and listings. I want the data to start as raw files, get loaded into Snowflake, then transformed with dbt into clean tables that are easy to analyze.

Set it up with clear bronze, silver, and gold layers. Bronze should keep the raw data, silver should clean and standardize it, and gold should create useful reporting tables that combine bookings, listings, and host details. Please include logic for only processing new or changed records, basic data quality tests, and a way to keep history when important records change over time.

Use AWS S3 as the place where the raw files would live before Snowflake. Add setup scripts, dbt models, snapshots, helpful macros, and clear instructions so I can run everything from scratch. Also include commands for running the models, tests, snapshots, and dbt docs. Look up current docs online if you need to.