![](https://squidex.jugru.team/api/assets/srm/79035613-4f3c-4f16-a40d-9b2334484b55/2022-09-07-10.34.08.jpg?cache=3600&width=74&height=74&mode=CropUpsize)
Pavel Sivokhin
Company: Whoosh
Whoosh works on the AWS stack — PostgreSQL, S3, Redshift, and they build all data models in dbt and a little Python. This year for the data engineering team could be called the year of the move. They had the global idea of moving from one repository (PostgreSQL) — and that includes all reporting for the business and dbt models — to Data Lake rails. The goal was to optimize costs, because Aurora (PostgreSQL) writes to the expense of every query, while Redshift is an MPP columnar database whose costs are constant - n$/hour (and it runs faster, yes). However, due to the move it turned out that for geo-tasking this solution is not suitable: Redshift is based on version 8 of Postgres (suddenly!) which doesn't have a well-supported work with geometry, cuts off cell values over a certain length and is not at all friendly with JSON keys.
Company: Whoosh
Company: Whoosh
Company: Whoosh