2 ms·
I'm a little skeptical of dedicated BI teams as the sole oracles of correct queries. In my experience it's sadly common for an engineering team to make a schema
by simonw 2y ago
I'm a little skeptical of dedicated BI teams as the sole oracles of correct queries. In my experience it's sadly common for an engineering team to make a schema or product design change that isn't instantly obvious to the BI team, resulting in incorrect queries.
I think the best way to address this is to aim for a culture of transparency: any time anyone in a company presents a report or dashboard or similar, the query that was used to create it needs to be easily accessible. That way there's a much higher chance of mistakes being spotted. The BI equivalent of "given enough eyeballs, all bugs are shallow".
Another cultural trick that's important is that engineering teams need to consider schema changes as part of their documented and supported API. If a change might affect BI reports the people who write and use those reports need to be told about it.