2. OLTP vs OLAP and the Modern Data Stack
2.2 Why Copy Out of the App DB
By Ravindra Bagale · Last updated:
Why. “Just query production” feels clever until month-end.
What. Copying (ETL/ELT) isolates analytics load, lets you reshape history, and protects the cashier experience.
How. Batch extract off-peak → stage → transform → warehouse tables.