Forum Discussion
Fabric REST API for Delta Tables
- Anonymous1 year ago
Hi alirng ,
Thanks for reaching out to the Microsoft Fabric Community.
At this time, there is no built-in REST API available to directly query or retrieve data from Delta tables stored in a Fabric Lakehouse. The existing Fabric REST APIs do not support reading Delta table contents using a GET request.
However, Microsoft Fabric provides GraphQL endpoint that supports querying data from Lakehouses and Warehouses through the SQL analytics layer. You can refer to the documentation here:
Microsoft Fabric API for GraphQL overview - Microsoft Fabric | Microsoft LearnAlternatively, if your application strictly requires REST access, one possible approach is to build a custom API using Azure Functions. This involves reading the Parquet files behind the Delta tables stored in OneLake and exposing them via your own REST endpoints.
Here's this approach in more detail here: Microsoft Fabric Lakehouse Data via REST API
Hope this helps. Please reach out for further assistance.
Thank you.
Hi alirng ,
Thanks for reaching out to the Microsoft Fabric Community.
At this time, there is no built-in REST API available to directly query or retrieve data from Delta tables stored in a Fabric Lakehouse. The existing Fabric REST APIs do not support reading Delta table contents using a GET request.
However, Microsoft Fabric provides GraphQL endpoint that supports querying data from Lakehouses and Warehouses through the SQL analytics layer. You can refer to the documentation here:
Microsoft Fabric API for GraphQL overview - Microsoft Fabric | Microsoft Learn
Alternatively, if your application strictly requires REST access, one possible approach is to build a custom API using Azure Functions. This involves reading the Parquet files behind the Delta tables stored in OneLake and exposing them via your own REST endpoints.
Here's this approach in more detail here: Microsoft Fabric Lakehouse Data via REST API
Hope this helps. Please reach out for further assistance.
Thank you.
Hi alirng ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.