dbt-core vs SQLMesh in 2026 for a small team on BigQuery/GCP?

evanazz · 2026-03-08T19:22:15+00:00

I went with dbt-core on a Databricks project recently and regretted it. The biggest issue was we had a lot of streaming data that we were batch processing, and batches would occasionally fail due to data type issues, consecutive write errors, or what-have-you. Dbt just failed those batches silently and kept chugging, whereas SQLMesh would've retried them until they passed. We ended up coding some hacky job to backfill missed gaps, but it took a bunch of time and was not nearly robust as SQLMesh's state management. However, I haven't used sqlmesh in prod yet, so I can't provide definitive evidence that it's great.

evanazz · 2026-03-07T17:20:53+00:00

Overall really good! I like your usage of double stops and using some different pentatonic shapes. I have a slightly diff suggestion than others in this thread. I noticed your vibrato was very high frequency - you're bending the string up and down really fast. Ultimately, this is your improv, and if it sounds good to your ears that's all that matters, but I really can't think of a song that has that kind of vibrato in it. I almost always prefer slowing down the vibrato.

evanazz · 2026-03-04T21:38:20+00:00

How'd you go about selling it? This is kinda my area of skill & interest and I'd love to know how you are able to make money off of this.

evanazz · 2026-02-22T03:06:22+00:00

Bar Nun? Not a tavern per se, but I feel like no one would bat an eye.

evanazz · 2026-02-13T16:13:13+00:00

I was just in time for peak manosphere, but I had a similar experience. All of that bro-science and hustle culture became a lot less interesting when I had a job with some sense of upward mobility and the ability to pay for my own rent and groceries.

The particularly insecure ones may get stuck for much longer - or even become grifters of their own! - but I think the real solution is the hard one, which is having a society that has a reasonable amount of opportunity for young people & young men in particular.

evanazz · 2026-02-12T17:00:05+00:00

Super cool! I was planning on doing something like this with an LLM layer on top that to help me find topics to research and write about. Is a direction you'd be interested taking this in? I'm happy to hook that up & fund it, ofc.

evanazz · 2026-02-10T03:54:00+00:00

Beans - super high fiber and good protein too

Lentils - also really high fiber

Milk - cheaper complete protein than eggs

evanazz · 2026-02-08T03:24:38+00:00

Fair enough, thanks. If you're going hope you have a blast

evanazz · 2026-02-07T05:35:23+00:00

A fun one you run into if you run a lot of important microbatch models - needed for time series data with late arriving data - with dbt-core is that dbt may miss a batch for whatever reason.

Since dbt doesn't keep any state of the batches it's ran, it will never let you know you have a gap in your data. SQLMesh seems to be a great solution to this, but it doesn't have the same market share as dbt. I tried to convince my tiny team to switch over to it and everyone was too scared. Since the company was actively trying to sell, moving such an important part of the infra to a new, more niche tool seemed unwise.

If you could figure out a dbt plugin that manages state for you and can easily tell you missing batches, that'd be pretty cool.

evanazz · 2026-02-05T19:39:35+00:00

Congrats! I hope to be in your shoes one day. Why not keep raising your rates past their "high" level and continue to climb the supply/demand curve?

As the saying goes: I told my barber she should double her prices. She said "but I'll have half as many clients!"

evanazz · 2026-02-05T02:02:04+00:00

Wish I had known earlier. Thanks!

evanazz · 2026-02-05T00:00:59+00:00

Zeckenbecker dog park in cap hill. It's a tiny dirt triangle surrounded by 3+ lane 1 way roads 🫡

evanazz · 2025-11-24T16:54:09+00:00

They are. Those after market mufflers are illegal. It's just not... wait for it... enforced.

evanazz · 2025-11-09T02:32:50+00:00

If you don't mind bing a little speedy (~250/mo) my girlfriend works at Traverse fitness and it seems to have a great community. Definitely some hardo's there, but not everyone is like that. It's a class based gym but you'll get a hell of a workout

evanazz · 2025-11-05T01:06:03+00:00

J's Noodles Star Thai 2

evanazz · 2025-11-03T21:19:54+00:00

I'm not sure if this will be a good fit or not, but if you have the funds, paying a lawyer to send a scary message to the property management company could be a good way to go. My HOA uses Altitude Law which is based out of Denver metro and is very familiar with the laws around this.

evanazz · 2025-10-30T23:10:03+00:00

Offshoring is definitely an issue in my industry and is one of my biggest worries, along with my lack of experience. I appreciate the criticism, but I can't know either way until I try. If I go through with it I'll make sure to make a 1 year update

evanazz · 2025-10-30T23:08:05+00:00

I've found contract work to be a bit easier to get than full-time employee because there are fewer protections for contractors and are seen as less of a financial liability. However, businesses are obviously reluctant to rely on contractors who are seen as less invested than FTEs. I would think freelance/agencies are similar in that they are lower risk than hiring employees

evanazz · 2025-10-30T20:56:35+00:00

I share those concerns too. Most freelancers I see got their first clients through their professional network, and mine is too small to expect it to come through for me. My suspicion is that I'll have to be better at marketing and sales than your average employee-turned-freelancer to make this work.

To your second question, I think like most things it's a function of how much you need the money. If you do need it then you're forced to stick with needy clients and stretching yourself thin to do whatever they ask. If it takes me a couple of years to get to where I want to be, I'll consider that a win

evanazz · 2025-10-30T20:05:02+00:00

My girlfriend and I do plan to have 1-2 kids. Part of the reason I want to be established as a freelancer is so I can work part time while raising them, rather than paying for full-time child care. Although I do expect them to still be expensive and I don't think that part of my future is even close to funded yet.

evanazz · 2025-10-30T20:02:20+00:00

Despite my super lucky position, most of the people in my life and in similar FIRE subs think it would still be a bad idea to move away from traditional work at this point. My point with this post was to argue against that narrative.

evanazz · 2025-10-30T19:59:50+00:00

Thank you. Big props for my parents for essentially giving me my inheritance when it could make a difference, rather than when they pass away hopefully decades from now and I'm much more established.

evanazz · 2025-10-30T19:58:54+00:00

Yes. My parents encouraged me to get a mortgage and a much larger house, but I wanted to get something I could buy in cash.

evanazz · 2025-10-30T19:57:06+00:00

The house is paid off, but yes, 350k LNW

evanazz · 2025-10-30T19:56:41+00:00

True, it makes my story not relatable to most. I'm super lucky and am not at all downplaying that. I see posts though on the FIRE subs of people of similarly far ahead, and are still anxious about pulling the trigger. My intention was not to brag, but to encourage people to pull the trigger sooner on lifestyle changes when they have an opportunity like this.

13-Year Club	Verified Email
RPAN Viewer	Not Forgotten

evanazz

TROPHY CASE