A Dremio SQL function to return object name?

1

I’ve been experimenting with directories of Parquet files that are formatted to act as one table.

Do we have a way in SQL to dig out the original object name from which a particular row originated? A scalar SQL function of some kind?

Suppose there were a scalar function named OBJECTNAME() that takes no arguments, which could be used in the following fashion. That’s the kind of thing I am hoping for.

SELECT OBJECTNAME(), A.* FROM MYTABLE A

and in this way obtain some sort of mapping back to the original Parquet file.

2

I don’t think Dremio exposes the file name and row number for Parquet datasets. Internally, we do have this information which is the basis for how DML operations work on Iceberg datasets. (Parquet datasets use Iceberg metadata to index the data files.)