Bitcoin Cash ELT Pipeline

ELT pipeline on Bitcoin Cash blockchain data with dbt, BigQuery and automated SQL linting in CI.

Code Link

Bitcoin Cash ELT Pipeline screenshot

Project overview Link to heading

ELT pipeline transforming Bitcoin Cash blockchain data (BigQuery public data) with dbt Cloud, with a staging layer and a datamart layer.

A CI/CD workflow with GitHub Actions automatically lints the SQL queries with SQLFluff, to keep the code quality consistent.

Tools used

  • dbt
  • BigQuery
  • GitHub Actions
  • SQLFluff