Toby Mao (@captaintobs) 's Twitter Profile
Toby Mao

@captaintobs

Cofounder and CTO of Tobiko Data. Building SQLMesh and SQLGlot.

ID: 2225384346

linkhttps://sqlmesh.com calendar_today01-12-2013 18:25:07

1,1K Tweet

2,2K Followers

363 Following

Toby Mao (@captaintobs) 's Twitter Profile Photo

Wow I relate to this comment so much! This is basically what happened to me and how I discovered I was allergic to bananas! I thought bananas were just like pineapples (mouth pain / tingling).

Wow I relate to this comment so much! This is basically what happened to me and how I discovered I was allergic to bananas!

I thought bananas were just like pineapples (mouth pain / tingling).
Shut Up & Sit Down (@shutupshow) 's Twitter Profile Photo

Shikoku 1889 is a robust and beautifully produced game that, well, might not be for everyone? That’s probably because of all the spreadsheets, but we promise there’s a devious GAME under the hood that’s oh-so-satisfying for ‘number enjoyers’. Link below!

Shikoku 1889 is a robust and beautifully produced game that, well, might not be for everyone? That’s probably because of all the spreadsheets, but we promise there’s a devious GAME under the hood that’s oh-so-satisfying for ‘number enjoyers’.

Link below!
Toby Mao (@captaintobs) 's Twitter Profile Photo

I’m gonna be in New Jersey tomorrow for a wedding by Florham Park. Looking to eat some great pizza for lunch but don’t have anyone to go with (lots of places only serve a whole pie). Anyone wanna meet up?

Till Döhmen (@tdoehmen) 's Twitter Profile Photo

Toby Mao I re-ran the DDL parsing experiments, comparing sqlglot 11.4.1 to 25.5.1. Parsing success rate improved by 12.8%, and also alignment with pglast improved substantially (up to 17.5%). More details in the charts. Published the experiment code in our repo github.com/amsterdata/sch…

<a href="/Captaintobs/">Toby Mao</a> I re-ran the DDL parsing experiments, comparing sqlglot 11.4.1 to 25.5.1. Parsing success rate improved by 12.8%, and also alignment with pglast improved substantially (up to 17.5%). More details in the charts. Published the experiment code in our repo  github.com/amsterdata/sch…
Tobiko Data (@tobikodata) 's Twitter Profile Photo

Our latest #YouTube #video is up! #learn how to make changes to your #data #models with SQLMesh plans! #opensource #community #tutorial youtu.be/BWwJTkvt_A8

Tobiko Data (@tobikodata) 's Twitter Profile Photo

Want to learn about running your #dbt project with SQLMesh? Check out our latest YouTube video to run through a workflow using the classic Jaffle Shop example project! youtube.com/watch?v=X9RA6a…

Toby Mao (@captaintobs) 's Twitter Profile Photo

As a data engineer, you should consider how changes can be done in a non-breaking way. A non-breaking change to a data model is something that won't have any down stream impact, like adding a column or re-ordering columns. Adding columns only impacts down stream models when

Toby Mao (@captaintobs) 's Twitter Profile Photo

If you’re gonna be at Coalesce in Vegas, make sure to come to Tobiko Data’s happy hour October 8 at 5pm! Also if you just wanna meet up with me and grab a coffee, I’d love to chat! DM me! cube.registration.goldcast.io/events/0936487…

Tobiko Data (@tobikodata) 's Twitter Profile Photo

Join Toby Mao and Alexey Grigorev from DataTalksClub on their Open-Source Spotlight series, where they talk through the benefits of SQLMesh like: ♦ Column-level lineage ♦ Environment Management ♦ Instant Prod deployments and much more! youtu.be/ASiBidAFdwM

DataTalksClub (@datatalksclub) 's Twitter Profile Photo

Featuring SQLMesh on this week's episode of Open-Source Spotlight, our series where we're discovering open-source tools. Tobiko Data's Toby Mao, Toby Mao, joined us in demonstrating how this tool can help data team workflows. Watch the demo here: youtu.be/ASiBidAFdwM

Toby Mao (@captaintobs) 's Twitter Profile Photo

The wait is over! You can now use Athena with SQLMesh. Both Iceberg and Hive are supported but we heavily recommend Iceberg since it's a way better experience. And if you're still stuck on dbt, don't worry, we also have support for the dbt-athena adapter so you can have a

Tobiko Data (@tobikodata) 's Twitter Profile Photo

Tired of messy data pipelines? 🥹🫣 Check out the SQLMesh + dltHub integration for seamless metadata handovers, faster scaffolding, and incremental processing. 💻 Simplify your data workflows! 🔗 tobikodata.com/integrated-dat… #DataEngineering #DataPipelines

Tired of messy data pipelines? 🥹🫣

Check out the <a href="/SQLMesh/">SQLMesh</a> + <a href="/dltHub/">dltHub</a> integration for seamless metadata handovers, faster scaffolding, and incremental processing. 💻

Simplify your data workflows! 🔗
tobikodata.com/integrated-dat…

#DataEngineering #DataPipelines
Toby Mao (@captaintobs) 's Twitter Profile Photo

⚠️⚠️Read this before you start using dbt's microbatch models. There are three large gaps that could lead to serious data issues. Due to fundamental architectural design choices of dbt, the microbatch implementation is very limited. At its core, dbt is a stateless scripting tool

Nico Ritschel (@nicoritschel) 's Twitter Profile Photo

It surprises me how most poorly most data orchestrators support batch size for backfills Meanwhile, SQLMesh open source supports out of the box

It surprises me how most poorly most data orchestrators support batch size for backfills

Meanwhile, <a href="/SQLMesh/">SQLMesh</a> open source supports out of the box
Simon Späti 🦋 (@sspaeti) 's Twitter Profile Photo

SQLMesh concepts with plans that apply to different environments (prod, dev) are elegant. Even `fetchdf` is integrated into the CLI. Also, on the right, you see SQLMesh auto-detecting the new columns as non-breaking and simply applying the (virtual) changes `y`.

SQLMesh concepts with plans that apply to different environments (prod, dev) are elegant. Even `fetchdf` is integrated into the CLI. 

Also, on the right, you see SQLMesh auto-detecting the new columns as non-breaking and simply applying the (virtual) changes `y`.
Toby Mao (@captaintobs) 's Twitter Profile Photo

Exciting new feature for SQLMesh. Custom signals / triggers. SQLMesh's built-in scheduler controls which models are evaluated when the sqlmesh run command is executed. It determines whether to evaluate a model based on whether the model's cron has elapsed since the previous