[GitHub] [airflow] mehmax commented on issue #18664: [Oracle] Oracle Hook - make it possible to define a schema in the connection parameters

Sun, 03 Oct 2021 23:20:36 -0700 


mehmax commented on issue #18664:
URL: https://github.com/apache/airflow/issues/18664#issuecomment-933177853


   The Idea was, to set the schema name in the corresponding field from UI.
   
![image](https://user-images.githubusercontent.com/84371809/135802481-2f7f0d1c-c649-4189-99f1-d3139257f221.png)
   
   When using Oracle Hook, (hook.get_hook()) automatically after connection, 
the default schema should be set within the cx_Oracle connection.
   
   For example by adding a
   conn.execute("ALTER SESSION SET CURRENT_SCHEMA" = MY_SCHEMA) here:
   
https://github.com/apache/airflow/blob/866a601b76e219b3c043e1dbbc8fb22300866351/airflow/providers/oracle/hooks/oracle.py#L134-L135
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to