Converting vertica data types into pyarrow types

[ni-todo-spot]

Hey All!

I'm implementing a script querying a vertica db & I'd like to "pipe" the results into a pyarrow table.

I wat thinking about feeding the table with list of dicts (using the driver's dict cursor - https://arrow.apache.org/docs/python/generated/pyarrow.Table.html#pyarrow.Table.from_pylist).

For optimal result - I need to convert vertica's data types into a matching pyarrow data types - and thus I get to my question:

What are my options here - for you opinion?

Many thanks!