`"Snowflake error: A password must be specified"` in CLI after updating CLI

[IrakliJani]

Description

After updating to npm [email protected], the user encountered a “Snowflake error: A password must be specified” when running queries in developer preview mode. The same error occurs in the terminal when using Lightdash commands. Rolling back to npm [email protected] resolves the terminal error, but the UI (developer preview) still shows the issue.

Steps to Reproduce the Bug or Issue

1. Update to npm [email protected].
2. Run any Lightdash command in the terminal.
3. Observe the Snowflake error.
4. Roll back to npm [email protected].
5. Reproduce the error in the UI (after preview deploy).

version

No response

Cloud or self-hosting

None

[IrakliJani]

dbt debug connection succeeds

profiles.yml example:

(note that it has no password field but it uses private key authentication)

default:
  target: prod
  outputs:
    prod:
      type: snowflake
      account: <account_name>
      user: <user_name>
      private_key_path: <private_key_path>
      private_key_passphrase: <private_key_passphrase>
      role: TRANSFORM
      database: dbt
      warehouse: elt_xs
      schema: dbt
      threads: 8
      client_session_keep_alive: False

[lightdash-bot]

This issue was mentioned by a user in slack: https://lightdash.slack.com/archives/C053ESBT36V/p1728763711048399?thread_ts=1728763711.048399&cid=C053ESBT36V

[IrakliJani]

I’ve been able to reproduce this.

most possible solution:

changing private_key_passphrase: to: private_key_passphrase: ""