This repository holds the code and configuration for a scalable data warehouse designed to store and analyze vehicle trajectory data collected by swarm UAVs and static roadside cameras in a city traffic department. The data warehouse utilizes the ELT (Extract, Load, Transform) framework with DBT, allowing analysts to define data transformations on-demand.
- /airfolw: Contains code for creating a DAG and storing data to postgresql database.
- /city_traffic_dbt: DBT models for transforming raw data into a structured format.
- /redash: contains code for creating dashboards.
Clone the repository:
git clone https://github.com/Misganaw-Berihun/City_traffic_data_warehouse.git
cd traffic-data-warehouse
