Forum Discussion

girishtharwani2's avatar
girishtharwani2
Helper III
1 year ago
Solved

Serverless views in Fabric

Hi, I have loaded data from a source into the Data Lake (ADLS) using a Fabric pipeline. In Synapse, we used to query ADLS data using serverless views. Is there a similar way to utilize serverless vi...
data engineering
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hello girishtharwani2.,

    Thank you for your detailed explaination regarding your query.

     

    I would also take a moment to personally thank nilendraFabric , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

     

    In Fabric Lakehouse, while there isn't a direct equivalent to Synapse Serverless SQL for dynamically querying partitioned data, you can achieve similar functionality using Lakehouse Shortcuts with Delta tables or dynamic queries with metadata tables.

     

    Here are some approaches to consider:

    • If your data in ADLS follows the Delta format, Fabric Lakehouse natively supports querying Delta tables, allowing you to use SQL to filter the latest partition dynamically.
    • If you are working with Parquet files, you can use Fabric Notebook with PySpark to create a metadata table that dynamically tracks partition locations.

    I hope this should resolve your issue, if you need any further assistance, feel free to reach out.

     

    If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

     

    Thank you. 

nilendraFabric's avatar
nilendraFabric
Super User
1 year ago

Hello girishtharwani2 


You can use sql endpoint on OPENROWSET. 

this functionality will be available using OPENROWSET

Estimated release timeline: Q1 2025

Release Type: Public preview

Fabric DW enables the users to use the OPENROWSET function to read data from the files in the lake. A simple example of OPENROWSET function is:

 
SELECT * 
FROM OPENROWSET ( BULK ‘<file path>’ ) 
WITH ( <column definition> )

The OPENROWSET function will read the content of the file(s) at the given <file path>and return the content of the files. Thi function enables easy browsing and previewing the files before ingestion.

 

https://learn.microsoft.com/en-us/fabric/release-plan/data-warehouse

 

please see if this is helpful and try running OPENROWSET