dbt factory: re-usable sql, configured through YAML, compiled to dbt

#1

Post by conradbez » Thu, Oct 19, 2023, 1:42 AM UTC

dbt factory: re-usable sql, configured through YAML, compiled to dbt
github.com

Re: dbt factory: re-usable sql, configured through YAML, compiled to dbt

#2

Post by conradbez » Thu, Oct 19, 2023, 1:42 AM UTC

Write re-usable sql code blocks and compile it to a dbt project with a yaml defintion

Great for:

- Automating dbt code generation, so you can manipulate yaml instead of sql

- Construct pipeline without knowing SQL

- Construct pipelines without learning dbt

- Avoid duplicative code

Re: dbt factory: re-usable sql, configured through YAML, compiled to dbt

#3

Post by sargstuff » Thu, Oct 19, 2023, 4:56 AM UTC

conradbez wrote: post #2

Write re-usable sql code blocks and compile it to a dbt project with a yaml defintion Great for: - Automating dbt code generation, so you can manipulate yaml instead of sql - Construct pipeline without knowing SQL - Construct pipelines without learning dbt - Avoid duplicative code

Is there an "pawk -b" back end filter to sanitized UTF chars to U+number so UTF doesn't get mangled in python?

How does this compare to rascal[0] under python?

[0] : http://www.rascal-mpl.org/