kathryn_cowie
10/18/2022, 4:53 PMI’m struggling to justify:
• the amount of configuration/code written
• the added dependencies for meltano/DBT. more dependencies =
◦ devops / maintenance burden
◦ developer learning overhead
◦ security risk
that this solution entails.He proposed a "pure postgres solution that is transactional, enforces constraints, is trivially testable, and cleans itself up"
Could you explain why you’re a proponent of Meltano/DBT for this job?I can answer this for my use case in analytics... but not sure about the operational case. Any thoughts on how to respond? or which solution is more logical? What advantages are yielded in this situation where's theres only 1, straightforward source?
aaronsteers
10/18/2022, 5:24 PMaaronsteers
10/18/2022, 5:26 PMaaronsteers
10/18/2022, 5:34 PMchristoph
10/18/2022, 8:16 PMCompare that with store procedures or other scripts directly in the database - someone will find them 2 or 5 years later and will have no idea how to maintain them, or if they are still even needed.IMO, this is the key benefit of why Schema Management as code (alembic) and DataOps (Meltano,dbt) are beneficial. Traceability and Visibility and built-in documentation provide a solution that "explains itself" AND that can support "code (git) archaeology" (that's my favourite part)
kathryn_cowie
10/18/2022, 9:20 PMkathryn_cowie
10/18/2022, 9:26 PM"it’s hard to disentangle 'things that just work' from things that i’m familiar/comfortable with"
christoph
10/18/2022, 9:34 PM