torbjoernk opened a new issue, #2543:
URL: https://github.com/apache/arrow-adbc/issues/2543
### What happened?
I have a functional script to query data from a Snowflake database - at
least it's functional when running on Windows.
As soon as I run it within a Linux-based container, it fails due to
authentication issues. I'm using the same credentials.
I also tried using the Snowflake CLI within an Ubuntu container with the
same credentials and it failed as well.
### Stack Trace
When run within a Linux-based container:
```
ERRO[0000]auth.go:364 gosnowflake.authenticate Authentication FAILED
Traceback (most recent call last):
File "/src/api/data_importers/pppm_data_collector.py", line 305, in
<module>
asyncio.run(_test(True))
File "/usr/local/lib/python3.12/asyncio/runners.py", line 194, in run
return runner.run(main)
^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/asyncio/runners.py", line 118, in run
return self._loop.run_until_complete(task)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/asyncio/base_events.py", line 687, in
run_until_complete
return future.result()
^^^^^^^^^^^^^^^
File "/src/api/data_importers/pppm_data_collector.py", line 299, in _test
await rdc.update_local_data_thread() # Runs the code in a separate
thread
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/src/api/data_importers/base_importer_class.py", line 304, in
update_local_data_thread
await asyncio.to_thread(asyncio.run,
self.update_local_data_async(time_horizon))
File "/usr/local/lib/python3.12/asyncio/threads.py", line 25, in to_thread
return await loop.run_in_executor(None, func_call)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 58, in
run
result = self.fn(*self.args, **self.kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/asyncio/runners.py", line 194, in run
return runner.run(main)
^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/asyncio/runners.py", line 118, in run
return self._loop.run_until_complete(task)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/asyncio/base_events.py", line 687, in
run_until_complete
return future.result()
^^^^^^^^^^^^^^^
File "/src/api/data_importers/pppm_data_collector.py", line 269, in
update_local_data_async
adbc_sf.connect(snowflake_master_data_uri) as snowflake_master_conn,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"/home/pc/.venv/lib/python3.12/site-packages/adbc_driver_snowflake/dbapi.py",
line 120, in connect
conn = adbc_driver_manager.AdbcConnection(db, **(conn_kwargs or {}))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "adbc_driver_manager/_lib.pyx", line 705, in
adbc_driver_manager._lib.AdbcConnection.__init__
File "adbc_driver_manager/_lib.pyx", line 260, in
adbc_driver_manager._lib.check_error
adbc_driver_manager.OperationalError: IO: 390100 (08004): Incorrect username
or password was specified.
```
When run within an k8s cluster, the stack trace is the same, but the final
error message is slightly different:
```
adbc_driver_manager.OperationalError: IO: 390201 (08004): The requested
warehouse does not exist or not authorized.
```
### How can we reproduce the bug?
_No response_
### Environment/Setup
Python 3.12.8
adbc-driver-manager 1.4.0
adbc-driver-snowflake 1.4.0
--
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: issues-unsubscr...@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
