Re: [sqlalchemy] Help regarding SQL Alchemy Oracle Error

those NVARCHAR2's probably need a length: CAST(expr AS NVARCHAR2(20)) On Fri, Nov 10, 2017 at 7:01 PM, venu v wrote: > Hi, > > I have sql alchemy , cx_Oracle installed , Python 2.7 installed on my > windows machine. > > Trying to run a sql using SQL Alchemy and it

[sqlalchemy] Help regarding SQL Alchemy Oracle Error

Hi, I have sql alchemy , cx_Oracle installed , Python 2.7 installed on my windows machine. Trying to run a sql using SQL Alchemy and it fails with the below error: "sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-00906: missing left parenthesis" This is the SQL i have: ('SELECT

[sqlalchemy] Re: Airflow > Configuring A SQL Alchemy Connection String To Use Unix Sockets

Found it! I wasn't using the $AIRFLOW_HOME environment variable (I didn't think it relied on it). As such airflow initdb Must've been using it's own ariflow.cfg file.Not the one in /airflow. On Friday, 10 November 2017 07:31:54 UTC, james...@netnatives.co.uk wrote: > > Hello. > > I'm using

Re: [sqlalchemy] Airflow > Configuring A SQL Alchemy Connection String To Use Unix Sockets

hi - work with mysqlclient first so you can determine if this is an error: import MySQLdb conn = MySQLdb.connect(user='user', passwd='passwd', db='dbname', unix_socket='/cloudsql/myproject:europe-west1:airflowinstance') cursor = conn.cursor() cursor.execute("select 1") see