Category: Amazon Athena

Amazon Athena is a serverless interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Data stored in S3 can span gigabytes to petabytes, however, and querying such massive data poses unique challenges. Follow along as experts from AWS and Innovative Solutions present a use case-based approach to help evaluate these challenges and propose solutions to improve Amazon Athena query performance.

Data security has always been an important consideration for organizations when complying with data protection regulations. Protegrity, an AWS ISV Partner and global leader in data security, has released a serverless User Defined Function (UDF) that adds external data tokenization capabilities to the Amazon Athena platform. Learn how customers can use the Protection Athena Protector UDF to tokenize or detokenize data at scale.

Amazon Managed Streaming for Apache Kafka (Amazon MSK) is a fully managed, highly available, and secure Apache Kafka service that makes it easy to build and run applications that use Kafka to process steaming data. Learn how to use the new open source Kafka Connect Connector (StreamReactor) from Lenses.io to query, transform, optimize, and archive data from Amazon MSK to Amazon S3. We’ll also demonstrate how to use Amazon Athena to query the partitioned parquet data directly from S3.

Environmental, social, and governance (ESG) factors are increasingly important for financial institutions as they look to assess portfolio risk, meet investment mandates, align with customer values, and report on the sustainability of their portfolios. Working closely with CSRHub, a data provider on AWS Data Exchange, learn how AWS has produced a demonstration to illustrate how customers can analyze company-level ESG scoring data with Amazon QuickSight.

Zendesk and VoiceFoundry released the Amazon Connect app on the Zendesk Marketplace as part of a broader vision for the intelligent contact center of the future. The Amazon Connect app for Zendesk brings together a wide set of capabilities and unlocks endless possibilities for you to empower your agents and better engage your customers. By combining the powers of Amazon Connect and Zendesk, businesses can build a more intelligent contact center.

To help everyone visualize COVID-19 data confidently and responsibly, we brought together APN Partners Salesforce, Tableau, and MuleSoft to create a centralized repository of trusted data from open source COVID-19 data providers. Anyone can work with the public data, blend it with their own data, or subscribe to the source datasets directly through AWS Data Exchange, and then use Amazon Redshift together with Tableau to better understand the impact on their organization.

Data is the lifeblood of a digital business and a key competitive advantage for many companies holding large amounts of data in multiple cloud regions. Imperva protects web applications and data assets, and in this post we examine how you can use SQL to analyze big data directly, or to pre-process the data for further analysis by machine learning. You’ll also learn about the benefits and limitations of using SQL, and see examples of clustering and data extraction.

Analyzing large datasets can be challenging, especially if you aren’t thinking about certain characteristics of the data and what you’re ultimately looking to achieve. There are a number of factors organizations need to consider in order to build systems that are flexible, affordable, and fast. Here, experts from CloudZero walk through how to use AWS services to analyze customer billing data and provide value to end users.

Deloitte’s Gary Arora, an APN Ambassador, will show you how to integrate an application with Amazon Athena to execute SQL queries with ‘athena-express.’ This is a wrapper around the AWS SDK that can simplify executing SQL queries in Amazon Athena and fetch the JSON results in the same synchronous call—a capability well suited for many web applications. Developers can use ‘athena-express’ to help save time and effort in setting up the integration and focus on core application development.

Amazon Athena is a Presto-distributed SQL engine used to query unstructured data using standard SQL, where you pay only for the amount of data you query. Chartio, an AWS Competency Partner, recently announced support for Athena. Their solution allows you to query and visualize data stored in an Amazon S3 data lake using standard SQL. You can also use their visual drag-and-drop SQL layer, which generates native SQL queries for you.