dbt vs SQLMesh: An Honest Comparison on a Self-Hosted Lakehouse
A technical comparison details the challenges and solutions encountered when running dbt and SQLMesh simultaneously on a self-hosted lakehouse environment. The author outlines a specific stack including PostgreSQL, SeaweedFS, Nessie, Trino, and Dremio, highlighting hardware constraints. A key blocker was Trino's inability to create views with native Nessie catalogs, which was overcome by utilizing Nessie's Iceberg REST catalog endpoint. AI
IMPACT Niche tooling improvement; minimal industry-wide impact.