Comparing system of record counts with warehouse scans:
The term portage —historically meaning the carrying of boats or goods between navigable waters—aptly describes the role of this SQL pattern: transporting data across disconnected systems with minimal friction. portage sql
-- Run this on Target SELECT COUNT(*), SUM(revenue) FROM orders_archived; Comparing system of record counts with warehouse scans: