Filepath() ,metadata functions in serverless view on delta format
Anonymous
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)
Sign in to answer