Snowflake Schemas

In this exercise, you will create a Lakehouse for a restaurant chain, load a fact table and related dimension tables, and explore the resulting snowflake schema. We will build a model with six tables:

Table	Description
fact_orders	Daily sales order data from all restaurants
dim_menuitems	Information about the different menu items
dim_menucategories	Information about the different categories of the menu items
dim_restaurants	Information about the different restaurants
dim_city	Information about the cities where the restaurants are located
dim_state	Information about the states where the cities are located

Note: If you get an error about an API rate limit, this usually happens because a previous Fabric task has not completed. You can view active Fabric tasks from the Monitor page (located on the left vertical menu). Canceling old Fabric tasks in the Monitor page will usually resolve the rate limit error.