Overview
Today, we released a small update for our partners who utilize Snowflake. This update will roll out over the next 12 hours and affect the following models:
el_lookup_student_types
el_lookup_gender
el_lookup_citizenship_status
We've added a value_occurrence column to the affected lookup tables. This column uses the row_number() function to count each occurrence of a specific value.
To prevent duplicates when joining the lookup table, you'll now join on value_occurrence = 1.