Feature Request: Snowflake key-pair authentication

[slunsford]

Is your feature request related to a problem? Please describe.
Since enabling MFA, connecting or running any query results in multiple Duo prompts. I’ve gotten myself locked out of my account by not being able to respond to these fast enough. I have enabled key-pair authentication on my user but there is no way that I can see to use that key in SQLPro.

Describe the solution you'd like
The ability to select a key or to automatically use a key on my system, similarly to the SSH tunneling options. Maybe this already is supported somehow, but I have not had any success in configuring the connection that way.

Describe alternatives you've considered

• An alternative would be to support MFA caching, which would at least suppress authentication prompts on queries after the initial connection. I’ve also enabled this on the account, but does not seem to have an effect in SQLPro since I still have to authenticate on successive queries.
• Another alternative would be to create a legacy service account just for SQLPro, which could still support password-only authentication with no MFA. I’d prefer to avoid this as it reduces the overall security of our system.

Additional context
We set up security policies a while ago requiring MFA on all human (non-service) users and requiring key-pair authentication from service accounts. I believe this to be table-stakes security for the critical and sensitive business data in our Snowflake account. Snowflake has more recently announced this same policy being applied to all accounts in April, so at that point we couldn’t dial this back if we wanted to.

I’d mostly just stopped using SQLPro with Snowflake since this change because of the issues with MFA prompts, but I’d like to be able to pick it up again if this can be resolved.

Environment (please complete the following information):

• Device: MacBook Pro M1 Max 16"
• OS: macOS 15
• SQLPro app Version SQLPro Studio 2025.1
• Installation source: Setapp.
• Target database server: Snowflake

Requests will be closed until environmental details are provided.

[hankinsoft]

Sorry for the delay in reply. Let me investigate this a bit and see what I can come up with. SQLPro tends to use multiple connections for performance reasons but I can totally see how this would mess with MFA.