[jira] [Updated] (AIRFLOW-4031) Snowflake Hook - Allow Key Pair Authentication

["Ash Berlin-Taylor (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/AIRFLOW-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ash Berlin-Taylor updated AIRFLOW-4031:
---------------------------------------
    Fix Version/s:     (was: 2.0.0)
                   1.10.4

> Snowflake Hook - Allow Key Pair Authentication
> ----------------------------------------------
>
>                 Key: AIRFLOW-4031
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-4031
>             Project: Apache Airflow
>          Issue Type: Improvement
>    Affects Versions: 1.10.2
>            Reporter: Frank Maritato
>            Assignee: Frank Maritato
>            Priority: Major
>             Fix For: 1.10.4
>
>
> I'd like to modify the Snowflake Hook to allow for key pair authentication. For reference, I've been using this: [https://docs.snowflake.net/manuals/user-guide/python-connector-example.html#using-key-pair-authentication]
> My plan is that one would add the path to the private key as a parameter in the connection 'extra' json field and use the password for the connection as the passphrase for the private key file. So, for example,
> {"private_key_file": "/opt/airflow/snowflake_user.p8" }
> If private_key_file is not specified, it will assume username/password authentication as normal. If the private key is not encrypted (not recommended), the user can leave the password field blank.
> I will do a pull request with the changes shortly. Open to any feedback if you'd like it to work differently.
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)