henryharbeck opened a new issue, #3455:
URL: https://github.com/apache/arrow-adbc/issues/3455
### What feature or improvement would you like to see?
While it is made clear that "not all drivers support all (database)
options.", it would be useful to improve availability where a given parameter
is applicable for the driver.
For example, I think all three of password, URI and username could be
supported for PostgreSQL. URI for Snowflake also seems reasonable (although I
am no Snowflake expert)
```python
>>> from adbc_driver_manager import DatabaseOptions
>>> import adbc_driver_snowflake
>>> import adbc_driver_postgresql
>>>
>>> sf_uri = "xxxxxxx"
>>> sf_database = adbc_driver_snowflake.connect(sf_uri)
>>>
>>> sf_database.get_option(DatabaseOptions.PASSWORD.value)
'xxx'
>>>
>>> sf_database.get_option(DatabaseOptions.URI.value)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "adbc_driver_manager/_lib.pyx", line 632, in
adbc_driver_manager._lib.AdbcDatabase.get_option
File "adbc_driver_manager/_lib.pyx", line 261, in
adbc_driver_manager._lib.check_error
adbc_driver_manager.ProgrammingError: NOT_FOUND: [Snowflake] Unknown
database option 'uri'
>>>
>>> sf_database.get_option(DatabaseOptions.USERNAME.value)
'xxx'
>>>
>>> pg_uri = "postgresql://postgres:postgres@localhost:5433"
>>> pg_database = adbc_driver_postgresql.connect(pg_uri)
>>>
>>> pg_database.get_option(DatabaseOptions.PASSWORD.value)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "adbc_driver_manager/_lib.pyx", line 632, in
adbc_driver_manager._lib.AdbcDatabase.get_option
File "adbc_driver_manager/_lib.pyx", line 261, in
adbc_driver_manager._lib.check_error
adbc_driver_manager.ProgrammingError: NOT_FOUND
>>>
>>> pg_database.get_option(DatabaseOptions.URI.value)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "adbc_driver_manager/_lib.pyx", line 632, in
adbc_driver_manager._lib.AdbcDatabase.get_option
File "adbc_driver_manager/_lib.pyx", line 261, in
adbc_driver_manager._lib.check_error
adbc_driver_manager.ProgrammingError: NOT_FOUND
>>>
>>> pg_database.get_option(DatabaseOptions.USERNAME.value)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "adbc_driver_manager/_lib.pyx", line 632, in
adbc_driver_manager._lib.AdbcDatabase.get_option
File "adbc_driver_manager/_lib.pyx", line 261, in
adbc_driver_manager._lib.check_error
adbc_driver_manager.ProgrammingError: NOT_FOUND
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
