I have a minio object structure as below:

• experiment_1/images/sample1/<thousands of images>

• experiment_1/images/sample2/<thousand of images>

I want to create a foreign table to actually query these images. So e.g I should be able to Select From Images where name='abc'.

I am new to Foreign Tables, and was trying to follow the documentation of paradedb to do this, but the docs are all for creating Foreign Tables from csv and parquet files.

Is there a way to do this?

In the past, I used to store the absolute number of image in the tabe, and also the dir_name, for each image. Which would allow me to query an image at a time point (absolute number). But I don’t want to store the same information 2 times.