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
1116 results
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 a month 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...
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...
Hi,
My Athena Query to transform the data is failing randomly with the error:
Exception: Final state of Athena job is FAILED, query_execution_id is 97b49928-68f8-44e0-af7e-1fc7ec7cefcb. Error:...
AWS OFFICIALUpdated 2 months ago2 votes1565 views
The following query returns an error
```
SELECT * from UNNEST(SEQUENCE(
(SELECT min(col1) from table1),
current_date,
INTERVAL '1' DAY
))
```
but this query works just...
Currently, I am using the spark hudi deltastreamer job to read CSV and write to the hudi table. Additionally, sync the s3 bucket with the AWS glue catalog. Deltastreamer job creates 2 tables...
I'm trying out the new preview of Firehose writing to Athena Iceberg tables.
I'm publishing to Firehose with the following body, which works fine:
```
{
"ADF_Record": {
"user_id":...
Getting an error with code INTERNAL_ERROR_QUERY_ENGINE, there are no additional details in the error message. Has anyone run into this before?