@qdmt one idea could be to test H2/SQL database:
http://h2database.com/html/advanced.html#limits_limitations
You could create a new database connection with a current H2 driver (from Maven) and add the “split” parameter to the connection string:
jdbc:h2:split:[location=file?<file>][location=in-memory?mem:<database>]
You will have to select this new “h2_split” database driver in the H2 Connector instead of the built-in one:
The data would then be stored in a local H2/SQL database in chunks of 1 GB. So you have more flexibility with the size. You can later compact the database (which may take some time).
kn_example_db_h2_large_files_split.knwf (57.2 KB)