Support Snowflake multi-factor authentication

[popcornylu]

Is your feature request related to a problem? Please describe. In current snowflake integration, it only supports to login by basic authentication (user/password). If the user enable the MFA, there is no way to use piperider

Describe the solution you'd like Reference of snowflake profile in dbt

1. run piperider run
2. send push notification to Duo Mobile
3. Approve the request
4. Continue

Describe alternatives you've considered N/A

Additional context N/A

[chenxuanrong]

Hi @popcornylu I'm happy to contribute to this feature. What's the prerequisite of contributing? I tried to push changes but got denied.

(.venv) ➜  piperider_v_7_0 git:(feat/snowflake-sso-authentification) ✗ git push
remote: Permission to InfuseAI/piperider.git denied to chenxuanrong.
fatal: unable to access 'https://github.com/InfuseAI/piperider.git/': The requested URL returned error: 403

[chenxuanrong]

Hi @DaveFlynn @jonycfu,

wonder you have any idea on the above comment ☝️ ? I'm keen to contribute to this feature and has implemented locally and worked well.

[DaveFlynn]

Hi @chenxuanrong

Thanks for taking the time to contribute! To submit your contribution please fork the repo, make your changes on a branch and submit a pull request which will be reviewed and merged.

Dave

[popcornylu]

The journey would be similar to dbt. For snowflake MFA-enabled user, the process would be

1. piperider run
2. The duo mobile pop the notification
3. Approve in the app
4. piperider would continue the progress.