AWS Database Blog

Category: Analytics

How to perform advanced analytics and build visualizations of your Amazon DynamoDB data by using Amazon Athena

You can reap huge analytical value from billions of items and millions of requests per second in your Amazon 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 […]

Read More

Get started with Amazon Elasticsearch Service: Use Amazon Cognito for Kibana access control

Welcome to this introductory series on Elasticsearch and Amazon Elasticsearch Service (Amazon ES). In this and future blog posts, we provide the basic information that you need to get started with Elasticsearch on AWS. Introduction On April 2, 2018, we released integration between Amazon Elasticsearch Service and Amazon Cognito. You can now provide and manage […]

Read More

How to extract, transform, and load data for analytic processing using AWS Glue (Part 2)

One of the biggest challenges enterprises face is setting up and maintaining a reliable extract, transform, and load (ETL) process to extract value and insight from data. Traditional ETL tools are complex to use, and can take months to implement, test, and deploy. After the ETL jobs are built, maintaining them can be painful because […]

Read More

Get started with Amazon Elasticsearch Service: an easy way to send AWS SigV4 signed requests

Welcome to this introductory series on Elasticsearch and Amazon Elasticsearch Service (Amazon ES). In this and future blog posts, we provide the basic information that you need to get started with Elasticsearch on AWS. Introduction If you are using an IAM policy or policies that specify a user or role Amazon Resource Name (ARN) to […]

Read More

Secure your Amazon Elasticsearch Service domain with Active Directory authentication and authorization

In this blog post, we show how you can secure your Amazon Elasticsearch Service (Amazon ES) domain with authentication and authorization based on Microsoft Active Directory (AD). You do so by using an Nginx reverse proxy, running custom authorization code. Amazon ES doesn’t have any built-in support for integration with AD/LDAP for access control. This […]

Read More

Amazon Elasticsearch Service Now Supports the Seunjeon Plugin for Improved Korean Language Analysis

To ensure high fidelity parsing and matching for Korean text, Amazon Elasticsearch Service (Amazon ES) now supports the Seunjeon plugin. Using this plugin, you can create a custom analyzer that gives your users better results. Processing Asian languages for search When you use a search engine, you type words into the search box. The search […]

Read More

Analyzing Amazon Elasticsearch Service Slow Logs Using Amazon CloudWatch Logs Streaming and Kibana

Some of our customers have asked for guidance on analyzing Amazon Elasticsearch Service (Amazon ES) slow logs efficiently. Here is what one of these customers said: “We want to identify, understand, and troubleshoot any slow-running queries in our Amazon Elasticsearch Service environment, so we can fix the application that’s submitting them. We’ve read that Elasticsearch […]

Read More

Get Started with Amazon Elasticsearch Service: Use Dedicated Master Instances to Improve Cluster Stability

Welcome to this introductory series on Elasticsearch and Amazon Elasticsearch Service (Amazon ES). In this and future articles, we provide the basic information that you need to get started with Elasticsearch on AWS. What dedicated master instances are and why you need them Dedicated master instances perform a single function in an Elasticsearch cluster: orchestration. […]

Read More

Stream data into an Aurora PostgreSQL Database using AWS DMS and Amazon Kinesis Data Firehose

Using AWS Database Migration Service (AWS DMS), you can migrate data from various sources to most widely used commercial and open-source databases. The service supports homogenous migrations such as Oracle to Oracle. It also supports heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora or Microsoft SQL Server to MySQL. In addition, […]

Read More

Simplify Data Warehouse Migration to Amazon Redshift Using New AWS Schema Conversion Tool Features

The AWS Schema Conversion Tool (AWS SCT) makes heterogeneous database migrations more predictable by automatically converting the source database schema and most of the database code objects to a format compatible with the target database. To help with migration of on-premises data warehouses to Amazon Redshift, the new version of AWS SCT adds the following important […]

Read More