EXTERNALBROWSER login doesn't work for snowflake

elixir-explorer / adbc

Apache Arrow ADBC bindings for Elixir

https://arrow.apache.org/adbc/

Apache License 2.0

50 stars 16 forks source link

EXTERNALBROWSER login doesn't work for snowflake #104

Open kwando opened 4 weeks ago

kwando commented 4 weeks ago

 {:ok, database} =
      Adbc.Database.start_link(
        driver: :snowflake,
        "adbc.snowflake.sql.account": account,
        "adbc.snowflake.sql.user":  username,
        "adbc.snowflake.sql.auth_type": "auth_ext_browser",
        "adbc.snowflake.sql.client_option.tracing": "debug"
      )

The browser window is opened but the redirect back to localhost seems to hang for some reason, something is running on localhost cause the browser window doesnt show an error until I kill the Elixir process. Any ideas?

cocoa-xu commented 4 weeks ago

Hi @kwando, Thanks for reporting this issue. I have some idea of what might cause it. I'll get a Snowflake trial account and test it!

kwando commented 4 weeks ago

Let me know if there is anything I can do to help!

cocoa-xu commented 1 week ago

So originally I suspected it might be Erlang/OTP putting the NIF thread in background or something so it wasn't responding, but it still got stuck after I did a little hack and put it into the main thread and let it block waiting there.

Wasn't quite sure if it was a bug in ADBC 13 but we've updated to ADBC 14 so it might be fixed. Sorry that I recently didn't have enough bandwidth to test this. Please let me know if using v0.6.4 fixes this issue.