Intermediate · 30 min · 5 steps
Checking a new batch of data in a waiting room before it reaches customers
Ananya Deshmukh, Senior Analytics Engineer at FinSaaS Technologies
It is 7:45 AM on a Wednesday. Ananya Deshmukh, an analytics engineer at FinSaaS Technologies, sits down at her desk and finds an urgent message from the Head of Customer Success. FinSaaS sells billing and subscription software to more than 15,000 mid-sized companies across Asia.
The question
How can we load new account data into a separate staging table, check it with SQL, and only then let customers see it?
- WAP pattern
- Staging tables
- Data validation
- Atomic publication
The rest of this case study is locked
The data, every step with its code and result, and the final answer open with a pass. A few case studies stay free so you can see how they work.