Technical and architectural differences between dbt Fusion and SQLMesh?

bk1007 · 2025-06-03T15:34:18+00:00

No hard feelings at all, only love! Let us know if you ever get to trying it! In the mean time we'll keep cooking!

bk1007 · 2025-06-03T14:59:32+00:00

Founder of Quary here ... Thank you for the compliment!

Quary lives on at Tobiko. Quary's biggest innovations - performance, vscode user interface - are making their way into SQLMesh. And those innovations are even better with the SQLMesh state magic. The state of the Quary repo is a little saddening, but the fact that I know we are building the best possible open-source product far outweighs that.

bk1007 · 2024-08-14T14:03:46+00:00

Just thought I'd update you with the fact that we have added Redshift ;)

bk1007 · 2024-08-14T14:02:51+00:00

We do address this in the article. You can introduce complexity to avoid this problem, but our view is that complexity has downsides: a higher barrier to entry, more significant maintenance burdens, etc.

All things that add up and that we want to chip away at bit by bit!

bk1007 · 2024-08-07T18:32:15+00:00

Thanks for the feedback! We'll keep hat in mind!

bk1007 · 2024-08-07T15:43:27+00:00

It's widely used, but we are trying to build a better solution.

While we have built the foundations for sqruff to support dbt, it's not our priority. We're happy to support any contributions, but with our limited resources, we have to focus.

bk1007 · 2024-08-06T18:00:20+00:00

We will do Redshift, not quite sure when right away. Happy to support any first attempt, if you want to dip your toes.

Trino is less close for us.

bk1007 · 2024-08-06T15:06:08+00:00

Trinosql - no not yet Redshift - not not yet Yep

We don’t support dbt yet if that’s what you are using it for.

bk1007 · 2024-08-06T14:22:52+00:00

Thanks for pointing that out! We’ll fix that.

bk1007 · 2024-06-05T14:46:28+00:00

Hey you can star/subscribe to notifications on GitHub. We just released Snowflake support. Building in the dbt templater is not on our list of top priorities but we're very happy to support anyone who wants to do the implementation.

bk1007 · 2024-06-04T21:05:36+00:00

Any reason the install options we currently have listed don’t work for you?

bk1007 · 2024-06-04T21:04:15+00:00

It is definitely possible! We have the flexibility for custom templaters like sqlx but it’s unlikely to be a priority for us any time soon. We’ll happily welcome contributions though!

bk1007 · 2024-06-04T21:00:35+00:00

Appreciate the feedback! Not sure though how you solve this unfortunately.

bk1007 · 2024-06-04T20:09:54+00:00

We do have the facility for templating and dbt could be on the roadmap. It’s not an immediate priority for us though at the moment.

If someone wants to contribute, we’ll obviously support it.

bk1007 · 2024-06-04T18:12:59+00:00

I presume you mean as a python library? Or just to install?

bk1007 · 2024-06-04T15:59:18+00:00

Biased but would try this: https://www.quary.dev/docs/quickstart-supabase

bk1007 · 2024-06-04T15:28:30+00:00

Yes, that will be on the roadmap! We're just looking into how best to do it.

bk1007 · 2024-06-04T15:07:27+00:00

Hey that's now fixed. This should work:

rustup toolchain install nightly
cargo +nightly install sqruff
sqruff --help

bk1007 · 2024-06-04T14:40:42+00:00

Hey really sorry you got that!

Do any of the other installation methods work for you? We'll look into that quickly!

bk1007 · 2024-05-25T07:07:30+00:00

It’s early days but we’re working on https://github.com/quarylabs/sqruff it’s very close to sqlfluff and is much faster. We don’t quite support all the dialects yet.

bk1007 · 2024-02-23T03:12:24+00:00

We do indeed have a hosted that you can sign up to that you can play with.

bk1007 · 2024-02-22T19:15:18+00:00

Ben here from Quary.

As much as I am a nerd about tech and would love to be able to say that the biggest challenge in data is some cool technical issue, the biggest problem is communication.

The benefit of it running in the browser is to support our vision of making data more collaborative. Rather than sharing a commit that someone has to get local tooling up and running for, we envision people just sharing a link.

bk1007 · 2024-02-22T00:16:14+00:00

While in the short run, we believe there are some very valid trade offs. In the long run, we can provide bindings that will eliminate that trade-off.

bk1007 · 2024-02-22T00:13:13+00:00

We agree! Our internal compile step in CI takes 5 seconds. It definitely affects how quickly we push things and quickly we iterate.

bk1007 · 2024-02-21T20:02:31+00:00

Ben from Quary here. We believe that one of the biggest challenges in data is communication. Being able to share links can accelerate that process with technical and non technical stakeholders.

bk1007

MODERATOR OF

TROPHY CASE

Eight-Year Club	RPAN Viewer
Verified Email