3 ms·
Heh, I was just starting to look at SDF and SQL Mesh to see if they actually addressed any of the dbt pain points.
by 0cf8612b2e1e 2y ago
Heh, I was just starting to look at SDF and SQL Mesh to see if they actually addressed any of the dbt pain points.
- mritchie712 2y agoSame. dbt feels like angularjs, I want the svelte alternative.
- wood_spirit 2y agoWhat is your initial impression and pros and cons? (Asking as I kinda wish my company’s opinionated dbt had made some different choices)
- apwell23 2y agocon is some ppl just go crazy with jinja and create a mess. Its fine if you just stick to the basics.
- grajaganDev 2y agoPlease watch out for Server Side Template Injection.
- talos_ 2y agodbt needs to play catch up against SQLMesh feature-wise, so they bought their other competitor SDF. SQLMesh seems to have more development velocity, and dbt will need to execute a smooth transition and integration to catch up. For context, the team behind SQLMesh also develops SQLGlot, which powers the features dbt attempts to implement
- NortySpock 2y agoTo expand on this, dbt uses Jinja templating in your SQL to allow the developer to modify the query so it can be expanded at "compile-time" into the target database SQL dialect. (uni-directional, write once deploy anywhere). The key features are CICD, test automation, and transformation sequence automation. SQLGlot is a Abstract Symbol Tree SQL Dialect transpiler that could (in theory) convert from one dialect to another (bi-directional). SQLMesh appears to combine both of the above into one tool that sounds like it's even better.