If you have to process data on a recurring basis get some ideas:
https://www.bundesbrandschatzamt.de/~baron/blog/20220618-howto-write-complex-programs-running-on-vertica.html