How to perform groupby using Python Itertools
Itertools is a powerful module and is part of python standard library. It provides a set of fast and memory efficient functions. You can learn more about them by referring…
Read Full Recipe
Using SSL to securely connect to Amazon Redshift Cluster
Amazon Redshift is fully managed Cloud Datawarehouse from AWS for running analytic workloads. Lot of customers have requirements to encrypt data in transit as part of security guidelines. Redshift provides…
Read Full Recipe
Azure BLOB Storage As Remote Backend for Terraform State File
Terraform supports team-based workflows with its feature "Remote Backend". Remote backend allows Terraform to store its State file on a shared storage so that any team member can use Terraform…
Read Full Recipe
Azure Infrastructure Automation With Terraform: Configuration
In this article I will explain how to configure Terraform to automate Azure infrastructure deployments. There are multiple ways to configure Terraform to work with Azure, I prefer following two:…
Read Full Recipe
AWS Glue Python shell job timeout with custom Libraries
This is short post on Timeout errors faced using custom libraries with AWS Glue Python shell job. I referred the steps listed in AWS docs to create a custom library…
Read Full Recipe
Identifying PostgreSQL Bloat and fixing it without downtime
MVCC (Multi-Version Concurrency Control) feature allows databases to provide concurrent access to data. This allows each SQL statement to see a snapshot of data as it was some time ago,…
Read Full Recipe