Comparison
Cost attributionvsQuery cost
Cost attribution
every query is tagged with a team, so the monthly bill can be broken down by who actually spent it.
Assigning warehouse spend to the teams, pipelines or dashboards responsible for it. Making the numbers visible per team is usually enough on its own to change behaviour, which is why showback tends to work about as well as chargeback and causes fewer arguments. It requires tagging at query time, so it has to be built into how workloads connect rather than reconstructed afterwards from logs.
Full entry →Query cost
one dashboard refreshing every five minutes turned out to be a third of the monthly warehouse bill.
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.
Full entry →