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.
Latihan ini adalah bagian dari kursus
Introduction to Data Modeling in Snowflake
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- 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)
);