[jira] [Commented] (AIRFLOW-5768) Google Cloud SQL - Don't store ephemeral connection object to database

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AIRFLOW-5768?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16974414#comment-16974414 ] 

ASF GitHub Bot commented on AIRFLOW-5768:
-----------------------------------------

potiuk commented on pull request #6440: [AIRFLOW-5768] GCP cloud sql don't store ephemeral connection in db
URL: https://github.com/apache/airflow/pull/6440
 
 
   
 
----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> Google Cloud SQL - Don't store ephemeral connection object to database
> ----------------------------------------------------------------------
>
>                 Key: AIRFLOW-5768
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-5768
>             Project: Apache Airflow
>          Issue Type: Improvement
>          Components: gcp
>    Affects Versions: 1.10.5
>            Reporter: Daniel Standish
>            Assignee: Daniel Standish
>            Priority: Major
>
> GCP cloud sql operator creates dynamically an ephemeral Connection object.  It persists to metastore during execution and deletes afterward.  
> This behavior has negative impact on our ability to refactor creds management.  
> By not persisting to database, we can also remove some complexity re ensuring connection is deleted in event of failure, and the tests that go along with that.
> This change requires that we add optional param `connection` to both MySqlHook and PostgresHook.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)