Today dbt announced column level lineage... but it's not open source and only available for paying cloud users. dbt is using SQLGlot (an open source SQL framework that my company @TobikoData maintains) to power this newly gated feature. SQLGlot's lineage wouldn't exist without the open source community so it's kind of a shame. But there's an open source alternative to dbt cloud... @SQLMesh, where column level lineage is free and open source for everyone to use. SQLMesh is backwards compatible with existing dbt projects, so you can gain all of its benefits without rewriting your project. Check out our blog post about lineage through SQLMesh's open source UI / IDE. tobikodata.com/sqlmesh-ui.ht… If you want to chat about how we can make data transformation better for everyone, we'd love to chat in our slack channel at tobikodata.com/slack.

Unlike dbt, SQLMesh was designed to work efficiently with extremely large scales of data. Stop hemorrhaging money and stop wasting time manually managing big data sets! We've spent a lot of time on automated frameworks for working with massive data. tobikodata.com/evolving-larg…

@SQLMesh v0.28.0 supports MSSQL (Microsoft SQL Server). Even better, it was contributed by a community member Dan! I'm so excited to see SQLMesh grow and gain traction! github.com/TobikoData/sqlmes… sqlmesh.readthedocs.io/en/st… #dataengineering

Are you using dbt and have heard of @SQLMesh but aren't quite sure what it is? You are in luck, because this article is for you! We will teach you the basics of SQLMesh from a dbt user's perspective to help get you up to speed. tobikodata.com/sqlmesh_for_d…

Although companies heavily rely on SQL / data pipelines to power applications and make decisions, testing is usually an afterthought. However, systematic testing of data is critical to creating trustworthy and reliable pipelines. tobikodata.com/we-need-even-…

As the usage of dbt grows, the cracks in its architecture become more apparent. You can either have simplicity or efficiency... but why should you have to choose? Check out this amazing blog post by @izeigerman detailing the costs associated with dbt. tobikodata.com/simplicity-or…

We spend so much time writing #SQL. Why don't our tools understand SQL? When you parse SQL you unlock: - Column Level Lineage - Automatic dependencies (no more {{ ref() }}) - Transpilation Check out this great post by @izeigerman tobikodata.com/semantic-unde…

SQLMesh v0.8.0 just dropped! Some exciting new features like docs which is integrated inside the IDE! We've also launched our Github CI / CD bot! sqlmesh.readthedocs.io/en/st…

I wrote a post hoping to demystify incremental loads for data pipelines. Even if you don't have Netflix's data scale, incremental loads can save you time and money! tobikodata.com/correctly-loa… #dataengineering #sql

Yesterday, dbt announced contracts and versions. They're just additional YAML syntax further contributing to the pile of spaghetti code/configs. It puts even more burden on the end user without solving the underlying problems. tobikodata.com/the-false-pro…

I love how DevOps enables software engineers to safely ship code faster. As a data engineer, I think we deserve something similar: the DataOps revolution. Here’s a 🧵 on why I made SQLMesh, an open source DataOps framework, which launches today github.com/TobikoData/sqlmes…