News for hackers. Stuff that matters.
Re:SQL should be your default choice for data engineering pi... by dangwhy on Monday January 30, 2023 @10:21AM (#34580787)
> Even though it’s improved a lot the testing situation in sql is still not where a more traditional programming language is, modularity comes either in the form of ever nested cte, stored procs or dbt style templates.

See my comment here https://news.ycombinator.com/item?id=34580675

I don't use nested cte/stored procedures . I simply extract extract it to a new file and mark it 'ephemeral' in dbt, no different than what you'd do in a regular programming language.

There are no comments on this comment yet.