AWS Partner Network (APN) Blog

Category: Amazon Athena

Lenses.io-AWS-Partners

Archiving Amazon MSK Data to Amazon S3 with the Lenses.io S3 Kafka Connect Connector

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.

Read More
CSRHub-AWS-Partners

Integrating and Analyzing ESG Data on AWS Using CSRHub and Amazon QuickSight

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.

Read More
Zendesk-AWS-Partners

Building an Intelligent Contact Center with Zendesk and Amazon Connect

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.

Read More

How KPMG Visualizes Cloud Billing Data with Amazon QuickSight

KPMG uses Amazon QuickSight as a business intelligence tool to visualize the billing data in AWS Cost and Usage Reports. The machine learning insights in Amazon QuickSight shed light on where and why KPMG was spending money in the cloud. A tool like Amazon QuickSight, which is simple to use, cost effective, and flexible, gives KPMG valuable insights into AWS spend, and lets the organization create a plan of automated responses to cost- or usage-related events.

Read More
Tableau-AWS-Partners

Analyzing COVID-19 Data with AWS Data Exchange, Amazon Redshift, and Tableau 

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.

Read More

Running SQL on Amazon Athena to Analyze Big Data Quickly and Across Regions

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.

Read More
CloudZero_AWS-Partners

Improving Dataset Query Time and Maintaining Flexibility with Amazon Athena and Amazon Redshift

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.

Read More
Cloud Anything-4

Using ‘athena-express’ to Simplify SQL Queries on Amazon Athena

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.

Read More
Chartio_AWS Solutions

Now You Can Query and Visualize Amazon Athena Data Directly in Chartio

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.

Read More