Category: HAQM Athena

February 9, 2024: HAQM Kinesis Data Firehose has been renamed to HAQM Data Firehose. Read the AWS What’s New post to learn more. With the announcement of HAQM CloudWatch Metric Streams, you can now stream near-real-time metrics data to a destination such as HAQM Simple Storage Service (HAQM S3). Metric Streams supports two primary use […]

January 2023: Please refer to Accelerate HAQM DynamoDB data access in AWS Glue jobs using the new AWS Glue DynamoDB Export connector  for more recent updates on using HAQM Glue to extract data from HAQM DynamoDB. HAQM DynamoDB is a key-value and document database that delivers single-digit millisecond performance at any scale. It’s a fully […]

Managed Blockchain follows an event-driven architecture. We can open up a wide range of analytic approaches by streaming events to HAQM Kinesis. For instance, we could analyze events in near-real time with Kinesis Data Analytics, perform petabyte scale data warehousing with HAQM RedShift, or use the Hadoop ecosystem with HAQM EMR. This allows us to use the right approach for every blockchain analytics use case.
In this post, we show you one approach that uses HAQM Kinesis Data Firehose to capture, monitor, and aggregate events into a dataset, and analyze it with HAQM Athena using standard SQL.

HAQM Relational Database Service (RDS) helps you easily create, operate, and scale a relational database in the cloud. In January 2020, AWS announced the ability to export snapshots from HAQM RDS for MySQL, HAQM RDS for PostgreSQL, HAQM RDS for MariaDB, HAQM Aurora PostgreSQL, and HAQM Aurora MySQL into HAQM S3 in Apache Parquet format. […]

As applications evolve to be more scalable for the web, customers are adopting flexible data structures and database engines for their use cases. Using NoSQL data stores has become increasing popular because of NoSQL’s flexible data model for building modern applications. HAQM DynamoDB is a fast and flexible NoSQL database service that can provide consistent […]

You can reap huge analytical value from billions of items and millions of requests per second in your HAQM DynamoDB service. However, you need to export your data in order to get that analytical value. Copying the data from a DynamoDB table to an analytics platform allows you to extract rich insights. In order to […]

HAQM Aurora offers a high-performance advanced auditing feature that logs detailed database activity to the database audit logs in HAQM CloudWatch. If you are using Aurora 1.10.1 or greater, you can use advanced auditing to meet regulatory or compliance requirements by capturing eligible events like tables queried, queries issued, and connections and disconnections. You can […]

Prahlad Rao is a solutions architect at HAQM Web Services. When you replicate a relational database to the cloud, one of the common use cases is to enable additional insights on the replicated data. You can apply the analytics and query-processing capabilities that are available in the AWS Cloud on the replicated data. To replicate […]