Creating Dimension Tables

Dimension tables are a key component of a star schema that make it easy for end users to interact with the model. In this exercise, you will create a dimension table in a Fabric Warehouse and populate it with data from a CSV file. The table has the following columns:

CustomerKey     
WWICustomerID   
Customer        
BillToCustomer  
Category        
BuyingGroup     
PrimaryContact  
PostalCode      
ValidFrom       
ValidTo         
LineageKey      

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 horizontal menu). Canceling old Fabric tasks in the Monitor page will usually resolve the rate limit error.