Data engineering·Cost, layout and query performance
one dashboard refreshing every five minutes turned out to be a third of the monthly warehouse bill.
Query cost
Also calledcost per query, compute spend
What a query costs in money, whether billed per byte scanned or per second of warehouse time. Making it visible per query, per user and per dashboard is the intervention that changes behaviour, because the expensive things are almost never the ones people suspect. The usual finding is that a handful of scheduled refreshes dominate, and the fix is a schedule change rather than any SQL at all.