Key-pair auth

[GClunies]

First, thanks for developing this adapter and making Snowflake in Harlequin possible!

Wondering if you know how to configure a connection using key-pair authorization? I have tried a connection string in my harlequin.toml like

default_profile = 'mp_profile'

[profiles.mp_profile]
limit = 500
adapter = "adbc"
conn_str = "my_user@my_account&auth_type=auth_jwt&jwt_private_key=/home/my_user/.keys/snowflake/my_rsa_key.p8&jwt_private_key_pkcs8_password=my-password"
driver_type= "snowflake"

But I get the error

❯ harlequin
╭─ Harlequin could not connect to your database. ─╮
│ INVALID_ARGUMENT: 260002: password is empty     │
╰─────────────────────────────────────────────────╯

NOTE: 1 of 2 errors shown. Run with textual run --dev to see all errors.

I shouldn't need my password if using key pair auth?

Normally I would just create a a password and be done with this, but my employer prefers key-pair.

[TylerHillery]

Thank you for raising this issue! I was able to recreate it on my end. Will try to figure what's going on here. I hoping it's a matter of just getting the URI right.

[TylerHillery]

Still struggling to figure out root cause. FYI It might be awhile until I have the time to figure out what's going wrong here.