Import folder and all subfolders

[skyhirider]

When opening a folder via DBeaver and csvjdbc, only the topmost csv files are imported.

Could options be added to the driver so that import of subfolders would be supported as well?

Could be a parameter that would define how deep csvjdbc should go, either root only, a specific number of folders or unlimited depth.

[simoc]

You can already query CSV files in subdirectories with CsvJdbc -- you just need to give the subdirectory names and table name in double quotes, so that it is clear that they are all part of the table name. For example to query example.csv in subdirectory foo/bar,

SELECT ID, NAME FROM "foo/bar/example"

However, the functions in CsvJdbc that list the available tables do not return CSV files in subdirectories. So, CSV files in subdirectories are not visible in database tools such as DBeaver.

I will add a database connection option to include CSV files in subdirectories in the list of available tables, so that CSV files in subdirectories are visible in DBeaver.