Stay up to date with the latest from the Knowledge Center. See all new Knowledge Center articles published in the last month, and re:Post’s top contributors.
All Content tagged with Amazon Athena
Start querying data instantly. Get results in seconds. Pay only for the queries you run.
Content language: English
Filter content
Select tags to filter
Sort by
Sort by most recent
1312 results
Hello, I have Athena configured to query data from a S3 access point. The underlying bucket for the S3 access point is located in a different aws account, and the s3 bucket also has Requester Pays ena...
Hi AWS Support,
When I try to create an Athena table based on a Delta Lake table stored in S3, I encounter an unexpected error. I'm not sure what’s causing it, especially since I've successfully crea...
Athena query by partition column returns an error on hive partitioned table (vpc flow logs) - getting a message as column not found - I provided all the permissions for glue & athena - looks like its ...
```
CREATE TABLE demo_s3_table (
sale_date date,
product_category string,
sales_amount double)
PARTITIONED BY (month(sale_date))
TBLPROPERTIES ('table_type' = 'iceberg')
-- this will work
ALTER TABLE...
I've been playing around with DuckDB-Iceberg and S3 Tables. I've forked duckdb-iceberg and am trying to implement some stuff on my own for fun. I've managed to create a table in s3 tables using DuckDB...
Access denied when writing output to url: s3://aws-athena-query-results-prod-khatabook/Unsaved/2025/09/22/b7869080-3df0-4cc9-bc31-614298c7455e.csv . Please ensure you are allowed to access the S3 buck...
I have a S3 tables bucket with tables. In Athena, I can add columns to those tables this way:
```
ALTER TABLE some_database.some_table
ADD COLUMNS (
test_bigint bigint
);
```
The previous query wor...
Edward O.EXPERT
published 23 days ago0 votes125 views
I want to query my Amazon CloudWatch Logs exports in S3 using Amazon Athena, but I need help exporting the logs to S3 and creating the appropriate Athena table structure.
Edward O.EXPERT
published a month ago0 votes102 views
Amazon Inspector generates complex JSON findings reports that are difficult to analyze directly due to nested data structures and parsing challenges. This guide demonstrates how to effectively analyze...
# Short description:
Athena queries on ALB access logs suddenly started returning NULL for all fields (except partitioned ones) since 2025/08/19.
# Problem detail:
Athena queries on ALB access logs...
I have a set of iceberg tables in my Glue catalog in eu-west-1, pointing to a datalake also in eu-west-1. I'm wanting to create duplicate copies of the tables in my Glue catalog in eu-west-2. I've the...
My account has the S3Tables analytics service integration enabled. I am using the Grafana plugin athena-data-source to query Amazon Athena, which is currently not able to use s3tables catalogs, becaus...