1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Data Modeling in Snowflake
Connected

Exercise

Mastering data retrieval

After exploring various data modeling techniques, it's clear that the data vault model is ideally suited for this specific HR team's needs. The team requires a robust system that maintains historical records and tracks every change, a strength of the data vault model.

This exercise focuses on querying the data vault structure to analyze employees' training accomplishments and departmental affiliations.

Your task will be to gather the highest score for all employees that have won one award.

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Retrieve the attributes hub_employee_key and department_name from hub_employee and sat_department entities respectively.
  • Merge hub_employee with link_all using the common key hub_employee_key.
  • Merge link_all with sat_department using the common key hub_department_key.