Questions tagged with Amazon Athena
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
I'm following the Well Architected Lab religiously: https://www.wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/cost-usage-report-dashboards/
When trying the create the CUDOS dashboards...
1
answers
0
votes
295
views
asked 9 months agolg...
I am working on a view in Athena, which requires being able to do the following, identify the time of each work experience, using the number of months, days and count how many jobs you have had in...
1
answers
0
votes
303
views
asked 9 months agolg...
I want to disable the 'Copy' button in Athena for an IAM role.
The Download permission is already denied for this role using 'aws:calledViaLast' condition. But the user can still copy data using the...
Accepted AnswerAmazon Athena
1
answers
0
votes
294
views
asked 9 months agolg...
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...
0
answers
0
votes
102
views
asked 9 months agolg...
We have a coupe instances of DocumentDB running and we are wanting to be able to visualize the data in Quicksight. We started down the path of using Athena Federated query outlined in this article:...
1
answers
0
votes
424
views
asked 9 months agolg...
If I have an athena table built on top of a s3 bucket whose objects are in the intelligent tiering storage class, is there anything to keep in mind? Will it still work?
1
answers
0
votes
798
views
asked 9 months agolg...
Hi,
The environment is, there are multiple JSON files in a S3 bucket. I would like to add all of them to the Athena Table with the filtered values. I used the ChatGPT for the Athena query to create...
2
answers
0
votes
3038
views
asked 9 months agolg...
Say I have a s3 bucket with json files in the following format:`s3://bucket_name/logs/region={region}/year={year}/month={month}/day={day}/hour={hour}/`
I would like to use partition projection on...
1
answers
0
votes
701
views
asked 9 months agolg...
Hello
I am getting a timeout when trying to connect to Athena through JDBC (I am using squirrel client)
java.util.concurrent.TimeoutException
at...
1
answers
0
votes
253
views
asked 9 months agolg...
Hello
I have been trying to setup a jdbc connection to Amazon Athena but my connection gets hung. Below is the line at which connection just hangs
Sep 06 23:34:24.281 TRACE 291...
1
answers
0
votes
284
views
asked 9 months agolg...
How to restrict a user from downloading Athena query results, and prevent them from uploading files directly to the Athena results bucket? User should still be able to run query in Athena and see the...
Accepted AnswerAmazon Athena
1
answers
0
votes
645
views
asked 9 months agolg...
I am still learning to use the Glue ETL process for building new aggregate tables and need help optimizing my ETL job.
My ETL job is designed to run once per day in the mornings and pull in all the...
1
answers
0
votes
389
views
asked 9 months agolg...