search

TylerHillery / harlequin-adbc

An ADBC adapter for Harlequin
MIT License
2 stars 0 forks source link

Key-pair auth #5

Open GClunies opened 6 months ago

GClunies commented 6 months ago

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 commented 6 months ago

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 commented 5 months ago

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.