"Hello World" for DBT Analytical Transformation Workflows about augur

[jameshowison]

dbt can help with transformations, so augur could have additional schemas which are built as downstream "data products" to make access to different views possible. It is also useful when you have complex queries with a lot of CTEs, sub-queries, or unions, to make the sub parts more easily reusable and testable.

It requires a place to run, and write access to the schemas. I think that one can get started soonest using dbt cloud, but you can also install locally https://docs.getdbt.com/docs/quickstarts/dbt-core/quickstart

It works fine with postgres and while its SQL native you can also have python tasks, so it becomes more of a complete dag (e.g., the sentiment analysis or the email addresses entity resolution, can run at the right point in a pipeline.

[sgoggins]

@jameshowison : Does anyone on your team happen to have tried this with Augur? I am guessing not since it requires table creation permissions, it seems.