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.
Diese Übung ist Teil des Kurses
Introduction to Data Modeling in Snowflake
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
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 = ___;