I'm pretty sure that `dbt compile` should give you the SQL generated from the macros.
Not to distract from your core point (which I agree with) but just pointing out that I feel like the compile approach above will solve the current problem you're having.
I'm pretty sure that `dbt compile` should give you the SQL generated from the macros.
Not to distract from your core point (which I agree with) but just pointing out that I feel like the compile approach above will solve the current problem you're having.
Take a look at Dataiku. I'm sure you'd be surprised and pleased.