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

Exercise

Applying 1NF

After creating ingredients and reviews entities, it's time to populate them with data from productqualityrating.

This step is crucial to ensure that each value within the ingredients and review is treated as a distinct entry, aligning with the principles of 1NF.

Start by crafting a query to transform and input the unnormalized data into these entities, adhering to the first normal form principles.

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Select ingredients cleaned from empty spaces at start an end of the value.
  • Use the LATERAL FLATTEN(INPUT => SPLIT()) function to separate the values inside ingredients attribute from productqualityrating that are separated by a comma.