How should I move and process this data?
Start from what the consumer cannot currently do, not from what the source happens to produce. Reasoning in the other direction is how a platform fills with datasets nobody uses — and every leaf here states what its recommendation costs, because a recommendation without a cost is an advertisement.
Lake, warehouse, lakehouse, mart or nowhere at all. The question is never which is best — it is which capability you are currently missing, and what the answer costs you.