AWS Database Blog
Tag: HAQM Athena
Building data lakes and implementing data retention policies with HAQM RDS snapshot export to HAQM S3
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. […]
How to perform advanced analytics and build visualizations of your HAQM DynamoDB data by using HAQM Athena
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 […]
Audit HAQM Aurora Database Logs for Connections, Query Patterns, and More, using HAQM Athena and HAQM QuickSight
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 […]
Using AWS Database Migration Service and HAQM Athena to Replicate and Run Ad Hoc Queries on a SQL Server Database
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 […]