Please let us know if we are joining incorrectly, or is this a bug?
I expect these to be able to join to one other. E.g. if I want to get a list of all quiz submissions that have been done, I should be able to see both when the user had finished the quiz (dim) and their score (fact).
But this returns an empty set:
SELECT * from quiz_submission_fact qsf inner join quiz_submission_dim qsd on qsd.submission_id=qsf.quiz_submission_id;
SELECT * from quiz_submission_dim qsd inner join quiz_submission_fact qsf on qsd.id=qsf.quiz_submission_id;