I would like to write a Python script to select data from a MySQL database, and copy bulk load that data into a Vertica database.
Is there a way to do this without a file? It would be faster to have no file, and just copy from memory? Perhaps using the STDIN parameter?
https://my.vertica.com/docs/7.2.x/HTML/ ... Y/COPY.htm