April, 2020 | Andrew Smith

Loading data into Amazon Redshift using AWS Glue

AWS Glue is a fully managed, cloud-native, AWS service for performing extract, transform and load operations across a wide range of data sources and destinations.

It supports connectivity to Amazon Redshift, RDS and S3, as well as to a variety of third-party database engines running on EC2 instances. It’s a serverless […] “Loading data into Amazon Redshift using AWS Glue”

Using Amazon SQS with AWS Lambda Functions

The IoT scenario from my last post is expanded here to use an SQS queue in between the AWS IoT Rules engine and the Lambda function used to write inbound sensor data to the PostgreSQL database.

This decouples the Rules engine and the Lambda function, allowing for flexibility and resiliency when […] “Using Amazon SQS with AWS Lambda Functions”

Using AWS Lambda functions to write to Amazon RDS

In my last post I implemented an AWS IoT scenario that used an IoT rule to write to DynamoDB.

Here we change that rule to one that instead uses a Python Lambda function to write to a database on an Amazon RDS for PostgreSQL instance. […] “Using AWS Lambda functions to write to Amazon RDS”