This project aim to create a scalable data warehouse that uses ELT( Extract, Load, and transform) using DBT and it will host the vehicle trajectory data extracted by analyzing footage taken by swarm drones and static roadside cameras. We will be using Apache Airflow for scheduling and DBT for data transformation.