Sign in

I write about Technology, Classical Music, Personal Development, Finance, and the Workplace. 1x Engineer on weekdays.
Photo by Alexandre Debiève on Unsplash.

Inspired by , I am pinning this to my profile and will keep updating this on a weekly basis

This Week’s Most Viewed Story (16th April 2021)

My All-Time Most Viewed Stories

  1. Meet Google Meena
  2. 4 Advanced SQL Features You Haven’t Used Enough
  3. The New Data Engineering Stack
  4. State of the Art Infrastructure as Code
  5. Git Best Practices For SQL

You can find more of my work here on Linktree or you can get in touch with me directly either on LinkedIn or via email.

@Kiranchand Bobba - Thanks a lot for your response to my article about Data Vault. I have tried to answer your questions here -

1. Scalability (with variety and quantity both) - The data vault approach enables you to load data into an intermediate system without having to worry about relations between source entities (tables or APIs). It enables you to design your system to take append-only data without having to take care of merges, updates, and upserts. This enables you to be flexible with your source system integration. Hence, enabling variety. The data vault system is naturally very scalable…


Potential issues while testing databases, warehouses, and lakes


In an earlier post in my series on automation testing, I talked about automation tests' broad categories to write for databases and warehouses. I’ll go over specific types of tests in a later post in this series. For now, you can get the gist of it here.

This post will talk about the common problems data engineers face when testing databases and warehouses. Most of the problems I’ll discuss I have had a first-hand experience with, and the rest I got to learn about by discussions with my awesome friends and colleagues in the data engineering space. Let’s get started.

Too Many Calls

Photo by Tech Daily on Unsplash


A tutorial on how to set up alerting on time-series data with QuestDB and Grafana


There are many reasons why reacting to time series data is useful, and usually, the quicker you can respond to changes in this data, the better. The best tool for this job is easily a time series database, a type of database designed to write and read large amounts of measurements that change over time.

In this tutorial, you will learn how to read data from a REST API and stream it to QuestDB, an open-source time-series database. We will use Grafana to visualize the data and alerting to notify Slack on changes that interest us. …

What an amazing story written with such great clarity - a decade of work summarized! It's always exciting to know how different companies approach problems of data engineering. We must all realize that there's no one "right" way of doing data engineering.

Couldn't agree more with Snowplow's observation about measuring the accuracy and completeness of data being a process rather than a project —

"We won’t lie — measuring the accuracy and completeness of your data is not easy and is a process rather than a project. It starts at the very beginning: how you collect your data. And while it never ends, quality grows with better-defined events going into your pipeline, data validation, surfacing quality issues and testing."

Good read about data quality!

Loved this piece - very informative and full of accurate observations about data engineering teams. I have been working on a similar Data Vault / Data Warehouse setup recently. I could relate.

By the way, kudos to the analogy department!

This article talks about some of the major challenges that data engineers face while creating and maintaining data lakes.

I have dealt with five out of the six challenges that have been discussed here, not necessarily using Spark though.

Must read for data engineers!

I wasn't aware of Jonathan Mann's existence but I was following kind-of the same philosophy when creating music. During the last year, I might have completed more than a hundred compositions. I didn't write the songs myself, though. I just composed poems of my favorite poets.

Most of the compositions were mediocre, some were really bad, but there were a few which were pretty good. For me, the ratio might have been 75-20-5, but I guess this might get better if I keep at it. Maybe I'll also start posting my stuff somewhere in a year or two.

Fantastic article! You have walked through the whole process in quite some detail. Many years ago, I did something similar, but the scale wasn't as big. But the difference was that we were not just doing a database upgrade on MySQL; we were also migrating one schema to another (as the app was moving from a monolith to a microservices-based architecture) added another level of complexity to the process. Although those were a tense couple of weeks, we were able to do it quite well by the end of it.

A fascinating read for anyone who loves working with databases at scale!

Kovid Rathee

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store