Tag: Athena

All the articles with the tag "Athena".

• Why Athena Returns No Rows on Partitioned Tables (and How to Fix It)

  26 Sep, 2026

  Your data is in S3, the table exists, and Athena returns zero rows. Six root causes behind partition metadata desync and how to diagnose each one.

• Sending Athena Query Results to Amazon SQS: Architecture, Costs, and Limitations

  27 Jan, 2026

  Introduction Amazon Athena is a serverless query service designed for interactive analysis of data stored in Amazon S3. Amazon SQS (Simple Queue Service), on the other hand, is a fully managed message

• Designing a Semantic Layer for Athena + Power BI

  15 Sep, 2025

  Modern data architectures benefit from a clear separation of layers: Ingesta , Staging , and Semantic (Presentation) . When using Amazon Athena as the query engine and Power BI as the visualization

• Choosing Between saveAsTable and Iceberg’s writeTo in AWS Glue and Athena

  3 Sep, 2025

  When working with Spark on AWS Glue , there are multiple ways to persist DataFrames as tables and make them queryable in Amazon Athena . Two common approaches are: Using Spark’s Hive-style saveAsTable

• Optimizing Amazon Athena Queries with Partitions: A Practical Example

  1 Sep, 2025

  When working with Amazon Athena, one of the most effective strategies to improve query performance and reduce costs is partitioning your data . Partitions allow Athena to scan only the relevant

• When Should You Use Iceberg with Athena? Partitioning Strategies and Best Practices

  5 Jul, 2025

  As data lakes grow in size and complexity, tools like Amazon Athena combined with table formats like Apache Iceberg become essential for scalability, data governance, and performance. In this post,