Writing the Perfect Ticket: How to Create a Table in the Data Layer — Lessons from a 3-Month Intern When you join Vatico as an intern, writing a ticket is not a routine for a task—it is to figure out the problem, see if there is any solution, and determine if that solution makes sense […]
Lưu trữ danh mục: Training Data
Update Woo Order Status Sync to CRM via Reverse ETL Pipeline — Vatico Training At Vatico, maintaining a scalable data ecosystem is key to our operational success. As part of migrating our CRM into Docker, we simplified our systems into a Reverse ETL workflow. In this post, we explain Reverse ETL, why we adopted it […]
Playbook Part 1: Clean Context, Sharp Answers: Why We Retire Old ETL Tables — Vatico Training If you’ve started poking around the warehouse, you’ve probably noticed three generations of different tables—original ETL tables, ELT first-gen tables, and our current modern ELT tables (ODS → DIM/DWD → DWS → ADS)—layered on top of each other. While […]
How to Draw Flowcharts at Vatico — Intern Reflections This is a reflection on making flowcharts at Vatico — written after having done it wrong the first time. It covers the mistakes we made, the rules we learned, and the mindset shift that finally produced diagrams the team could actually use. If you have a […]
