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 to this article. # Sample Data data = [ {‘id’: 1, ‘name’: ‘abc’, ‘child’: {‘id’: 2, ‘name’: ‘child1’}}, {‘id’: 1, ‘name’: ‘abc’, ‘child’: {‘id’: 3,…
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 support for SSL connections to encrypt data and server certificates to validate the server certificate that the client connects to. Before we proceed how SSL…
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 to manage same infrastructure. A state file keeps track of current state of infrastructure that is getting deployed and managed by Terraform. Read more about…
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: Configuring “Azure Terraform” Visual Studio Code(VSCode) extension. Configuring Terraform using Azure Cloud Shell. “Azure Terraform” VSCode Extension: Prerequisites: Azure Subscription: If you don’t already have…
AWS Glue Python shell job timeout with custom Libraries
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, regardless of the current state of the underlying data. This prevents statements from viewing inconsistent data produced by concurrent transactions performing updates on the same…