A serverless API that keeps two systems of record in sync
Problem
The IT Service Desk database and the main corporate database were reconciled by hand, which caused duplicate entry and inconsistent records.
What I built
A serverless REST API on AWS Lambda in Python, with Snowflake, that synchronises the two databases in both directions.
Result
Eliminated the manual data entry and reduced data inconsistencies by 90%+.
Stack
- Python
- AWS Lambda
- Snowflake
- SQL
- REST