[
https://issues.apache.org/jira/browse/AIRFLOW-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16788853#comment-16788853
]
ASF GitHub Bot commented on AIRFLOW-4031:
-----------------------------------------
XD-DENG commented on pull request #4875: [AIRFLOW-4031] Allow for key pair auth
in snowflake hook
URL: https://github.com/apache/airflow/pull/4875
----------------------------------------------------------------
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:
[email protected]
> 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
> Priority: Major
>
> 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)
