Filepath() ,metadata functions in serverless view on delta format

Anonymous
2021-11-08T07:20:29.68+00:00

Hi , Earlier i was creating serverless views with FORMAT='PARQUET' using openrowset wildcard paths ("/synapsetesing/test/*.parquet"), so i was able to use metadata functions like filepath etc ,
now when i create views on FORMAT='DELTA' , path will be pointing to delta folder ("/synapsetesing/test/") . if i partition data in delta folder , delta always store meta data , so is there a way to filter data while creating views , like the we use filepath() =specific folder(partition folder)

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,492 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,010 questions
{count} vote

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.