All Content tagged with Amazon Athena
Start querying data instantly. Get results in seconds. Pay only for the queries you run.
Content language: English
Select up to 5 tags to filter
Sort by most recent
I am new to Athena, and referred [this page](https://docs.aws.amazon.com/athena/latest/ug/connectors-docdb.html) to create Document DB connector.
**Background**: I had to create the lambda manually ...
* Setup like this is done: https://aws.amazon.com/blogs/big-data/bring-your-workforce-identity-to-amazon-emr-studio-and-athena/
* S3 Access point created
* Bucket Policy to allow access via AP given
*...
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...
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...
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...
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...
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...
asked 14 days ago
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...
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...