dbt: Resources for the Public Sector

A collection of resources around developing dbt projects in the public sector. Open for contributions!

Communities & Communication

• dbt Slack Community, #industry-public-sector channel
• Coalesce 2023 talk: "From coast to coast: implementing dbt in the public sector"
  • slides available here
  • recording is on YouTube here

Featured Blog Posts

• There's a better way: The case for dbt for progressive data professionals by brittany bennett

Public Repos of dbt projects

Boston (Analytics Team)

• https://github.com/CityOfBoston/cob_analytics_dbt_skeleton_project
  • dbt project in the analytics directory, Civis workflows in the civis_workflows directory
  • note that this repo only contains the structure and supporting scripts, and no real models from the original dbt project

California Integrated Travel Project (Cal-ITP)

• https://github.com/cal-itp/data-infra/ (warehouse directory contains dbt project)

CalData

• CalData Infrastructure Template: Template for creating new dbt projects with docs and CI driven through GitHub actions.

• CalData Infrastructure: CalData's data infrastructure (transform directory contains dbt project)