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
asked 8 months ago98 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions