
Connecting with SQLAlchemy
Has anyone ever tried to connect to Incorta externally using the python package SQLAlchemy?
We're trying to use it along side the python driver psycopg2 and we get the error 'Failed to Parse query' regardless of whatever query we try. The psycopg2 driver works on it's own though.
Thanks!
-
Hi Dan, in the SQL log I see the following.... It appears that the very first character can not be interpreted.
ERROR: [15:20:59] [sqli | incmifhlb@incorta | Protocol]Caused by: net.sf.jsqlparser.parser.ParseException: Encountered "<EOF>" at line 1, column 1.
Was expecting one of:
"SET" ...
"CALL" ...
"SELECT" ...(I removed the end... the list goes on)
This happens with a few different queries, all start with the word 'SELECT'