Creating satellites
With the hubs established, the next step is to create satellites that store descriptive information related to each hub. Satellites provide context and depth to the keys stored in hubs, and they capture the descriptive attributes, changes over time, and the history of business concepts.
Your task will be to create these satellites.
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 satellite
___ (
sat_employee_key NUMBER(10,0) AUTOINCREMENT PRIMARY KEY,
hub_employee_key NUMBER(10,0),
employee_name VARCHAR(255),
gender CHAR(1),
age NUMBER(3,0),
-- Add history tracking attributes
___ TIMESTAMP
___ VARCHAR(255),
-- Add a reference to foreign hub
FOREIGN KEY (___) REFERENCES ___(___)
);