All Content tagged with Amazon Athena

Trying to have a Glue Crawler/Athena automatically pick up a timestamp format of `yyyy-MM-dd'T'HH:mm:ss.SSS'Z'`. I have confirmed all the values in my dataset are formatted as this format, example: ...

Hi everyone! I’ve been following this guide (https://aws.amazon.com/blogs/aws/simplify-custom-contact-center-insights-with-amazon-connect-analytics-data-lake/) to gather data from Amazon Connect and ...

We have loved the flexibility of the Athena engine, but are starting to get concerned about its instability. Recently we've identified needs to rerun major queries that return zero records the first t...

Hi, I am creating a table by `UNION ALL` 6 views with same schema. However, I am getting `INTERNAL_ERROR_QUERY_ENGINE` when executing the query. I tried to run just the `SELECT` parts without the `CR...

Athena runs all queries in a [shared regional cluster](https://athena.guide/articles/athena-basics-running-queries). When you submit a query, the Athena engine query planner estimates the compute ca...

I am experiencing timeout for my athena queries since yesterday. Sharing couple of queries here: Query 1: (ID:b4e3438a-2dce-4884-87f6-7e93f375ee86 ) Query 2: (ID: a8bc9d3b-f55c-4c61-ba66-d6bbe4f4a64f ...

We need help to get the data of shut down instances in all regions from the past 90 days on all member accounts from Management (root) account using Athena. We have a sample script but the script fai...

Dear members of the AWS community, I have been facing an issue for the past couple of days trying to setup AWS Managed Grafana workspace with Athena workgroup. The underlying reason why I want to do...

I was trying to connect to Athena using DBeaver with OKTA, when I was using the JDBC URL created base on the syntax on AWS documentaion, I experienced a SAML error like the one below: eclipse.buildId...

I am trying: select <expression that works> which produces results. But when I try to save it using: CREATE OR REPLACE VIEW my_view AS SELECT <same expression that works. I get the error: line 2...

I have 4 csvs that have same columns and I am able to crawl them as 1 data table. the issue I am facing is even after adding areColumnsQuoted = true I am seeing each column value enclosed with double...

I am trying to create a dashboard that will display the account name, region, and then total count of EC2 instances. I am having trouble listing the EC2 instances count. Looks like most of the options...