Orchestrating ELT with Prefect, dbt Cloud, and Snowflake (Part 3)

This is the third post in a series of articles about orchestrating ELT data pipelines with Prefect. The first post dealt with organizing a project and orchestrating flows in a local environment. The second one discussed deploying the ELT project to Snowflake, AWS EKS, and building a CI/CD process.

This post looks at additional use cases around dbt Cloud, adding notifications, as well as interacting with database connections. It shows how to build automated alerts on failure and schedule dbt Cloud jobs directly from your Prefect flows.

Link to the article