[
https://issues.apache.org/jira/browse/AIRFLOW-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Fokko Driesprong resolved AIRFLOW-4031.
---------------------------------------
Resolution: Fixed
Assignee: Frank Maritato
Fix Version/s: 2.0.0
> 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: 2.0.0
>
>
> 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)
