#AmazonAthena
Nuevo Podcast #AWSlatam 🎤 - EP289: Mejores Prácticas de Amazon Athena

#AmazonAthena #DataArchitecture #CostOptimization #ApacheSpark #BestPractices
EP289: Mejores Prácticas de Amazon Athena
Podcast AWS LATAM · Episode
ift.tt
September 7, 2025 at 8:43 AM
Migration isn’t magic. 🎩✨ If you're moving from @awscloud.bsky.social Athena to #Snowflake, read this first: https://bit.ly/4gOHGWI Learn how to handle schema mismatches, metadata gaps & format shifts.

#CData #AmazonAthena #AWS #DataEngineering #CloudData
October 22, 2025 at 6:06 PM
From SQL dialects to unstructured data headaches, migrating from @awscloud.bsky.social Athena to Snowflake isn’t always smooth sailing. 🌊

Get the roadmap for a smarter move → https://bit.ly/4gOHGWI

#Snowflake #AmazonAthena #CData #AWS #DataMigration
October 6, 2025 at 7:16 PM
▶️ NEW VIDEO: Redpanda + #AWS Glue

Yesterday, we walked you through integrating Redpanda’s #Iceberg catalog with #AWSGlue. Up next: how to query your Glue-registered data using #AmazonAthena — the powerful, serverless query service that makes analyzing data in #S3 seriously easy. 🎯
September 9, 2025 at 6:12 PM
✍️ New blog post by Wilklins Nyatteng

Review and Secure a Lambda Function with an IAM Least Privilege Based Security Policy: CloudTrail and Athena Approach

#awscommunitybuilder #aws #iam #amazonathena
Review and Secure a Lambda Function with an IAM Least Privilege Based Security Policy: CloudTrail and Athena Approach
In this lab scenario, you take on the role of a cloud security engineer, working for a business...
dev.to
October 5, 2025 at 8:29 AM
Amazon S3 Storage Lens adds performance metrics, support for billions of prefixes, and export to S3 Tables

New capabilities help optimize appli...

#AWS #AmazonAthena #AmazonCloudwatch #AmazonEmr #AmazonQuickSight #AmazonRedshift #AmazonS3Tables #AmazonSimpleStorageService(S3) #Analytics #Storage
Amazon S3 Storage Lens adds performance metrics, support for billions of prefixes, and export to S3 Tables
New capabilities help optimize application performance, analyze unlimited prefixes, and simplify metrics analysis through S3 Tables integration.
aws.amazon.com
January 1, 2026 at 6:05 PM
アジアの新たな「お宝箱」、データ分析の新潮流が台北に!AWSのAmazon Athenaが台湾で注目されています。サーバーレスで手軽にデータ分析を始められるのが魅力。ビジネスの可能性を広げるツールとして、アジア市場での活用が期待されます。 AmazonAthena #AWS #データ分析 #アジア #台北 #テクノロジー #クラウド Link
July 14, 2025 at 2:24 PM
🆕 Amazon Athena is now available in Asia Pacific (Taipei), enabling serverless SQL querying of petabytes of data without infrastructure setup, leveraging open-source Trino and Presto engines.

#AWS #AmazonAthena
Amazon Athena is now available in Asia Pacific (Taipei)
We are excited to announce that Amazon Athena is now available in Asia Pacific (Taipei). Athena is a serverless, interactive query service that makes it simple to analyze petabytes of data using SQL, without requiring infrastructure setup or management. Athena is built on open-source Trino and Presto query engines, providing powerful and flexible interactive query capabilities, and supports popular data formats such as Apache Parquet and Apache Iceberg. For more information about the AWS Regions where Athena is available, see the AWS Region table. To learn more, see Amazon Athena.
aws.amazon.com
June 30, 2025 at 7:40 PM
Amazon Athena launches auto-scaling solution for Capacity Reservations

https://docs.aws.amazon.com/athena/ now offers an auto-scaling solution for Capacity Reservations that dynamically adjusts your reserved capacity based on workload demand. The solution uses https://aws.a...

#AWS #AmazonAthena
Amazon Athena launches auto-scaling solution for Capacity Reservations
https://docs.aws.amazon.com/athena/ now offers an auto-scaling solution for Capacity Reservations that dynamically adjusts your reserved capacity based on workload demand. The solution uses https://aws.amazon.com/step-functions/ to monitor utilization metrics and scale your Data Processing Units (DPUs) up or down according to the thresholds and limits you configure, helping you optimize costs while maintaining query performance and eliminating the need for manual capacity adjustments. You can customize scaling behavior by setting utilization thresholds, measurement frequency, and capacity limits to match your workload needs. The solution uses Step Functions to add or remove DPUs to any active Capacity Reservation based on capacity utilization metrics in https://aws.amazon.com/cloudwatch/. Capacity automatically scales up when utilization exceeds your high threshold and scales down when it falls below your low threshold - all while adhering to your defined limits. You can further customize the solution by modifying the https://aws.amazon.com/cloudformation/ template to fit your specific requirements. The auto-scaling solution for Athena Capacity Reservations is available in AWS Regions where Capacity Reservations is supported. To get started, see https://docs.aws.amazon.com/athena/latest/ug/capacity-management-automatically-adjust-capacity.html in the Athena user guide.
aws.amazon.com
November 22, 2025 at 2:05 AM
🆕 Amazon Athena introduces auto-scaling for Capacity Reservations, dynamically adjusting reserved capacity via AWS Step Functions, optimizing costs and performance, and eliminating manual adjustments. Available in supported regions. See the Athena user guide for setup.

#AWS #AmazonAthena
Amazon Athena launches auto-scaling solution for Capacity Reservations
Amazon Athena now offers an auto-scaling solution for Capacity Reservations that dynamically adjusts your reserved capacity based on workload demand. The solution uses AWS Step Functions to monitor utilization metrics and scale your Data Processing Units (DPUs) up or down according to the thresholds and limits you configure, helping you optimize costs while maintaining query performance and eliminating the need for manual capacity adjustments. You can customize scaling behavior by setting utilization thresholds, measurement frequency, and capacity limits to match your workload needs. The solution uses Step Functions to add or remove DPUs to any active Capacity Reservation based on capacity utilization metrics in Amazon CloudWatch. Capacity automatically scales up when utilization exceeds your high threshold and scales down when it falls below your low threshold - all while adhering to your defined limits. You can further customize the solution by modifying the Amazon CloudFormation template to fit your specific requirements. The auto-scaling solution for Athena Capacity Reservations is available in AWS Regions where Capacity Reservations is supported. To get started, see Automatically adjust capacity in the Athena user guide.
aws.amazon.com
November 22, 2025 at 1:40 AM
Amazon Athena adds cost and performance controls for Capacity Reservations

https://aws.amazon.com/athena/ now gives you control over Data Processing Unit (DPU) usage for queries running on Capacity Reservations. You can now configure DPU settings at the workgroup or query l...

#AWS #AmazonAthena
Amazon Athena adds cost and performance controls for Capacity Reservations
https://aws.amazon.com/athena/ now gives you control over Data Processing Unit (DPU) usage for queries running on Capacity Reservations. You can now configure DPU settings at the workgroup or query level to balance cost efficiency, concurrency, and query-level performance needs. Capacity Reservations provides dedicated serverless processing capacity for your Athena queries. Capacity is measured in DPUs, and queries consume DPUs based on their complexity. Now you can set explicit DPU values for each query—ensuring small queries use only what they need while guaranteeing critical queries get sufficient resources for fast execution. The Athena console and API now return per-query DPU usage, helping you understand DPU usage and determine your capacity needs. These updates help you control per-query capacity usage, control query concurrency, reduce costs by eliminating over-provisioning, and deliver consistent performance for business-critical workloads. Cost and performance controls are available today in AWS Regions where Capacity Reservations is supported. To learn more, see https://docs.aws.amazon.com/athena/latest/ug/capacity-management-control-capacity-usage.html in the Athena user guide.
aws.amazon.com
November 22, 2025 at 2:05 AM
Amazon Athena launches single sign-on support for drivers

https://aws.amazon.com/athena/ announces single sign-on support for its JDBC and ODBC drivers through AWS IAM Identity Center’s trusted identity propagation. This makes it simpler for organizations to manage end-u...

#AWS #AmazonAthena
Amazon Athena launches single sign-on support for drivers
https://aws.amazon.com/athena/ announces single sign-on support for its JDBC and ODBC drivers through AWS IAM Identity Center’s trusted identity propagation. This makes it simpler for organizations to manage end-user's access to data when using 3rd party tools and implement identity-based data governance policies with a seamless sign-on experience. With this new capability, data teams can seamlessly access data through their preferred 3rd party tools using their organizational credentials. When analysts run queries using the updated Athena JDBC (3.6.0) and ODBC (2.0.5.0) drivers, their access permissions defined in Lake Formation are applied and their actions logged. This streamlined workflow eliminates credential management overhead while ensuring consistent security policies, allowing data teams to focus on insights rather than access management. For example, data analysts using 3rd party BI tools or SQL clients can now connect to Athena using their corporate credentials, and their access to data will be restricted based on policies defined for their respective user identity or group membership in Lake Formation. This feature is available in regions where Amazon Athena and AWS Identity Center's trusted identity propagation are supported. To learn more about configuring identity support when using Athena drivers, see the https://docs.aws.amazon.com/athena/latest/ug/using-trusted-identity-propagation.html
aws.amazon.com
September 11, 2025 at 10:05 PM
🆕 Amazon Athena now supports single sign-on for JDBC and ODBC drivers via AWS IAM Identity Center, simplifying data access management and enforcing identity-based governance policies with seamless sign-on for analysts using 3rd party tools.

#AWS #AmazonAthena
Amazon Athena launches single sign-on support for drivers
Amazon Athena announces single sign-on support for its JDBC and ODBC drivers through AWS IAM Identity Center’s trusted identity propagation. This makes it simpler for organizations to manage end-user's access to data when using 3rd party tools and implement identity-based data governance policies with a seamless sign-on experience. With this new capability, data teams can seamlessly access data through their preferred 3rd party tools using their organizational credentials. When analysts run queries using the updated Athena JDBC (3.6.0) and ODBC (2.0.5.0) drivers, their access permissions defined in Lake Formation are applied and their actions logged. This streamlined workflow eliminates credential management overhead while ensuring consistent security policies, allowing data teams to focus on insights rather than access management. For example, data analysts using 3rd party BI tools or SQL clients can now connect to Athena using their corporate credentials, and their access to data will be restricted based on policies defined for their respective user identity or group membership in Lake Formation. This feature is available in regions where Amazon Athena and AWS Identity Center's trusted identity propagation are supported. To learn more about configuring identity support when using Athena drivers, see the Amazon Athena driver documentation.
aws.amazon.com
September 11, 2025 at 9:40 PM
Amazon Athena is now available in Asia Pacific (Taipei)

We are excited to announce that https://aws.amazon.com/athena/ is now available in Asia Pacific (Taipei).

Athena is a serverless, interactive query service that makes it simple to analyze petabytes of data using S...

#AWS #AmazonAthena
Amazon Athena is now available in Asia Pacific (Taipei)
We are excited to announce that https://aws.amazon.com/athena/ is now available in Asia Pacific (Taipei). Athena is a serverless, interactive query service that makes it simple to analyze petabytes of data using SQL, without requiring infrastructure setup or management. Athena is built on open-source Trino and Presto query engines, providing powerful and flexible interactive query capabilities, and supports popular data formats such as Apache Parquet and Apache Iceberg. For more information about the AWS Regions where Athena is available, see the https://aws.amazon.com/about-aws/global-infrastructure/regional-product-services/ table. To learn more, see https://docs.aws.amazon.com/athena/.  
aws.amazon.com
June 30, 2025 at 8:05 PM
Amazon Athena announces managed query results to streamline analysis workflows

https://aws.amazon.com/athena announces managed query results, a new feature that automatically stores, encrypts, and manages the lifecycle of query results for you at no additional cost. Managed...

#AWS #AmazonAthena
Amazon Athena announces managed query results to streamline analysis workflows
https://aws.amazon.com/athena announces managed query results, a new feature that automatically stores, encrypts, and manages the lifecycle of query results for you at no additional cost. Managed query results streamlines analysis and administration workflows by providing temporary query results storage, removing the requirement for Amazon S3 buckets to store results and separate processes to clean up results that you no longer need. Now, Athena offers both service-managed, temporary result storage and customer-managed S3 storage options to meet different needs. Whether you're working on a team conducting interactive analysis across multiple workgroups or automating workgroup creation through code, managed query results allows you to run queries in fewer steps. For example, if you create a new workgroup for an analysis that you'll perform, you can now choose to have Athena manage your result data for you. This allows you to run queries without first specifying the S3 result location, ensures results are encrypted, and avoids cost from storing query results after they're no longer needed. When you use managed query results, you can continue to access query results through the same interfaces as you can when using an S3 bucket in your account. To get started, use the AWS Management Console, AWS SDK, or CLI to configure your new or existing workgroups to use managed query results. Managed query results is generally available in all https://aws.amazon.com/about-aws/global-infrastructure/regional-product-services/, except GovCloud and China regions. To learn more, see https://docs.aws.amazon.com/athena/latest/ug/managed-results.html in the Athena User Guide.
aws.amazon.com
June 4, 2025 at 5:05 PM
🆕 Amazon SageMaker now supports ODBC for Power BI, allowing direct data access via Amazon Athena ODBC driver, adding a free, native connection path for analysts in all supported AWS Regions.

#AWS #AmazonSagemaker #AwsIamIdentityCenter #AmazonSagemakerStudio #AmazonAthena
Amazon SageMaker Unified Studio now supports ODBC connections for Microsoft Power BI and other analytics tools
Amazon SageMaker Unified Studio now supports ODBC connections, so data users can connect Microsoft Power BI and other ODBC-compatible tools directly to governed data in SageMaker Unified Studio projects using the Amazon Athena ODBC driver. This adds a native connection path for analysts who have standardized on Power BI to work with governed data using their existing tools and workflows. Amazon SageMaker Unified Studio adds an ODBC connection details view to the project overview page, alongside the existing JDBC view. From the project's JDBC and ODBC connections tab, data users can copy the connection string and its parameters for a DSN-less connection, or use them to configure a named DSN. The Amazon Athena ODBC driver (version 2.2.0.1 or later) works directly with SageMaker Unified Studio through two modes: SageMakerBrowserIdc, which opens a browser to sign in through AWS IAM Identity Center and your external identity provider, and SageMakerIam, which uses temporary AWS credentials. ODBC connections in SageMaker Unified Studio are available today in all AWS Regions where Amazon SageMaker Unified Studio is available, at no additional cost. To get started, refer to the Amazon SageMaker Unified Studio User Guide and the Amazon Athena ODBC driver documentation.
aws.amazon.com
September 15, 2026 at 3:10 PM
Amazon SageMaker Unified Studio now supports ODBC connections for Microsoft Power BI and other analytics tools

Amazon SageMaker Unified Studio now supports ODBC connections, so data users can connect Microsoft Powe...

#AWS #AmazonSagemaker #AwsIamIdentityCenter #AmazonSagemakerStudio #AmazonAthena
Amazon SageMaker Unified Studio now supports ODBC connections for Microsoft Power BI and other analytics tools
Amazon SageMaker Unified Studio now supports ODBC connections, so data users can connect Microsoft Power BI and other ODBC-compatible tools directly to governed data in SageMaker Unified Studio projects using the Amazon Athena ODBC driver. This adds a native connection path for analysts who have standardized on Power BI to work with governed data using their existing tools and workflows. Amazon SageMaker Unified Studio adds an ODBC connection details view to the project overview page, alongside the existing JDBC view. From the project's JDBC and ODBC connections tab, data users can copy the connection string and its parameters for a DSN-less connection, or use them to configure a named DSN. The Amazon Athena ODBC driver (version 2.2.0.1 or later) works directly with SageMaker Unified Studio through two modes: SageMakerBrowserIdc, which opens a browser to sign in through AWS IAM Identity Center and your external identity provider, and SageMakerIam, which uses temporary AWS credentials. ODBC connections in SageMaker Unified Studio are available today in all AWS Regions where Amazon SageMaker Unified Studio is available, at no additional cost. To get started, refer to the https://docs.aws.amazon.com/sagemaker-unified-studio/latest/userguide/query-with-odbc.html and the https://docs.aws.amazon.com/athena/latest/ug/odbc-v2-driver.html.
aws.amazon.com
September 15, 2026 at 3:05 PM
#うひーメモ
2023-11-29 05:00:54
[アップデート] Amazon Athena と Amazon S3 Express One Zone によるクエリを高速化 #AWSreInvent
#技術系ブログ等
#アップデート
#amazon
#amazonsexpressonezone
[アップデート] Amazon Athena と Amazon S3 Express One Zone によるクエリを高速化 #AWSreInvent
データアナリティクス事業本部のコンサルティングチームの石川です本日よりAmazonAthenaはAmazonSExpressOneZoneストレージクラスに保存されたデータでクエリを高速化できるように
dev.classmethod.jp
November 28, 2023 at 8:00 PM
#うひーメモ
2023-11-27 12:15:18
[アップデート]AWS CloudTrail LakeのイベントデータストアをAthenaで検索できるようになりました! #AWSreInvent
#技術系ブログ等
#アップデート
#amazon
#athena
[アップデート]AWS CloudTrail LakeのイベントデータストアをAthenaで検索できるようになりました! #AWSreInvent
データアナリティクス事業本部機械学習チームの鈴木ですAWSCloudTrailLakeデータのAmazonAthenaによるzeroETL分析というアップデートが発表されましたアナウンスされた機能につい
dev.classmethod.jp
November 27, 2023 at 3:15 AM
Amazon Athena simplifies federated queries with managed connectors

https://aws.amazon.com/athena now offers managed connectors for 12 data sources, including Amazon DynamoDB, PostgreSQL, MySQL, and Snowflake. Managed connectors are AWS Glue Data Catalog federated connectors...

#AWS #AmazonAthena
Amazon Athena simplifies federated queries with managed connectors
https://aws.amazon.com/athena now offers managed connectors for 12 data sources, including Amazon DynamoDB, PostgreSQL, MySQL, and Snowflake. Managed connectors are AWS Glue Data Catalog federated connectors that Athena creates and manages on your behalf, so you can query data outside Amazon S3 without deploying or maintaining connector resources in your AWS account. With Athena, you can interactively query relational, non-relational, object, and custom data sources without moving or duplicating data. To get started with managed connectors, you create a connection for your data source in Athena. Athena automatically sets up and manages connector resources on your behalf, registering the data source as a federated catalog in AWS Glue Data Catalog. You can then query the data source alongside your Amazon S3 data and optionally set up fine-grained access controls through AWS Lake Formation. Federated queries with managed connectors are available in all AWS Regions where Athena is available, except the AWS GovCloud (US) Regions and the China Regions. To learn more, visit https://docs.aws.amazon.com/athena/latest/ug/federated-queries.html in the Athena User Guide.
aws.amazon.com
April 23, 2026 at 10:05 PM
Amazon Athena Spark adds support for AWS PrivateLink

Amazon Athena Spark now supports https://aws.amazon.com/privatelink/ so that you can access APIs and endpoints from your Amazon Virtual Private Cloud (VPC) without traversing the public internet. This feature can help you...

#AWS #AmazonAthena
Amazon Athena Spark adds support for AWS PrivateLink
Amazon Athena Spark now supports https://aws.amazon.com/privatelink/ so that you can access APIs and endpoints from your Amazon Virtual Private Cloud (VPC) without traversing the public internet. This feature can help you meet compliance requirements by allowing you to access and use Athena Spark APIs and endpoints entirely within the AWS network. You can now create AWS PrivateLink interface endpoints to connect from clients in your VPC. The Athena VPC endpoint supports all Athena Spark APIs and endpoints, including the Spark Connect, Spark Live UI and Spark History Server endpoints. Communication between your VPC and Athena Spark APIs and endpoints is then conducted entirely within the AWS network, providing a secure pathway for your data. To get started, you can create an interface VPC endpoint to connect to Amazon Athena Spark using the AWS Management Console or AWS Command Line Interface (AWS CLI) commands or AWS CloudFormation. This new feature is available in all https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark-considerations-and-limitations.html where Amazon Athena Spark and AWS PrivateLink are available. For more information, refer to the https://docs.aws.amazon.com/vpc/latest/privatelink/create-interface-endpoint.html and https://docs.aws.amazon.com/athena/latest/ug/athena-spark-vpc-endpoint.html documentation.  
aws.amazon.com
April 21, 2026 at 9:05 PM
Amazon Athena now supports 1-minute reservations and 4 DPU minimum capacity

https://aws.amazon.com/athena/ now supports 1-minute Capacity Reservations and a lower minimum capacity of 4 Data Processing Units (DPUs) for all reservations. Now, you can get started with less cap...

#AWS #AmazonAthena
Amazon Athena now supports 1-minute reservations and 4 DPU minimum capacity
https://aws.amazon.com/athena/ now supports 1-minute Capacity Reservations and a lower minimum capacity of 4 Data Processing Units (DPUs) for all reservations. Now, you can get started with less capacity and make more frequent, fine-grained adjustments to match your workload patterns—with no long-term commitments and cost savings up to 95% for short-duration query workloads. Capacity Reservations provides dedicated serverless compute and is ideal for workloads requiring query prioritization and concurrency controls. You pay only for capacity that you reserve and there are no data scanned charges. Reserved capacity works seamlessly with existing Athena queries and workgroups—simply attach workgroups to a reservation and submit queries with no changes in your SQL queries or application code required. To learn more, see the https://docs.aws.amazon.com/athena/latest/ug/capacity-management-creating-capacity-reservations.html and https://aws.amazon.com/athena/pricing/ page.
aws.amazon.com
February 11, 2026 at 10:05 PM
Amazon S3 Storage Lens adds performance metrics, support for billions of prefixes, and export to S3 Tables

New capabilities help optimize appli...

#AWS #AmazonAthena #AmazonCloudwatch #AmazonEmr #AmazonQuickSight #AmazonRedshift #AmazonS3Tables #AmazonSimpleStorageService(S3) #Analytics #Storage
Amazon S3 Storage Lens adds performance metrics, support for billions of prefixes, and export to S3 Tables
New capabilities help optimize application performance, analyze unlimited prefixes, and simplify metrics analysis through S3 Tables integration.
aws.amazon.com
January 31, 2026 at 7:05 PM
Amazon S3 Storage Lens adds performance metrics, support for billions of prefixes, and export to S3 Tables

New capabilities help optimize appli...

#AWS #AmazonAthena #AmazonCloudwatch #AmazonEmr #AmazonQuicksight #AmazonRedshift #AmazonS3Tables #AmazonSimpleStorageService(S3) #Analytics #Storage
Amazon S3 Storage Lens adds performance metrics, support for billions of prefixes, and export to S3 Tables
New capabilities help optimize application performance, analyze unlimited prefixes, and simplify metrics analysis through S3 Tables integration.
aws.amazon.com
December 2, 2025 at 5:05 PM