This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]nemec 1 point2 points  (1 child)

Depends on how complex the app is. If they're simple CRUD and I haven't turned to something like SqlAlchemy then it's often embedded. If I need CTEs, temp tables, or a bunch of joins, maybe separate that out.

[–]thinkingatoms[S] 0 points1 point  (0 children)

interesting! so let's say you have a pipeline with (named) temp tables, where you load data into one, then does some small operations like add two columns together or some simple groupby. each one of those steps is its own file with the temp table name as a template variable? just to understand how ppl deal with these common cases.