Vertica Python 3 Client ?

Which features of Python 3 do you need?

vertica python client (.whl) in client driver package cannot be installed on python 3, correct me if i'm wrong

python 2 is at the end of its life and will be desupported soon

python 3 + pyodbc + vertica odbc library works well, what I'm missing is direct use of copy command as documented here:

https://my.vertica.com/docs/9.0.x/HTML/python_client/loadingdata_copystdin.html

vertica python client (.whl) in client driver package cannot be installed on python 3, correct me if i'm wrong

python 2 is at the end of its life and will be desupported soon

python 3 + pyodbc + vertica odbc library works well, what I'm missing is direct use of copy command as documented here:

https://my.vertica.com/docs/9.0.x/HTML/python_client/loadingdata_copystdin.html

can this be achieved with pyodbc ?

There is a third-party Python client library developed by Uber that may suit you. It supports Python 3, and does support COPY:

cur = connection.cursor() cur.copy("COPY test_copy (id, name) from stdin DELIMITER ',' ", csv)

Note that Vertica doesn't officially support this library.