Toby Mao
@Captaintobs
Followers
2K
Following
4K
Media
260
Statuses
2K
Cofounder and CTO of Tobiko Data. Building SQLMesh and SQLGlot.
San Mateo, CA
Joined December 2013
RT @markrittman: This week’s episode of @drilltodetail features @Captaintobs from @TobikoData on @Airbnb, #DataOps and the engineering inno….
0
3
0
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.
1
5
28
RT @sspaeti: SQLMesh concepts with plans that apply to different environments (prod, dev) are elegant. Even `fetchdf` is integrated into th….
0
8
0
RT @nicoritschel: It surprises me how most poorly most data orchestrators support batch size for backfills. Meanwhile, @SQLMesh open source….
0
2
0
⚠️⚠️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.
1
8
44
RT @TobikoData: Tired of messy data pipelines? 🥹🫣. Check out the @SQLMesh + @dltHub integration for seamless metadata handovers, faster sca….
0
5
0
If you're gonna be in Vegas next week hit me up. We can get coffee or hit the craps table. and talk data :).
0
0
5
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.
1
8
48
RT @DataTalksClub: Featuring SQLMesh on this week's episode of Open-Source Spotlight, our series where we're discovering open-source tools.….
0
2
0
RT @TobikoData: Join @Captaintobs and @Al_Grigor from @DataTalksClub on their Open-Source Spotlight series, where they talk through the ben….
0
3
0
If you’re gonna be at Coalesce in Vegas, make sure to come to @TobikoData’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!.
0
0
4
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.
1
0
32
RT @TobikoData: Want to learn about running your #dbt project with @SQLMesh? . Check out our latest YouTube video to run through a workflow….
0
3
0
RT @TobikoData: Our latest #YouTube #video is up! . #learn how to make changes to your #data #models with @SQLMesh plans! . #opensource #co….
0
2
0
14 years since I started training #bjj, finally got to brown belt! It's been a long journey but I've never quit.
3
0
29
RT @tdoehmen: @Captaintobs I re-ran the DDL parsing experiments, comparing sqlglot 11.4.1 to 25.5.1. Parsing success rate improved by 12.8%….
0
2
0
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?.
0
0
4
RT @ShutUpShow: Shikoku 1889 is a robust and beautifully produced game that, well, might not be for everyone? That’s probably because of al….
0
14
0
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).
3
0
5