Can I copy bulk load without a file?

David_P_1

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/index.htm#Authoring/SQLReferenceManual/Statements/COPY/COPY.htm

swalkaus

The following package loads data from an odbc source. It is a little dated and I haven't used it so I can say for certain that it works. Nonetheless, it might be useful to you.
https://github.com/vertica/Vertica-Extension-Packages/tree/master/odbc_loader_package