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

Connected

Exercise

Implementing views

The Star Customer financial company seeks to streamline its data management to efficiently categorize customers and track their product usage. You will create a view to facilitate quick and efficient data retrieval, calculating specific customer categories.

Instructions 1/2

undefined XP
    1
    2
  • Begin by creating or replacing a view called customer_financial_summary.
  • Gather data from the customers entity, combining it with information from customerproducts entity. Ensure that all customers are included, even if they don't have corresponding records in these entities.