Bug: Snowflake private key authentication fails with MissingParameterError: A password must be specified
Steps to reproduce:
- Attempt to add a Snowflake warehouse connection using private key authentication
- Provide:
private_key (path or content), private_key_passphrase, account, user, database, schema, warehouse, role - Run
warehouse_test on the connection - Expected: Connection succeeds using private key authentication
- Actual: Error:
MissingParameterError: A password must be specified
Additional context:
- The private key is encrypted (BEGIN ENCRYPTED PRIVATE KEY)
- Password/passphrase authentication works fine for this user in other tools
- Tried multiple config variations including setting
authenticator: "snowflake_login" and empty password - The underlying library appears to always require a
password field even when using private key auth
Metadata
| Field | Value |
|---|
| CLI Version | 0.0.0-main-202603181556 |
| Platform | darwin |
| Architecture | arm64 |
| OS Release | 24.6.0 |
| Category | bug |
| Working Directory | altimate-code |
| Session ID | ses_2fe5683e7ffecSmuZCQPh1Emwz |
Bug: Snowflake private key authentication fails with
MissingParameterError: A password must be specifiedSteps to reproduce:
private_key(path or content),private_key_passphrase,account,user,database,schema,warehouse,rolewarehouse_teston the connectionMissingParameterError: A password must be specifiedAdditional context:
authenticator: "snowflake_login"and empty passwordpasswordfield even when using private key authMetadata