xiayanzheng commented on code in PR #21322: URL: https://github.com/apache/superset/pull/21322#discussion_r963678833
########## docs/docs/databases/snowflake.mdx: ########## @@ -29,3 +29,38 @@ user/role rights during engine creation by default. However, when pressing the button in the Create or Edit Database dialog, user/role credentials are validated by passing “validate_default_parameters”: True to the connect() method during engine creation. If the user/role is not authorized to access the database, an error is recorded in the Superset logs. + +And if you want connect Snowflake with [Key Pair Authentication](https://docs.snowflake.com/en/user-guide/key-pair-auth.html#step-6-configure-the-snowflake-client-to-use-key-pair-authentication). +Plase make sure you have the key pair and the public key is registered in Snowflake. +To connect Snowflake with Key Pair Authentication, you need to add the following parameters to "SECURE EXTRA" field. + +***Please note that you need to split your private key content line by line before store it to privatekey_body*** + +``` +{ + "auth_method": "keypair", + "auth_params": { + "privatekey_body":[ + "-----BEGIN ENCRYPTED PRIVATE KEY-----", + "Key Body", + "Key Body", + "Key Body", + "Key Body", + "-----END ENCRYPTED PRIVATE KEY-----" + ], + "privatekey_pass":"Your Private Key Password" + } +} +``` Review Comment: Thanks for your advice, I'm ok with both formats, and this change just pushed to this PR. -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
