Use the OPTIMIZE Operation

Delta table maintenance ensures that delta table files are compacted and stored optimally for access by Fabric engines. In this exercise we'll load data into a lakehouse table and run the optimize operation.

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.