Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Write to Lakehouse Files

Are there any options to write to lakehouse files using T-Sql. 

  • Hello Anonymous 

     

    you cannot directly use the Warehouse SQL endpoint to write data to Lakehouse files.

     

    You can move data from a Warehouse to a Lakehouse using Fabric Pipelines or Dataflow Gen2.

    If you need to write data directly into Delta tables in the Lakehouse, you can use Apache Spark in the Lakehouse workspace

     

2 Replies

  • Hello Anonymous 

     

    you cannot directly use the Warehouse SQL endpoint to write data to Lakehouse files.

     

    You can move data from a Warehouse to a Lakehouse using Fabric Pipelines or Dataflow Gen2.

    If you need to write data directly into Delta tables in the Lakehouse, you can use Apache Spark in the Lakehouse workspace

     

  • v-achippa's avatar
    v-achippa
    Community Support

    Hi Anonymous,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you nilendraFabric for the prompt response.

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
    If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

     

    Thanks and regards,

    Anjan Kumar Chippa