- CASE WHEN
- Posts
- 🕸️ MDS Chat w/ Matt #1 - SQLMesh
🕸️ MDS Chat w/ Matt #1 - SQLMesh
A challenger to dbt that could revolutionize SQL-based data transformation
🤩 It's the first MDS Chat with Matt!
This week we're talking about SQLMesh— this is a tool I think has a TON of potential in the SQL transformation/orchestration space (thanks Tobiko Data!)
Check out the video below for the full scoop 🍦, but here are a few features I find useful:
1️⃣ Virtual Data Environments: super super cool functionality that I DEFINITELY don't do justice. Read more here: https://tobikodata.com/virtual-data-environments.html
2️⃣ Built-in orchestrator support: ever tried to run dbt inside Airflow? 😱 Then you probably know what a nightmare this is. SQLMesh comes out-of-the-box with Airflow support and forthcoming support for a few other orchestration tools
3️⃣ Column-level lineage: it's 2023! We should know where our columns came from! Sorry, dbt, but SQLMesh has me blown away with this one.
What do you think of SQLMesh? Let's hear it!