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...
0
answers
0
votes
11
views
asked 8 hours ago
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...
2
answers
0
votes
54
views
asked 3 days ago
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...
2
answers
0
votes
29
views
asked 5 days ago
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...
1
answers
0
votes
22
views
asked 7 days ago
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...
Accepted AnswerAmazon Athena
1
answers
0
votes
27
views
asked 8 days ago
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...
1
answers
0
votes
24
views
asked 9 days ago
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...
Accepted AnswerAmazon AthenaAWS Glue
2
answers
0
votes
45
views
asked 9 days ago
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 "...
2
answers
0
votes
52
views
asked 11 days ago
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...
1
answers
0
votes
33
views
asked 15 days ago
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
1
answers
0
votes
24
views
asked 16 days ago
profile pictureAWS
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...
1
answers
0
votes
43
views
asked 17 days ago