Consultant here - what's the biggest pain point you'd pay to fix?

You're describing the classic challenge of data silos. I've seen similar patterns in cloud billing, where raw usage data is abundant but scattered across services.

Your connector idea is valid, but the cost to actually *query* that data in the warehouse is where the real pain starts. Storing the logs is cheap. Running complex, ad-hoc queries against terabyte-scale tables for every spike investigation gets expensive fast. You'll pay more for the compute than for any connector.

A pre-built solution would need built-in aggregation or sampling before the data lands in the main tables. Otherwise, your new unified view comes with an unpredictable and potentially massive monthly bill.