Data Factory
DeclinedPipeline: Copying from Lakehouse/Warehouse to Warehouse, without Staging
Christian Wietor on 26 Jul 2023 08:49:02
Hi,
i try to copy data from warehouse (view) to warehouse (table). Is there a way to disable staging?
I get the validation error "Direct copying data to Data Warehouse using Copy command is not supported for the specified source. Please enable staging." when i disable the option.
Staging seems to slow down copying a lot...
Administrator on 16 Oct 2023 05:44:04
Direct copy needs specific criteria, details refer to How to configure Data Warehouse in copy activity in Data Factory in Microsoft Fabric - Microsoft Fabric | Microsoft Learn.
If criteria does not meet, copy will go with staging.