↓ Skip to main content
  1. My Projects/

SQL Data Comparison Tool

This is a python data quality assurance tool that allows you to verify whether the data model changes you have made are producing the data as you intended.

The python script does it by generating tables that show which rows have changed and what data in those rows has changed.

It allows you to see…

  • Which rows changed
  • What columns changed (including previous and new values)
  • Which rows were added
  • And which rows were deleted

fzf-dbt Screenshot

I wrote a blog post for Metabase showing how to use it and you can find an updated version of that post on this blog.