SQLPro icon indicating copy to clipboard operation
SQLPro copied to clipboard

Add proxy params to Snowflake connection advanced parameters

Open chrischain opened this issue 8 months ago • 4 comments

Is your feature request related to a problem? Please describe. YES - I cannot connect to a Snowflake resource that requires a proxy connection.

Describe the solution you'd like I would like proxyHost, proxyPort, and useProxy parameters added to the advanced parameters for Snowflake connections.

Describe alternatives you've considered I currently cannot connect to the resource at all using SQLPro Studio. I am using the Snowflake web interface instead.

Additional context I was given instructions by my company to set up the connections using DBeaver, so I know that application has the capability to connect this way. For that application, the proxy settings I mentioned above are added in the Driver Properties tab of the Connection Settings dialog.

Image

Environment (please complete the following information):

  • Device: MacBook Pro M1 Max
  • OS: MacOS Sequoia 15.5
  • SQLPro app Version: SQLPro Studio 2025.10 (Build 111122.5)
  • Installation source: App Store
  • Target database server: Snowflake (proxied)

chrischain avatar Jun 18 '25 20:06 chrischain

Hmm, I think I tried adding parameters for snowflake once (https://github.com/hankinsoft/SQLPro/issues/661) at least for a debug build, but I’m not sure if I ever actually enabled that option for release builds. I’m away from my Mac at the moment but when I get back I’ll take a look and see.

hankinsoft avatar Jun 18 '25 21:06 hankinsoft

Just as a note, I've investigated this and found that the current snowflake library I use does not support these parameters. I'm investigating updating to a different library to see what options are available.

hankinsoft avatar Jun 24 '25 19:06 hankinsoft

Hi, I've been working on some snowflake improvements and wanted with ask - with snowflake disabling password authentication, what type of authentication do you plan on using going forward? OAuth?

hankinsoft avatar Aug 18 '25 18:08 hankinsoft

PAT seems the easiest method to use as opposed to OAuth. But I have the option to use either.

chrischain avatar Aug 19 '25 19:08 chrischain