synvert saracus Blog

09/06/2026

---

All

---

Struc­tured Test­ing in Data Ware­housing: From Chaos to Control

---

Intro­duc­tion: Why Test­ing a DWH is neces­sary – and difficult In today’s data-driven organ­iz­a­tions, a robust Data Ware­house Test­ing Strate...

---

Read article

01/06/2026

---

All

Data Management

Data Quality

Project Management

---

The Blue­print Before the Code: Archi­tect­ing Suc­cess with Require­ment Engineering

---

Estim­ated read­ing time: 8 minutes In an era where AI is only as power­ful as the data that fuels it, many organ­iz­a­tions are para­lyzed by ‘da...

---

Read article

14/04/2026

---

All

Data Integration

Data Management

Data Quality

---

Schema Con­tracts in Prac­tice: Test­ing and Mask­ing Nes­ted Data in Spark SQL and dbt 

---

Pre­vi­ous posts in this series addressed two recur­ring chal­lenges when work­ing with nes­ted data in Spark SQL. This post focuses on nes­ted data ...

---

Read article

14/04/2026

---

All

Data Integration

Data Management

Data Quality

---

Man­aging Schema Evol­u­tion in Spark SQL and dbt 

---

When work­ing with data, change is inev­it­able. Event pro­du­cers adjust formats, add attrib­utes, or modify data types as sys­tems evolve. While th...

---

Read article

14/04/2026

---

All

Data Integration

Data Management

Data Quality

---

Work­ing with Nes­ted Data in Spark SQL: From Dot-Walk­ing to Exploding

---

As a data engin­eer, data analyst, or Spark SQL prac­ti­tioner, you have prob­ably encountered nes­ted data in Spark SQL in the form of objects nes­t...

---

Read article

01/04/2026

---

All

Data Integration

Data Management

---

The Art of Con­sol­id­a­tion: Har­mon­iz­ing a Multi-Ten­ant DWH in an On-Premises World

---

While cloud solu­tions are increas­ingly becom­ing the stand­ard, many com­pan­ies con­tinue to rely on their exist­ing on-premises sys­tems – driven...

---

Read article

05/03/2026

---

All

Cloud Technologies

Data Management

---

Optim­iz­ing Dat­ab­ricks Per­form­ance: Liquid Clus­ter­ing and Dele­tion Vec­tors in Practice

---

Intro­duc­tion Teams run­ning Dat­ab­ricks in pro­duc­tion face the clas­sic tri­angle: per­form­ance, cost, and oper­a­tional effort. Tra­di­tion...

---

Read article

02/09/2025

---

All

Cloud Technologies

Data Integration

---

High-volume reverse geo­cod­ing with Nominatim

---

A recent pro­ject required us to map a large num­ber of GPS coordin­ates to their respect­ive muni­cip­al­ity names. This pro­cess, known as reverse ...

---

Read article

23/06/2025

---

All

---

Is Data Trans­form­a­tion Poorly Understood?

---

Intro­du­cing cat­egory the­ory as a found­a­tion for a new paradigm in data transformation Data pipelines are made of soft­ware. But unlike tra­d...

---

Read article

10/09/2024

---

All

BI/Reporting

---

Dif­fer­ent Con­nectiv­ity Modes in Power BI

---

Under­stand­ing Power BI’s vari­ous con­nectiv­ity modes is essen­tial to real­ise its full poten­tial: whether you use Power BI Desktop or the Power...

---

Read article