• 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!