Key-pair authentication for Snowflake

[radeusgd]

Apart from the OAuth flow (#12011) we also want users to rely on key-pair authentication when connecting to Snowflake.

• Allow Snowflake connection to take a private key file from disk to use when connecting.
• Allow Snowflake connection to take an Enso_Secret that contains the private key.
• Create a helper method that generates the key-pair and stores the private key as an Enso_Secret and the public key as an Enso_File next to it.
  • It should have instructions how to set up the public key in Snowflake: https://docs.snowflake.com/en/user-guide/key-pair-auth#assign-the-public-key-to-a-snowflake-user

[enso-bot]

Radosław Waśko reports a new STANDUP for yesterday (2025-02-06):

Progress: Finished the error handling PR. Implemented basic key-pair auth for Snowflake. It should be finished by 2025-02-11.

Next Day: Next day I will be working on the same task. Implement key-pair generation for Snowflake auth.

[enso-bot]

Radosław Waśko reports a new STANDUP for today (2025-02-07):

Progress: Implemented key pair generation, with visuallization helping how to finish the setup. Fixed passing private key to Snowflake JDBC. It should be finished by 2025-02-11.

Next Day: Next day I will be working on the same task. Fix using local private key with passkey. Add some testing.

[enso-bot]

Radosław Waśko reports a new STANDUP for yesterday (2025-02-10):

Progress: Working on testing key-pair auth. Implemented test scenario for the Cloud key-pair flow. It should be finished by 2025-02-11.

Next Day: Next day I will be working on the same task. Add tests for local, Fix using local private key with passkey.

[enso-bot]

Radosław Waśko reports a new STANDUP for yesterday (2025-02-11):

Progress: Added tests for local key pair, generating a test key pair using Snowflake Java utils. Key generated using openssl seems to still not work if encrypted with passphrase. Tried upgrading to newer Snowflake JDBC but that didn't seem to help. After all added a better error message recommending to prefer the Cloud flow that is guaranteed compatible. Created some benchmarks for Table tests. It should be finished by 2025-02-11.

Next Day: Next day I will be working on the same task. Some more work on benchmarks, then next tasks.

[enso-bot]

Radosław Waśko reports a new STANDUP for yesterday (2025-02-12):

Progress: Investigated an issue with failing tests on the key-pair auth PR. Found #12266 bug and implemented a workaround to try pass the tests. Added a few more benchmarks, and verified some assertions. Trying to add more data to the generated XML report. It should be finished by 2025-02-13.

Next Day: Next day I will be working on the #12138 task. Start next task.