PERMISSION_DENIED when using a Glue data source but not from AwsDataCatalog

0

I am testing a Glue data source for Athena has been configured to point to the catalog ID of the same account (i.e. in AccountA I have "Data-Lake" that points to catalog id: AccountA).

When querying a Delta Lake table using the built-in "AwsDataCatalog" I have no problems executing the query.

When I query an Athena configured "Data Source" which points to the account's own Glue Catalog, the same query fails with:

PERMISSION_DENIED: Cannot query Delta Lake table 'aurora_raw.REDACTED'
This query ran against the "aurora_raw" database, unless qualified by the query. Please post the error message on our forum 
or contact customer support 
with Query Id: 1063bc93-93b3-4c4f-b295-abd2b4fd36c7

Within the same account I would expect both of these Data Sources in Athena to use the same IAM role/policy. Interestingly enough the enumeration of tables and databases from Glue Data Catalog works just fine, it's only when executing the Athena query does anything behave differently between 'AwsDataCatalog' and my 'Data-Lake' catalog

rtyler
質問済み 8ヶ月前100ビュー
回答なし

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ