Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MOVC
Helper II
Helper II

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 Data into a Warehouse it requires that staging is enabled but does not support Workspace Staging and needs a connection to an Azure Environment. I'm assuming this is intentional, but are there any plans to allow this to use the StagingWarehouse objects in the future? It would be nice to keep everything in OneLake which would seem to fit with it's described purpose.

 

copydata.png

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

7 REPLIES 7
smeetsh
Helper II
Helper II

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.

Anonymous
Not applicable

Hi @MOVC ,

Thanks for using Fabric Community.

A simple workaround is by loading this to a cloud Lakehouse first, and then another copy activity to write that to WH.

In between we are also reaching out to the internal team to get some help on this .
We will update you once we hear back from them.

Anonymous
Not applicable

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.

Hi - is there any update to this?
Copying from on-prem -> Lakehouse -> Warehouse isn't a practical solution for us.   Is there an alternative?  ( sorry am new to Fabric ).

Anonymous
Not applicable

Hi @MOVC ,

Glad to know that your query was resolved. Please continue using Fabric Community on your further queries.

Joshrodgers123
Advocate V
Advocate V

I posted the same thing yesterday. Seems to go against the "OneLake" concept to have to bring additional Azure resources to copy to a warehouse.

ShaunBrewer
Regular Visitor

Good question - I would like to know the answer too.

Helpful resources

Announcements
Sept Fabric Carousel

Fabric Monthly Update - September 2024

Check out the September 2024 Fabric update to learn about new features.

Expanding the Data Factory Forums

New forum boards available in Data Factory

Ask questions in Apache Airflow Job and Mirroring.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.