The problem with this is that you have a consistency problem if you want to take action. The only way of making your agents read-write rather than read-only in practice is to use the underlying systems rather than try and pool information in a data lake.
But that does make it more complex to build simple information retrieval use cases.
You definitely need multiple paths. It's not one vs the other. The data warehouse is immutable to the agent. There are separate tools that handle any updates to business state.
I’m trying to solve this problem and would love to get some feedback: https://entidade.wls-labs.com