Ten Vital Signs of a Query History
The most valuable thing your analytics team produces is the record of every analysis they have designed and run. It is sitting in your query history, and nothing in your stack is counting it.
That record is the definitions your team settled on, the rules they applied, the joins they worked out, and the questions someone decided were worth asking. It already exists, in full. It is written in SQL, in a log nobody reads.
dbt models the tenth of the work that gets asked on repeat. Everything asked once sits unread: the cohort a client needed by Friday, the washout window one analyst set at six months and another at twelve. That untouched majority is what these ten readings measure.
They tell you how much your team produces, how much can be recovered, how much is stuck in one person's head, and how much has earned enough trust to build on. Taken together they answer one question: is your history becoming an asset, or just getting longer? It becomes an institutional knowledge asset, a set of files your people and your machines can both read, once it is available, searchable, instructive, fresh, and comprehensive.
The last stage is the point. Trust through use is where exhaust becomes gold.
You do not know your ten numbers yet. You can know all ten today, off your own query history, for free.
A semantic model paired with an agent you can rely on, so every metric resolves to one definition, every join is documented, and the answer comes from what your team actually trusts. Built in hours, portable to whatever stack you run next, and yours to keep.