hasura / graphql-engine

Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
https://hasura.io
Apache License 2.0
30.98k stars 2.75k forks source link

Support: Add Encrypted Key Support to Snowflake Connector #10115

Open meetzaveri opened 6 months ago

meetzaveri commented 6 months ago

Is your proposal related to a problem?

Currently, snowflake connector only provides support for non-encrypted keys not encrypted keys.

Describe the solution you'd like

As per this snowflake doc, it provides private key support with p8 file access. So essentially, user can pass a file path to their private key file with encrypted key(p8) and passphrase alongside.

Support for this in Hasura would be crucial in case where user is looking to pass encrypted key file (p8) path as private key alongside passphrase for encrypted key.

meetzaveri commented 5 months ago

Update:

Support for encrypted private keys in JDBC auth mechanism for snowflake source has been added in 2.37.0 . Full changelog here - https://hasura.io/changelog/enterprise-edition/v2.37.0

krisiye commented 5 months ago

Thanks! Did some brief validation and works as expected. Thank you!