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.
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.
-- 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)
);