Surfalytics
All pet projects
Data Engineering intermediate ⏱ 6–8 hours

SQLMesh: Next-Gen Data Transformation

Explore SQLMesh as a modern alternative to dbt — automatic change detection, virtual environments, and built-in state management.

SQLMeshSQLTransformationdbt Alternative
View project on GitHub

What you’ll build

A SQLMesh project that demonstrates its key differentiators over dbt: virtual data environments, automatic incremental computation based on semantic understanding, and plan/apply workflow. Great for anyone evaluating the next generation of transformation tools.

Skills you’ll practice

  • SQLMesh project structure and configuration
  • Models: full vs incremental vs seed
  • Plan and apply workflow (like Terraform for data)
  • Virtual environments for safe development and testing