Tobiko Articles

Migrating from one data warehouse to another is challenging and full of manual work. Learn how SQLMesh can help your company automate this process.

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 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.

How can you tell if two SQL queries are the same? Can you do better than just checking if two statements are textually equivalent?

Introducing the Rust implementation of the SQLGlot tokenizer, which significantly improves parsing performance.

How we're trying to build a trustworthy and thriving open source community.

Although companies heavily rely on SQL / data pipelines to power applications and make decisions, testing is usually an afterthought. However, systematic testing of data is critical to creating trustworthy and reliable pipelines. This post highlights the three categories of tests for data: unit tests, table diffs, and audits.

Exploring what semantic understanding is and how it helps improve user experience when using SQL.

Categorizing changes in SQL queries to automatically establish data contracts between producers and consumers.