The data warehouse in Microsoft Fabric was re-written to use OneLake storage. This means each and every table in the warehouse is based on the Delta file format. Staying away from single transactions will keep the warehouse performing at its best. We already learned in a prior article that T-SQL insert statements can be used to add rows to a table. Are there any other ways to insert or update rows in our warehouse?
Business Problem
Azure Data Factory has been a popular Extract, Load and Translate (ELT) tool. Data pipelines exist in the Azure Data Factory, Azure Synapse, and