Creating hubs
The HR department has commented that they need a more detailed history of all the changes with their records of employees, departments, and training.
You will need to restructure its data into a series of hubs.
Hubs will create a scalable and agile data warehouse that can accommodate changes over time without disrupting existing structures.
Deze oefening maakt deel uit van de cursus
Introduction to Data Modeling in Snowflake
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Create a new hub entity
___ (
-- Assign automated values to the hub key
___ AUTOINCREMENT PRIMARY KEY,
employee_id NUMBER(38,0),
-- Add attributes for historical tracking
___ TIMESTAMP,
___ VARCHAR(255)
);