S3 key prefix - dir0, dir1...dirN but no object/file name?

Hey @J_C, Welcome to the Dremio community.

You can enable the support key dremio.store.file.file-field-enabled in Settings -> Support -> Support Keys to see the filenames in $file column