I have directories with
.parquet files configured as datasets according to this: https://docs.dremio.com/data-sources/files-and-directories.html#configuring-directories-as-datasets
I can access directory name using dir0-dirN aliases. But is it also possible to somehow access filename to, for example, filter query like this
WHERE filename LIKE '20200801%'?
Cannot find any function or field like this.
filename mentioned here (Expose filename dates in query engine) gives me SQL syntax validation error.
I’m using the Community Edition Build 4.6.1-202007220122450047-62e084d0