By using AWS re:Post, you agree to the AWS re:Post Terms of Use

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
1157 results
Hello, I'm trying to use the S3 Metadata feature released this week. To do that, I've created an S3 Table Bucket in us-east-1, and configured my bucket to push its metadata to said table. I've also m...
1
answers
0
votes
59
views
asked 2 days ago
Hello AWS Community, I'm aiming to improve the user experience for our team when querying data in Amazon Athena. Specifically, I want to display the most recent data update time, based on the actual ...
1
answers
0
votes
16
views
asked 3 days ago
am getting an unexpected folder on S3 between my data/ and my first partition root_account_uuid=x The path appears to be unique for each time firehose sync's its buffered data to S3. I am using a lamb...
1
answers
0
votes
43
views
asked 4 days ago
We run a query at a scheduled cadence and for the past couple of runs it has errored with the following: ``` Query exhausted resources at this scale factor. If a data manifest file was generated at '...
3
answers
0
votes
29
views
AWS
asked 4 days ago
We have been trying Firehose for Iceberg Tables. The source is Kinesis stream attached to DynamoDB tables with some Lambda processing in between. Table has been successfully filled by Firehose, but ...
1
answers
0
votes
35
views
asked 5 days ago
Running a Glue Crawler on json file with this structure: [ { "SoldTo": "647218", "ContainerId": 1691340, "Container": "Per Åges Badelandcontainer 2", "ContainerRe...
1
answers
0
votes
23
views
asked 7 days ago
**Problem Description**: I need to create a metadata mapping layer in AWS Glue for DynamoDB items without crawling the entire table. The goal is to enable querying DynamoDB through Athena while not kn...
2
answers
0
votes
37
views
asked 7 days ago
Hi, We are trying to insert/update/delete the data from Athena Iceberg table using AWS Lambda written in node js. Is there any SDK available for this, if not do we have to use AWS Firehose ...
1
answers
0
votes
32
views
asked 10 days ago
I was trying to build a Data pipeline with No-Code ETL using AWS Glue Studio, and I kept getting the error message "Node is Misconfigured", when I add the join node using Visual ETL (see attached). Un...
1
answers
0
votes
16
views
asked 11 days ago
AWS OFFICIAL
AWS OFFICIALUpdated 10 days ago0 votes67 views
This post discusses how you can build out an application that uses Amazon Q Business to query AWS Cost and Usage Reports (CUR) data in Amazon Athena.
9ac739e1-b195-4194-b37b-8026a8edd901 COLUMN_NOT_FOUND: line 1:8: SELECT * not allowed from relation that has no columns I thought it was something to do with my permissions so I fiddled around and r...
2
answers
0
votes
23
views
asked 11 days ago
Post-deployment of the CUDOS Dashboards, if you want to migrate to CUR 2.0, you have to deploy the Data Exports stack as found below https://catalog.workshops.aws/awscid/en-US/dashboards/foundational...
2
answers
0
votes
58
views
asked 12 days ago