Perform near real time analytics using Amazon Redshift on data stored in Amazon DocumentDB
Database Blog
This article explains how to perform near-real-time analytics on data stored in Amazon DocumentDB using Amazon Redshift. It covers streaming data from DocumentDB to Redshift using change streams, AWS Lambda, and Amazon Kinesis Data Streams.
Specifically, the article covers:
- Overview of the solution architecture
- Deploying a CloudFormation stack to set up the required resources
- Connecting to the Amazon DocumentDB cluster using AWS Cloud9
- Creating a database, collection, and enabling change streams in DocumentDB
- Configuring a trigger for the Lambda function to capture changes
- Setting up Amazon Redshift streaming ingestion
- Creating a view on the materialized view for near-real-time analysis
- Conclusion and clean-up steps
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Mar 11
2024
2024
Best practices to implement near-real-time analytics using Amazon Redshift Streaming Ingestion with Amazon MSK
Apr 10
2024
2024
Achieve near real time operational analytics using Amazon Aurora PostgreSQL zero-ETL integration with Amazon Redshift
Sep 23
2025
2025
Accelerating SQL analytics with Amazon Redshift MCP server
Aug 4
2025
2025
Near real-time streaming analytics on protobuf with Amazon Redshift
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.