All Content tagged with Amazon Athena

I have a s3 dataset that is cataloged in Glue. A new column was added to the s3 data and the crawler was re-crawled that updated the glue table definition to add the new column. This new column is vis...

I am using Athena federated query with a Glue table to query IOT Data stored in Document DB. The time format reported by IOT sensors is ISO 8601 (here the entry from DocumentDB "time" : "2024-11-20T0...

Hi, I have a question regarding the performance of using a partitioned table. I need to do left join of two tables, lets say A and B. A is 8 GB and B is 60 GB. I was able to run the left join in arou...

For Cloud Intelligence Dashboards (CID) we're migrating from CUR to CUR 2.0, which the official documentation (https://catalog.workshops.aws/awscid/en-US/dashboards/foundational/cudos-cid-kpi/migrate-...

Hi, I have a column with value in the format of HH:MM:SS so according to the documentation: https://docs.aws.amazon.com/athena/latest/ug/data-types-timestamps.html i should use time column however, i ...

I see DDL and DML queries in [Athena Service Quotas](https://docs.aws.amazon.com/athena/latest/ug/service-limits.html), but UTILITY queries are absent. According to the [docs](https://docs.aws.amazon...

Further to the [AWS documentation ](https://docs.aws.amazon.com/athena/latest/ug/security-iam-cross-account-glue-catalog-access.html#security-iam-cross-account-glue-catalog-access-additional-s3-permis...

How can I fix this error in Athena when using mysql connector: GENERIC_USER_ERROR: Encountered an exception[java.lang.RuntimeException] from your LambdaFunction[arn:aws:lambda:eu-west-2:050253647064:...

Hi team, I used a Python script in GLUE to extract data from one of my S3 buckets, transform it, and load it into another bucket. Then, I manually created a table in the data catalog with four partiti...

Hello, I'm facing an issue with Amazon QuickSight where it's not able to find any Athena tables. Here are the details: My data source is located in the same region as QuickSight. I have granted admi...

Hey everyone, we are trying to query AWS CloudTrail logs in Athena but there seems to be missing information when we run the queries. We are able to confirm all the data is there in the S3 json.gz f...

Hello, I recently enabled the split cost allocation data feature in my AWS CUR export to utilize the SCAD dashboard on QuickSight. However, I'm having trouble locating the split cost columns in the AW...