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