In the path, https://github.com/DataExpert-io/data-engineer-handbook/blob/main/intermediate-bootcamp/materials/1-dimensional-data-modeling/sql/load_players_table_day2.sql
at line no 68 and 69,
current code
(seasons[CARDINALITY(seasons)]::season_stats).season = season AS is_active,
w.season
fix:
w.season,(seasons[CARDINALITY(seasons)]::season_stats).season = season AS is_active
In the path, https://github.com/DataExpert-io/data-engineer-handbook/blob/main/intermediate-bootcamp/materials/1-dimensional-data-modeling/sql/load_players_table_day2.sql
at line no 68 and 69,
current code
(seasons[CARDINALITY(seasons)]::season_stats).season = season AS is_active,
w.season
fix:
w.season,(seasons[CARDINALITY(seasons)]::season_stats).season = season AS is_active