1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Data Modeling in Snowflake
Connected

Exercise

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.

Instructions 1/3

undefined XP
  • 1
    • Create a satellite entity for employees with the name sat_employee, listing the attributes load_date and record_source to track history.
    • Add a foreign key reference to hub_employee's key, hub_employee_key.
  • 2
    • Add auto incremental unique identifier for the satellite; name this attribute sat_department_key with datatype NUMBER(10,0).
    • Add a numerical attribute hub_department_key of 10 digits, load_date as TIMESTAMP, and record_source as 255 characters.
    • Add a foreign key reference to hub_department's key, hub_department_key.
  • 3
    • Add an attribute hub_training_key to the satellite, and use it to create a foreign key and reference to the hub_training's key with the same name, hub_training_key.