cal-itp/data-infra

Bug: `mart_gtfs.fct_monthly_route_service_by_timeofday` primary key tests fail

Closed this issue · 1 comments

tiffanychu90 commented

Describe the bug
mart_gtfs.fct_monthly_route_service_by_timeofday primary key tests failed. Add all the columns used in the group by in previous query to create the key.

To Reproduce

Expected behavior
Each row should be unique, and we should include all the columns that make it unique into generating the key.

Additional context