AWS Lambda Python Script to create Database Snapshots

The below script is used to create a database manual snapshots on all regions in an AWS account.  RDS support automatic snapshots which are very useful for point in time recovery but it does not protect you from accidental deletion of RDS instances. Here are the reasons why we need manual snapshots Accidental RDS InstanceContinue reading “AWS Lambda Python Script to create Database Snapshots”

AWS Lambda to generate CSV file from RDS PostgreSQL

One of the requirement was to generate csv file for set of queries from RDS PostgreSQL and upload the csv file to s3 bucket for power bi reporting. Powerbi connects to s3 url and generate report. There is no gateway to connect to PostgreSQL instance from power-bi, hence we need to have a mechanism toContinue reading “AWS Lambda to generate CSV file from RDS PostgreSQL”

AWS S3—>AWS Lambda —>SSM—> SQL Server Job

Scenario: Application is running on java and the database is using PostgreSQL.  Application user uploads the data and this data needs to process to analytic server as well. There is no direct access to Analytic Database server that is running on SQL Server on different location. You need to architect a solution to process theseContinue reading “AWS S3—>AWS Lambda —>SSM—> SQL Server Job”

AWS Lambda to connect to PostgreSQL and execute a function/query using Python

It’s been long time since i wrote a blog post. In this post i would like to show an example of lambda to connect to PostgreSQL database and execute the query. Build a PostgreSQL psycopg module in order to connect to database. I’ve built a custom compiled python library to connect to latest PostgreSQL 9.6Continue reading “AWS Lambda to connect to PostgreSQL and execute a function/query using Python”