Skip to content

Athena does not support required filtering based on approved permissions

0

I am running this query:

Select *
FROM "AwsDataCatalog"."andes"."csa-gamma.raw_page_latency"
WHERE (ingestion_time between timestamp '2024-12-12 19:00:00' and timestamp '2024-12-12 20:59:59')
AND entities like '%icdp-experience%'
AND entities like '%B005ECO9XI%'
limit 1000;

I get this error:

HIVE_METASTORE_ERROR: Based on approved permissions for the amzn:cdo:person:vwlee on csa-gamma.raw_page_latency, ATHENA does not support the required filtering, https://*********/bin/view/BDT/Products/BDTDMA/Dataconsumers/
 (Service: AWSGlue; Status Code: 400; Error Code: InvalidInputException; Request ID: 0f88c1ac-447b-478a-a9b1-adab9d1bad8e; Proxy: null)
This query ran against the "andes" database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query Id: 09802f2b-cdcb-414a-98df-0045580dfba4

I should already have permission to this dataset: https://datacentral.a2z.com/datashield/access-request/799482c4-ed15-43a6-bfc1-81609f52d384

Another note is that this table does not show up on my tables when I open Athena. Unsure if I am missing a step to add the table or something

asked 2 years ago333 views

1 Answer
0

Based on the error message and the information provided, it appears that there are a few issues at play:

  1. Permission Issue: Although you believe you should have permission to access this dataset, the error suggests that there might be a mismatch between your current permissions and what's required to query this specific table. The error mentions "Based on approved permissions for the amzn:cdo:person:vwlee on csa-gamma.raw_page_latency, ATHENA does not support the required filtering." This indicates that while you may have some level of access, it might not be sufficient for the query you're trying to run.

  2. Filtering Requirement: The error suggests that there's a required filtering mechanism in place that Athena doesn't support. This could be related to row-level security or other fine-grained access control measures implemented on the table.

  3. Table Visibility: You mentioned that the table doesn't show up in your Athena console. This could be due to a few reasons:

    • The table might not be properly registered in the AWS Glue Data Catalog.
    • Your IAM permissions might not allow you to list or see this particular table.
    • There might be additional steps required to make the table visible in your Athena environment.

To resolve these issues, you should consider the following steps:

  1. Double-check your permissions: Verify with your data or IAM administrator that you have the correct permissions not just to access the dataset, but specifically to query it through Athena. There might be additional IAM policies or Lake Formation permissions required.

  2. Investigate the filtering requirement: Consult with your data team or the owners of the "csa-gamma.raw_page_latency" table to understand if there are any specific filtering requirements or access controls in place that might be causing this issue.

  3. Verify table registration: Ensure that the table is properly registered in the AWS Glue Data Catalog and that you have permissions to view and query it.

  4. Check for any additional setup steps: There might be specific steps required to make the table visible and queryable in your Athena environment. This could involve updating catalog settings, workgroup configurations, or other Athena-specific setups.

  5. Consult internal resources: The error message provides a link to an internal resource (https://*********/bin/view/BDT/Products/BDTDMA/Dataconsumers/). This might contain valuable information about how to properly access and query this dataset.

If these steps don't resolve the issue, you should reach out to your organization's data team, Athena administrators, or AWS support for further assistance. They will be able to provide more specific guidance based on your organization's setup and policies.
Sources
Identity and access management in Athena - Amazon Athena
Resolve Athena 4xx, 5xx, permission, and quota errors | AWS re:Post

answered 2 years ago

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.