Closed Datayama38 closed 6 days ago
[!CAUTION]
Review failed
The pull request is closed.
The changes involve the addition of WHERE
clauses to multiple SQL files, specifically filtering out records with null values in the code
column. This adjustment affects two SELECT
statements in each file, ensuring that only valid entries are included in the results. The overall structure of the queries remains unchanged, but the filtering condition alters the dataset processed and returned.
File Path | Change Summary |
---|---|
dbt/models/observatoire/directions_by_day.sql |
Added WHERE code is not null to two SELECT statements to filter out null code values. |
dbt/models/observatoire/directions_incentive_by_day.sql |
Added WHERE code is not null to two SELECT statements to filter out null code values. |
dbt/models/observatoire/distribution_distances_by_day.sql |
Added WHERE code is not null to two SELECT statements to filter out null code values. |
dbt/models/observatoire/distribution_hours_by_day.sql |
Added WHERE code is not null to two SELECT statements to filter out null code values. |
🐰 In the land of data, bright and clear,
A filter was added, oh so dear!
No more nulls to cloud the view,
Just valid entries shining through.
Hooray for clarity, let’s all cheer,
For brighter insights, year after year! 🌟
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?
Summary by CodeRabbit
code
field across multiple queries, ensuring more accurate data analysis.