Category: Amazon Athena

The Amazon Athena Teradata Connector enables Athena to query data in Teradata Vantage using SQL, and comprises two AWS Lambda functions for metadata and record reading. This post describes deploying the connector, creating a Lambda layer for the Teradata JDBC driver, and running queries on Teradata from Athena, including a federated query joining Teradata and S3 data. This provides a scalable, serverless way to analyze data across different data stores without data duplication.

Amazon Athena allows analyzing petabytes of data directly with SQL queries or via analytics tools like ThoughtSpot. This post covers creating an IAM access key, two Amazon S3 buckets (one for data storage, one for query results), creating an Amazon Athena table from sample data using an AWS Glue crawler, and establishing a connection between Athena and ThoughtSpot. With the connection, ThoughtSpot can search and visualize the Athena data using AI capabilities.

The Amazon Athena web-based query editor enables data consumers to author and run SQL queries on data sources that are registered with the AWS Glue Data Catalog and other data sources such as Amazon S3. This post describes the setup to provide federated access with OneLogin as the identity provider to securely access, author, and run queries in the Athena web-based editor via the AWS console, without the need for users to install a JDBC driver or run a SQL client on their machines.

Online analytical processing (OLAP) is a method of organizing datasets in a multi-dimensional format for quick analysis and provides deeper insights for decision-makers. Multi-dimension analysis is widely adopted by analysts, knowledge users, and power users for their decision support process. Learn how utilizing AWS analytic services and migration tools together with HCLTech frameworks to orchestrate OLAP solutions.

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.