Our open-source analytics engineering layer. How we define metrics, transformations, and models in dbt — and why this is the most novel part of bigNOSTRals.
Why dbt?
dbt (data build tool) transforms raw SQL queries into a testable, version-controlled, documentable data product. For bigNOSTRals, this means every metric definition is visible, auditable, and forkable.
Models in the bigNOSTRals dbt Project
The repo defines staging, intermediate, and mart models. Staging cleans raw relay data. Intermediate joins and deduplicates. Marts expose metrics like daily active npubs, zap volume, content velocity, and relay health scores.
A Great Way to Learn Analytics Engineering
Because dbt is open source and widely documented, it is an ideal playground for vibe coders and curious analysts. Fork the repo, add a model, run it locally, and submit a PR. The entire pipeline is transparent.
This article is also published as a kind:30023 NIP-23 event on Nostr.