Running Python Script as External Procedure in Vertica 7.1
We have a python script that connects to database using pyodbc.connect and processes some sql statements.
When we run the script from shell - ./<script_name>.py , it runs perfectly fine. But when I install the script inside Vertica Database and create an external procedure and try to execute it as select <proc_nam>();, it fails with error could not connect to DSN.
What could be the possible cause for the same ?