Skip to main content

Data Factory

Declined

Pipeline: Copying from Lakehouse/Warehouse to Warehouse, without Staging

Vote (2) Share
Christian Wietor's profile image

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.