Re:Launch HN: Serra (YC S23) – Open-source, Python-based dbt...
by Alanhlwang on Tuesday August 15, 2023 @02:51AM
(#37130986)
Definitely, I can jump into what we meant by brittle—we mainly meant that SQL scripts are hard to debug/undescriptive, you can't parametrize and customize error messages that you receive from transforms, and you can only execute one complete statement at a time that are often chained together with CTEs (which is a nightmare if its a statement of 400 lines of SQL). Python makes it easier to debug since we turn the approach from a declarative to a procedural one, and that's even the case with breakpoints when you write your actual transformers in Python.
[ Parent
| on HN ]
There are no comments on this comment yet.