darshilparmar/uber-etl-pipeline-data-engineering-project — reverse-engineered prompt

Build me a complete data engineering project that analyzes Uber or taxi trip data like the TLC trip records dataset. I want a working pipeline that takes the CSV data, cleans and transforms it with Python, loads it into Google Cloud Storage and BigQuery, and gives me useful analytics tables or queries for things like trip distance, fares, pickup and dropoff times, passenger counts, payment types, and location patterns.

Please set it up using Mage as the pipeline tool, with clear steps I can run on a GCP compute instance. Include the SQL needed for BigQuery analytics and make it easy to connect the final tables to Looker Studio for a dashboard.

Keep the project beginner friendly. Add clear comments and a README that explains the architecture, setup commands, how to run the pipeline, and what each part does. If you need exact current setup details for Mage or GCP, look up the latest docs online.