Failed Grader for Week 4 Capstone Part 1

Course Q&A Data Engineering Data Modeling, Transformation, and Serving
,
1

When i submitted the Capstone part 1 the for dev.deftunes_transform tables grader says
Failed test case: Incorrect output in ‘ex02’:
Number of lines do not match. Expected: 34 lines, but got: 54 lines.

2

This is not an error on your end. It’s a Redshift version mismatch with the grader.

The ex02 cell runs SHOW TABLES FROM SCHEMA dev.deftunes_transform. Older Redshift versions returned 6 columns for this command (34 HTML lines), but the current version returns 11 columns (54 HTML lines), adding owner, last_altered_time, last_modified_time, dist_style, and table_subtype.

Your 3 tables (sessions, songs, users) are correct. The extra 20 lines = 5 extra columns × 4 rows (1 header + 3 data rows). The grader was built against the older column set.

I also ran into the same issue on my end. Since the SQL command is given to us and we can’t control what Redshift returns, there’s nothing to fix from our side. This needs a grader update from the course team.

3

Thanks for reporting @Geologic and @arman101! The grader has been updates