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)
