Help improve AWS Support Official channel in re:Post and share your experience - complete a quick three-question survey to earn a re:Post badge!
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 tags to filter
Sort by most recent
1259 results
Im using Redshift serverless to access tables in glue catalog and s3 in a different account (same region eu-west-1)
I already have access to those tables using my account glue and athena
In the othe...
Hi,
I am looking to compute the total size of my files per year inside a given S3 bucket. I have been trying multiple methods:
- I tried to use a goto3 script but I constantly ran into issues or inco...
We currently have some data in S3 that we query using Athena, we are looking into creating a datalake with tabular data (we call aggregated data) which is created by joining multiple tables using Athe...
I have a datetime[ms, UTC] parquet column I write to s3. In Athena if I `unload` it, redundantly casting to timestamp(3) (Trino datatype) the VS Code extension "DataWrangler" confirms it is a datetime...
Hi,
I have a S3 bucket that will act as a data lake with athena as query engine. A lot of the data is unsigned bytes.
I know that athena represents all integers as signed which would not be a proble...
Getting the below error while querying Redshift table from Athena.
GENERIC_INTERNAL_ERROR: Malformed request: ERROR: column "internal" does not exist in table *****
This query ran against the "public...
I'm encountering an issue while querying an Iceberg table in Athena. The table schema is successfully detected in the Glue Catalog, and the Glue crawler runs without errors. However, when attempting t...
When executing show create table on an iceberg table.
The table created by spark app.
CREATE TABLE statement cannot be generated because table has unsupported properties.
This query ran against the "...
I connected Cloudtrail Lake with Athena. In Athena I get this table. From QuickSight I want to create a dataset and use the Athena connector however I get error message:
Your database generated a SQL...
I deployed the cid dashboard. i want to the data for last three month. Is there a way to bring the data manually from me. Or should i need to create support case
EXPERT
published 16 days ago0 votes122 views
Apache Iceberg is gaining popularity as a high-performance table format for large analytical datasets. In this guide, we'll walk through how to effectively query Iceberg tables using Amazon Athena.
I have a s3 table bucket and I am using PySaprk and Apache Iceberg to write data to the bucket.
df.writeTo("s3tablesbucket.stg.sgsbi_dbo_splusorders2") \
.partitionedBy("report_date") \
.createOr...