awesome-sqlmesh

A curated list of awesome SQLMesh resources.

SQLMesh is a Python framework that automates everything needed to run a scalable data transformation platform. SQLMesh works with a variety of engines and orchestrators.

It was created with a focus on both data and organizational scale and works regardless of your data warehouse or SQL engine's capabilities.

You can use SQLMesh with the CLI, Notebook, or Python APIs.

All contributions related to SQLMesh are welcome & encouraged! Please take a look at the contribution guidelines first. Add new entries at the bottom of each category, please.

Contents

• Official Resources
• Sample Projects
• Community Projects
• Tools
• Content
  • Blog Posts
  • Videos

Official Resources

• Official Documentation
• Slack - The team is highly responsive; don't hesitate to reach out.
• SQLMesh Repository
• SQLGlot Repository

Sample Projects

• Examples from the main repo
  • Custom Materializations
  • Ibis - A python SQLMesh model with Ibis
  • Multi - Multiple SQLMesh projects
  • Multi dbt - Multiple dbt projects in a single project
  • Multi Hybrid - dbt project alongside SQLMesh in a single project
  • Sushi
  • Sushi dbt
  • Sushi dlt
  • Wursthall
• Official Example projects
• sqlmesh-demos

Community Projects

• arcane-insight - An analytics, ingestion, transformation project built with SQLMesh & DuckDB on Blizzard's Hearthstone API

Tools

• vscode-sqlmeshui - Embedded SQLMesh UI in VS Code
• buenavista - A fork of a Postgres/DuckDB proxy exposing both the PG and Trino protocols with a SQLMesh metric rewriter

Content

Blog Posts

• Unlocking Data Insights with Ibis and SQLMesh
• SQLMesh for DBT Users 1
• SQLMesh for DBT Users 2
• Efficient Development with the SQLMesh Browser UI

Videos

• Tobiko Data Youtube
• Evolving Data Pipelines at Scale
• Building SQLMesh Macros like dbt macros
• SQLMesh Quickstart Guide
• Running dbt Jaffle shop in SQLMesh