I'm curious if this product actually works because I was beating my head against almost exactly this very recently.
I haven't checked yet, but is SDF schema-dependent? For some reason, all sql comprehending/transforming tools I can find are either too trivial to be useful or require an exact schema to operate, both of which are too brittle to be useful when I try to use them in anger.
It compiles to SQL, so in since sense yes it is schema dependent. As mentioned in the article DBT itself has no understanding of semantics, so it’s not enforced by DBT directly but if it doesn’t compile to working SQL expressions it’s obviously not going to work.
Comments
I'm curious if this product actually works because I was beating my head against almost exactly this very recently.
I haven't checked yet, but is SDF schema-dependent? For some reason, all sql comprehending/transforming tools I can find are either too trivial to be useful or require an exact schema to operate, both of which are too brittle to be useful when I try to use them in anger.
It compiles to SQL, so in since sense yes it is schema dependent. As mentioned in the article DBT itself has no understanding of semantics, so it’s not enforced by DBT directly but if it doesn’t compile to working SQL expressions it’s obviously not going to work.