Running Python Script as External Procedure in Vertica 7.1

Hi ,

 

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 ?

 

Regards

Vini

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file