Forum Discussion
Copy activity: Disable staging?
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 s...
It's very difficult to swallow the sales nonsense like "Lakehouse and Warehouse are made for each other". But you can't properly use a pipeline to ingest from Lakehouse to Warehouse. But you can from external ADLS gen2????
T-SQL COPY INTO actually works fine to import Lakehouse into Warehouse
I tried that first with very few issues.
Then I tried a pipeline and I'm having all kinds of hassles. Like needing to use staging. And getting parquet data type mapping issues which I'm pretty sure are due to needing this staing step.
Crazy thing is this is far more difficult that it ever used to be. You're going backwards people