All Content tagged with Amazon Athena

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

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...