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