Creating Fact Tables

In a previous exercise, we used a Dataflow to ingest a CSV file and create a table. Another option to get data into a warehouse is by creating the empty tables in the warehouse and then using T-SQL to copy data from a lakehouse.

In this exercise, you will create a fact table called fact_orders in a Fabric Warehouse and populate it with data from a CSV file uploaded to a lakehouse.

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.