You are choosing how to connect a dashboarding layer to an analytics warehouse for a business reporting workflow. The data can be queried either through a live connection or through scheduled extracts, and the choice affects freshness, load, and operational complexity.
When would you choose to use an extract over a live connection, and what are the trade-offs?
