apache / apache/iceberg-python

Cross account lakeformation tables in AWS

未關閉
#3,244 0 則留言 0 個 reaction 已指派 0 人 在 GitHub 檢視
主要語言
Python
星號
1.1k
分支
581
平均合併
1 天 13 小時
30 天內合併 PR
76

描述

### Apache Iceberg version

0.11.1

### Please describe the bug 🐞

We have our datalake that is apache iceberg format that is governed by lakeformation (account A). We have various other AWS accounts that are trying to read in a lambda using pyiceberg.

All boto3 calls to fetch the data work correctly, to me verifying that the IAM permissions and Lake formation permissions are correct. Additionally boto3 athena calls are successful. However when pyiceberg, it fails with the following error:

`[ERROR] ForbiddenError: RESTError 403: Received unexpected JSON Payload:
{
"error": {
"code": 403,
"type": "AccessDeniedException"
}
}
, errors: Field required
Traceback (most recent call last):
File "/var/task/lambda_function.py", line 38, in lambda_handler
results = fetch_dataset()
File "/var/task/lambda_function.py", line 64, in fetch_dataset
table = catalog.load_table("curated_sales_and_policy.ods_agent")
File "/opt/python/lib/python3.13/site-packages/tenacity/__init__.py", line 331, in wrapped_f
return copy(f, *args, **kw)
File "/opt/python/lib/python3.13/site-packages/tenacity/__init__.py", line 470, in __call__
do = self.iter(retry_state=retry_state)
File "/opt/python/lib/python3.13/site-packages/tenacity/__init__.py", line 371, in iter
result = action(retry_state)
File "/opt/python/lib/python3.13/site-packages/tenacity/__init__.py", line 393, in
self._add_action_func(lambda rs: rs.outcome.result())
File "/var/lang/lib/python3.13/concurrent/futures/_base.py", line 449, in result
return self.__get_result()
File "/var/lang/lib/python3.13/concurrent/futures/_base.py", line 401, in __get_result
raise self._exception
File "/opt/python/lib/python3.13/site-packages/tenacity/__init__.py", line 473, in __call__
result = fn(*args, **kwargs)
File "/opt/python/lib/python3.13/site-packages/pyiceberg/catalog/rest/__init__.py", line 921, in load_table
_handle_non_200_response(exc, {404: NoSuchTableError})
File "/opt/python/lib/python3.13/site-packages/pyiceberg/catalog/rest/response.py", line 111, in _handle_non_200_response
raise exception(response) from exc`

here is the relevant piece of code:
` catalog = load_catalog(
"glue_rest",
**{
"type": "rest",
"uri": "https://glue.us-east-2.amazonaws.com/iceberg",
"warehouse": "account_A_account_number",
"rest.sigv4-enabled": "true",
"rest.signing-region": "us-east-2",
"rest.signing-name": "glue",
}
)

table = catalog.load_table("database1.table1")`

here is our settings:
AccountA:
- lakeformation describe on Database
- lakeformation describe, select on relevant tables
- have a proper data location access resource create in lakeformation granting the execution role the appropriate access

AccountB:
- lambda execution role has glue:* and lakeformation:GetDataAccess

Just to note, the catalog is created successfully and doesn't throw an error, but it does when we specifically on load_table()

I've tried troubleshooting by playing with the headers being sent and messing with the header value sig4-enabled. Nothing seems to work.

Does anyone have a working example and the configuration you are using? Is this support with the current version (we are on latest 0.11.1).

Any help would be appreciated. I can provide additional information if needed.

### Willingness to contribute

- [ ] I can contribute a fix for this bug independently
- [x] I would be willing to contribute a fix for this bug with guidance from the Iceberg community
- [ ] I cannot contribute a fix for this bug at this time

貢獻指南

這個儲存庫沒有索引到貢獻指南

研究方向

從 pyiceberg/catalog/rest/__init__.py 中的 load_table() 開始,接著檢查 pyiceberg/catalog/rest/response.py 及其 _handle_non_200_response 路徑。使用 issue 中描述的設定與權限重現跨帳戶 Lake Formation 請求。當 load_table() 能夠成功存取跨帳戶資料表,或 403 回應能以正確原因回報時,即表示完成。

由索引模型根據 Issue 內容生成。

評估

技術堆疊
aws, python
領域
cloud, databases
Issue 類型
缺陷
難度
4/5
預估耗時
3-5 天
活躍度
冷清
描述清晰度
需要釐清
新手友好度
38/100

把新 issue 寄到你的電子郵件信箱

精選適合新手參與的 GitHub issue 摘要。