Tobiko Articles

1. SQLMesh for dbt Users - Part 2

   Are you using dbt and have heard of SQLMesh, but aren't quite sure what it is? This post will teach you the basics of SQLMesh from a dbt user's perspective to help get you up to speed. Part 2 of 2.

2. Introducing SQLMesh’s Open Source CI/CD Bot

   Introduces the SQLMesh's open source CI/CD bot and how it can be used to automate the deployment of data pipelines.

3. SQLMesh for dbt Users - Part 1

   Are you using dbt and have heard of SQLMesh, but aren't quite sure what it is? This post will teach you the basics of SQLMesh from a dbt user's perspective to help get you up to speed.

4. Data Load Patterns 101: Full Refresh and Incremental

   Explore the two fundamental methods of loading data (Full Refresh and Incremental). Learn about two common approaches for determining what data to load incrementally and how they compare.

5. We Need Even Greater Expectations When Testing Data

   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.

6. Simplicity or Efficiency: How dbt Makes You Choose

   Comparing development experience and runtime efficiency of dbt and SQLMesh.

7. Semantic Understanding of SQL

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

8. Correctly Loading Incremental Data at Scale

   Writing efficient and correct incremental pipelines is challenging. While many folks do take on the challenge of writing incremental models, it is viewed as an advanced use case which could discourage teams from adopting incremental loads.

9. Automatically detecting breaking changes in SQL queries

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

10. The False Promise of dbt Contracts

    Creating highly efficient and scalable development environments for data.

<<  < Page 3 / 4 >  >>