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.
This exercise is part of the course
Introduction to Data Modeling in Snowflake
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
-- Add the attribute from employees
hub_e.___,
-- Add the attribute from the department
sat_d.___
FROM hub_employee AS hub_e
-- Merge hub with link
JOIN ___ AS li
ON hub_e.hub_employee_key = ___
-- Merge link with satellite
JOIN ___ AS sat_d
ON li.hub_department_key = ___;