AnsweredAssumed Answered

what does it mean when there's no submission_fact entry for a submission_dim?

Question asked by pmichaud@uw.edu on May 27, 2015
Latest reply on Dec 1, 2015 by Zac Watson

I stumbled over these while trying to do some aggregate functions.  There are 45,588 entries in my submission_dim table that don't have a match in the submission_fact table.  Does this mean something specific?  Is it a data error?

 

Here is an example:

 

canvas=> select * from submission_dim where id = 100000024123908;

-[ RECORD 1 ]--------------------+---------------------------

id                               | 100000024123908

canvas_id                        | 24123908

body                             |

url                              |

grade                            | 2

submitted_at                     |

submission_type                  |

workflow_state                   | graded

created_at                       | 2015-05-01 05:52:55.666434

updated_at                       | 2015-05-01 05:52:55.666434

processed                        |

process_attempts                 | 0

grade_matches_current_submission |

published_grade                  | 2

graded_at                        | 2015-05-01 05:52:55.52155

has_rubric_assessment            |

attempt                          |

has_admin_comment                |

canvas=> select * from submission_fact  where submission_id = 100000024123908;

(No rows)

 

Since course, assignment, user and so on are in the _fact table, it's hard to tell what the source of this entry is.

Outcomes