- Newest
- Most votes
- Most comments
Based on the error message and the information provided, it appears that there are a few issues at play:
-
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.
-
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.
-
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:
-
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.
-
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.
-
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.
-
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.
-
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
Relevant content
asked 2 years ago
