Describe the bug
I am getting azure.core.exceptions.ClientAuthenticationError when querying TableClient that is initialized with TableClient.from_table_url() method when using azure-data-tables = "12.4.2". The error does not occur for azure-data-tables = "12.4.1"
I am not getting the error when the TableClient is initialized with constructor.
The traceback:
Traceback (most recent call last):
File "/home/marek/temp/datatables/.venv/lib/python3.9/site-packages/azure/data/tables/_models.py", line 360, in _get_next_cb
return self._command(
File "/home/marek/temp/datatables/.venv/lib/python3.9/site-packages/azure/core/tracing/decorator.py", line 78, in wrapper_use_tracer
return func(*args, **kwargs)
File "/home/marek/temp/datatables/.venv/lib/python3.9/site-packages/azure/data/tables/_generated/operations/_operations.py", line 985, in query_entities
raise HttpResponseError(response=response, model=error)
azure.core.exceptions.HttpResponseError: Operation returned an invalid status 'Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.'
Content: {"odata.error":{"code":"AuthenticationFailed","message":{"lang":"en-US","value":"Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.\nRequestId:8d1cc3c1-c002-00e9-19be-45e901000000\nTime:2023-02-21T06:33:41.8347647Z"}}}
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/marek/temp/datatables/datatables/app.py", line 40, in <module>
df = load_table_from_url()
File "/home/marek/temp/datatables/datatables/app.py", line 19, in load_table_from_url
return query_table(table_service)
File "/home/marek/temp/datatables/datatables/app.py", line 14, in query_table
return pd.DataFrame.from_records(entities)
File "/home/marek/temp/datatables/.venv/lib/python3.9/site-packages/pandas/core/frame.py", line 2297, in from_records
first_row = next(data)
File "/home/marek/temp/datatables/.venv/lib/python3.9/site-packages/azure/core/paging.py", line 132, in __next__
return next(self._page_iterator)
File "/home/marek/temp/datatables/.venv/lib/python3.9/site-packages/azure/core/paging.py", line 76, in __next__
self._response = self._get_next(self.continuation_token)
File "/home/marek/temp/datatables/.venv/lib/python3.9/site-packages/azure/data/tables/_models.py", line 371, in _get_next_cb
_process_table_error(error)
File "/home/marek/temp/datatables/.venv/lib/python3.9/site-packages/azure/data/tables/_error.py", line 203, in _process_table_error
_reraise_error(decoded_error)
File "/home/marek/temp/datatables/.venv/lib/python3.9/site-packages/azure/data/tables/_error.py", line 190, in _reraise_error
raise decoded_error.with_traceback(exc_traceback)
File "/home/marek/temp/datatables/.venv/lib/python3.9/site-packages/azure/data/tables/_models.py", line 360, in _get_next_cb
return self._command(
File "/home/marek/temp/datatables/.venv/lib/python3.9/site-packages/azure/core/tracing/decorator.py", line 78, in wrapper_use_tracer
return func(*args, **kwargs)
File "/home/marek/temp/datatables/.venv/lib/python3.9/site-packages/azure/data/tables/_generated/operations/_operations.py", line 985, in query_entities
raise HttpResponseError(response=response, model=error)
azure.core.exceptions.ClientAuthenticationError: Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.
RequestId:8d1cc3c1-c002-00e9-19be-45e901000000
Time:2023-02-21T06:33:41.8347647Z
ErrorCode:AuthenticationFailed
Content: {"odata.error":{"code":"AuthenticationFailed","message":{"lang":"en-US","value":"Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.\nRequestId:8d1cc3c1-c002-00e9-19be-45e901000000\nTime:2023-02-21T06:33:41.8347647Z"}}}
To Reproduce
Using Poetry pyproject.toml:
[tool.poetry]
name = "datatables"
version = "0.1.0"
description = ""
authors = ["Joe Doe <joe@doe.com>"]
[tool.poetry.dependencies]
python = "^3.9"
azure-core = "^1.26.3"
azure-data-tables = "12.4.2"
azure-identity = "^1.12.0"
pandas = "^1.5.3"
[build-system]
requires = ["poetry-core"]
build-backend = "poetry.core.masonry.api"
Python code:
import pandas as pd
from azure.identity import AzureCliCredential
from azure.data.tables import TableClient
SAS_URL = 'sas_url_to_dummy_table'
TABLE_NAME = 'DummyTable'
def query_table(table_service: TableClient):
entities = table_service.query_entities(
query_filter='PartitionKey eq @pk',
parameters={'pk': 'dummy-pk'},
)
return pd.DataFrame.from_records(entities)
def load_table_from_url():
table_service = TableClient.from_table_url(SAS_URL)
return query_table(table_service)
def load_table_with_credential(credential):
table_service = TableClient(
endpoint='https://dummy.table.core.windows.net/',
table_name=TABLE_NAME,
credential=credential,
)
return query_table(table_service)
if __name__ == '__main__':
credential = AzureCliCredential()
# This works for both azure-data-tables 12.4.2 and 12.4.1
df = load_table_with_credential(credential)
print(df.head())
# This works ONLY for azure-data-tables 12.4.1
df = load_table_from_url()
print(df.head())
Expected behavior
Querying table client constructed in any way does not result in azure.core.exceptions.ClientAuthenticationError when the user has sufficient access rights.
Additional context
Tested only for Python 3.9.14 and 3.10.7.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4