Closed Lawiss closed 1 month ago
The changes introduce an extensive set of new DBT models and SQL logic files in the observatoire
directory. These files define various metrics for transportation and carpooling data, aggregated by different time periods (day, month, trimester, semester, year) and geographical levels. The new models and SQL views aim to provide detailed analytics on journeys, incentives, and occupations, enhancing data-driven insights for transportation planning and policy-making.
Files | Change Summaries |
---|---|
dbt/models/observatoire/_distribution_by_month.yml , _distribution_by_semester.yml , _distribution_by_trimester.yml , _distribution_by_year.yml , _distribution_distances_by_day.yml , _distribution_hours_by_day.yml |
Introduced new models for distribution metrics by various time periods, with columns for year, month, semester, trimester, code, type, direction, hours, and distances. |
dbt/models/observatoire/_incentive_by_day.yml , _incentive_by_month.yml , _incentive_by_year.yml |
Added new models for incentive metrics by different time periods, currently with no specified columns. |
dbt/models/observatoire/_view_distribution.yml |
Introduced a new DBT model view_distribution with columns capturing start, end, start date, hour, and distribution classes. |
dbt/models/observatoire/carpool_incentive_by_day.sql , directions_incentive_by_day.sql , flux_by_month.sql , flux_by_semester.sql , flux_by_trimester.sql , flux_by_year.sql , incentive_by_month.sql , incentive_by_semester.sql , incentive_by_trimester.sql , occupation_by_month.sql , occupation_by_semester.sql , occupation_by_trimester.sql |
Added SQL logic for incremental materialized views to calculate various metrics (e.g., incentives, flux, occupation rates) by time period and territorial level. |
dbt/models/observatoire/view_carpool.sql , view_carpool_ok.sql , view_directions.sql |
Introduced SQL views for carpool data, with transformations based on geographical codes, time zones, and duration calculations. |
dbt/models/sources/company.yml |
Defined a version 2 schema for a company data source with detailed company information such as identifiers, legal details, addresses, and timestamps. |
In fields of code where data flows, New models rise as metrics grow. By month, semester, day, and year, Transportation stats now clear. Carpool journeys, incentives bright, A rabbit's code brings data light. 🚗✨
Thank you for using CodeRabbit. We offer it for free to the OSS community and would appreciate your support in helping us grow. If you find it useful, would you consider giving us a shout-out on your favorite social media?
Cette PR ajoute au projet dbt précédemment initialisé un peu de configuration et d'organisation pour pouvoir commencer à développer nos modèles sur de bonnes bases.
Une image docker a aussi été ajoutée dans le dossier
docker/dbt/
.Summary by CodeRabbit
New Features
Documentation