Encountering an error while setting up a Snowflake database using a key pair. #31785
Unanswered
kgautamdev
asked this question in
Q&A / Help
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I'm trying to set up a Snowflake database connection using key-pair authentication. However, I'm encountering the following error: (snowflake.connector.errors.ProgrammingError) 251006: None: Password is empty.
Does Superset v0.36 support key-pair authentication for Snowflake?
could you guide me on how to configure it properly / workaround?
Below config i'm using
URI=snowflake://{user}@{account}/{database}?role={role}&warehouse={warehouse}
Secure Extra = {
"connect_args": {
"auth_method": "keypair",
"auth_params": {
"privatekey_body": "-----BEGIN ENCRYPTED PRIVATE KEY-----\nSDdfdf\ndfdf....\n-----END ENCRYPTED PRIVATE KEY-----",
"privatekey_pass":"pass_pwd"
}
}
}
Beta Was this translation helpful? Give feedback.
All reactions