C4W4A1 – Row count mismatch in deftunes_transform tables

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

I’m currently working on C4W4A1 – Assignment 4: Capstone Project Part 1 (ETL and Data Modeling) on the Coursera platform.

Issue

I am unable to pass the assignment due to consistent row count mismatches reported by the grader:

  • dev.deftunes_transform tables output: Expected 34 rows, but got 54

  • deftunes_transform.sessions table output: Expected 92 rows, but got 167

What I’ve tried

  • Carefully followed all assignment instructions

  • Re-ran the assignment twice

Observation

The outputs consistently return these errors. I also found that other learners have reported the same discrepancies, but I haven’t seen a confirmed solution yet.

This issue is currently blocking my course completion, so I would really appreciate any guidance.

Thank you!

2

@namgiang Hi! As you see in the other branch of discussion with the same issue (where you also commented), Rebooting the lab and submitting it again usually helps.

1 Like