Project Variables in SQLMesh: Non-obvious Challenges
SQLMesh now supports project-wide variables to help you parameterize your projects. This feature has some interesting implementation challenges, which we dive into in this post.
Tobiko Articles
-
-
The Future of Tobiko - From Sinks to SQL
Announcing our funding and the availability of Tobiko Cloud
-
Unlocking Data Insights with Ibis and SQLMesh
Combine the power of SQLMesh and Ibis to streamline your data analysis workflow
-
How I became an AST convert
A walkthrough by our solutions architect, Afzal Jasani, on changing his mental model of how SQLMesh works and how the underlying mechanics are extremely valuable.
-
How SQLMesh reduces warehouse costs with cron and partitions
Learn about how SQLMesh saves money with cron and partitions.
-
Column level lineage for dbt
Step by step guide for column level lineage within your dbt project.
-
Transpiling SQL #1: JSON Paths
Transpiling SQL is a hard problem. This blog series uses real-world transpilation challenges to explain how SQLGlot, the transpilation framework powering SQLMesh, tries to solve it.
-
Metadata everywhere!
Creating, updating, and locating project metadata is a hassle. SQLMesh makes it easier by letting models speak for themselves: inline comments automatically registered with your SQL engine.
-
Are these SQL queries the same?
How can you tell if two SQL queries are the same? Can you do better than just checking if two statements are textually equivalent?
-
SQLGlot Jumps on the Rust Bandwagon
Introducing the Rust implementation of the SQLGlot tokenizer, which significantly improves parsing performance.