databrickslabs / remorph

Cross-compiler and Data Reconciler into Databricks Lakehouse
Other
24 stars 14 forks source link

Support for Snowflake MFA for data reconsiliation #120

Open nsenno-dbr opened 7 months ago

nsenno-dbr commented 7 months ago

Snowflake supports username/password authentication as well as MFA. Currently, the data recon tool only leverages the former. Many large enterprise customers leverage MFA and would not want to create a service account strictly with username/password.

Note that the Spark Snowflake connector supports sso authentication as well as pem key authentication

https://community.snowflake.com/s/article/How-to-connect-to-Snowflake-with-Spark-connector-via-SSO

sundarshankar89 commented 6 months ago

@ganeshdogiparthi-db FYI.