search

apache / arrow-adbc

Database connectivity API standard and libraries for Apache Arrow
https://arrow.apache.org/adbc/
Apache License 2.0
385 stars 98 forks source link

Invalid username or password when connecting to Snowflake #1644

Open jaceksan opened 8 months ago

jaceksan commented 8 months ago

What would you like help with?

Following your DOC, trying to connect to Snowflake:

uri = snowflake://<user>:<pwd>@<account>/<db_name>?warehouse=<warehouse_name>
with adbc_driver_snowflake.dbapi.connect(uri) as connection:
  ...

It returns the error invalid username or password. When I use the same properties (user/pwd/account/warehouse/db) in DB IDE (DBeaver, Datagrip), it works.

Is it possible that the above URI is not parsed as I expected and the wrong password value is sent to the server? I tried other documented variants of the URI format, but I still got the same error.

Any advice, please?

lidavidm commented 8 months ago

The URI examples in the docs don't have snowflake:// prefix.

jaceksan commented 8 months ago

I am so sorry for bothering you with this :facepalm: Now it works end-to-end including fetching data to Arrow :smile:

Thanks for the quick response!

lidavidm commented 8 months ago

Cool. If other Snowflake clients support this, you may want to ask the Snowflake Go client to support this too (we're just passing the URL to their library - not parsing it ourselves).