Forum Discussion

ljml61's avatar
ljml61
Regular Visitor
1 year ago
Solved

Feed Lakehouse from external app

Hello, I want to feed our Fabric Lakehouse from an on-premise ETL. We are able to to feed an Azure Storage using a Shared Access Signature. But iIcan't find a way to build a SAS on a Fabric Lakehou...
data engineering
lakehouse
  • Srisakthi's avatar
    Srisakthi
    1 year ago

    Hi ljml61 ,

     

    If you want to push the files to Azure storage as well as to Fabric then you can leverage shortcut. By using shortcut you can avoid duplicating files.

     

    If your source data in on-prem sql server then you can utilise data pipeline with on-prem data gateway

     

    Regards,

    Srisakthi

ljml61's avatar
ljml61
Regular Visitor
1 year ago

Hi,

 

Thank you for your response.

Our ETL is using azcopy.exe to push the files into Azure storage.

Do you think using API is better ?

 

Actually, we must keep to push files Push from on-premise to Fabric, so using spark is not in scope.

 

Regards