Automated Data Warehouse Migrations
Migrating from one data warehouse to another is challenging and full of manual work. Learn how SQLMesh can help your company automate this process.
Tobiko Articles
-
-
Docs + Testing: Are We Optimizing for the Wrong Thing?
How much context and assurance do I need to know I’m developing in the right direction?
-
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.
-
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.
-
Traps and Pitfalls of Using SQL with Jinja
The practice of augmenting SQL code with Jinja templates has gained significant traction and is consistently growing in popularity. However, is this truly the optimal approach? In this article, we examine the common challenges that arise when combining SQL and Jinja, while also suggesting a more effective method for metaprogramming in SQL.