In this demo, we have shown how an analyst who knows only SQL can work independently to create sophisticated data transformation pipelines without the need for any engineering. Our CDP deployment simplifies all aspects of the software development lifecycle of dbt models.

For latest updates to the dbt adapters check out: https://community.cloudera.com/t5/Innovation-Blog/ANNOUNCE-Updates-to-the-dbt-adapters-for-Apache-Hive-Apache/ba-p/351897

We have series of detailed articles for various deployment methods: https://community.cloudera.com/t5/Innovation-Blog/bg-p/Cloudera_Innovation_Acceleratorblog-board

Video timestamps

0:00 Intro

1:12 Clone the project

1:29 Connecting to the warehouse

2:07 Check logs

2:19 Loading and observing data

3:06 Writing models

3:49 Running models

4:00 Testing data

4:20 Documenting models

4:40 Orchestrate the transformation

5:24 Viewing the documentation

5:35 dbt & SDX

5:53 Conclusion