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.
Questo esercizio fa parte del corso
Introduction to Data Modeling in Snowflake
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- 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)
);