ETL pipeline using dbt and BigQuery to analyse on-chain stablecoin flows, entity distribution, and revenue distribution across subharan Africa
# blockops-stablecoin-pipeline
ETL pipeline using dbt and BigQuery to analyse on-chain stablecoin flows, entity distribution, and revenue distribution across subharan Africa
# Project Overview
A reproducible data pipeline to model stablecoin flows and value capture across Sub-Saharan Africa. Built for BlockOps Network.
# Tech Stack
- **dbt** – SQL transformations, testing, documentation
- **BigQuery** – Data warehouse
- **Dune / Allium / Artemis** – On-chain data sources
- **GitHub** – Version control