Forum Discussion

MOVC's avatar
MOVC
Icon for Resolver I rankResolver I
2 years ago
Solved

On Prem SQL Server to Fabric Warehouse via Copy Data

I've been testing the Copy Data activity from On Prem SQL server via a Data Gateway which was recently made available. I have successfully managed to load into a Lakehouse, but when trying to get Dat...
General Question
pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MOVC , Joshrodgers123 , ShaunBrewer 

    Internal Team confimed that, it is on the roadmap. At present we don't have any ETA. But we can expect this feature in future.

smeetsh's avatar
smeetsh
Icon for Continued Contributor rankContinued Contributor
2 years ago

One work around may be to use the gateway to get the information, but in stead of writing it to a table, you write it to a scv file, in the next activity you read that csv file and ingest into the warehouse. We ingest several csv files that way.

This way the lakehouse is only used to store a file, and nothing else.