IngestThis Logo
BLOG
COMMUNITY
PODCAST

Tag: best practices

2026-02-19 • Alex Merced

How to Think Like a Data Engineer

The median lifespan of a popular data tool is about three years. The tool you master today may be deprecated or replaced...

2026-02-19 • Alex Merced

How to Design Reliable Data Pipelines

Most pipeline failures aren't caused by bad code. They're caused by no architecture. A script that reads from an API, tr...

2026-02-19 • Alex Merced

Data Quality Is a Pipeline Problem, Not a Dashboard Problem

When an analyst finds null values in a revenue column, the typical response is to add a calculated field in the BI tool:...

2026-02-19 • Alex Merced

Idempotent Pipelines: Build Once, Run Safely Forever

A pipeline runs, processes 100,000 records, and loads them into the target table. Then it fails on a downstream step. Th...

2026-02-19 • Alex Merced

Schema Evolution Without Breaking Consumers

A source team renames a column from `user_id` to `customer_id`. Twelve hours later, five dashboards show blank values, t...

2026-02-19 • Alex Merced

Batch vs. Streaming: Choose the Right Processing Model

"We need real-time data." This is one of the most expensive sentences in data engineering — because it's rarely true, an...

2026-02-19 • Alex Merced

Partition and Organize Data for Performance

A table with 500 million rows takes 45 seconds to query. After partitioning it by date, the same query — filtering on a ...

2026-02-19 • Alex Merced

Testing Data Pipelines: What to Validate and When

Ask an application developer how they test their code and they'll describe unit tests, integration tests, CI/CD pipeline...

2026-02-19 • Alex Merced

Pipeline Observability: Know When Things Break

An analyst messages you on Slack: "The revenue numbers look wrong. Is the pipeline broken?" You check the orchestrator —...

Categories

data engineering
oltp
database
data
frontend
data lakehouse
Data Engineering
Data Lakehouse
Javascript
Data Architecture
Data Analytics
Devops
Data Modeling
DevOps
python
sql
rust
AI
Apache Iceberg
Software Development
Semantic Layer
copyright 2022 by Alex Merced of alexmercedcoder.dev