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

["Frank Maritato (JIRA)" <ji...@apache.org>]

Frank Maritato created AIRFLOW-4031:
---------------------------------------

             Summary: 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


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)