Has anyone tried out dbt prefect in v2 more specifically wha

Question

Has anyone tried out dbt prefect in v2 more specifically what sort of patterns would you use now

Stephen Herron · Answer

In prefect 1 we have a flow that first clones our repo from github then is able to use the DbtShellTask with helper e g `cd lt dbt project dir gt ` flows are ran via ECS Thinking in prefect 2 it might be better to package the dbt code to s3 and use a storage block if my flow lives in one place and my dbt project in another hoping it will just work through the magic of s3fs Although that will mean a change to our DBT cicd not a huge effort though

James Sopkin · Answer

There is a prefect dbt collection I have a flow that used an s3 bucket for storage and call the trigger dbt cloud run and wait for completion task

James Sopkin · Answer

Stephen Herron · Answer

that said the dbt code just upload to a an s3 sub path where the main flow that uses the project so they could just live together there Thanks < James Sopkin> yes that is what I m planning to use just the cli version

James Sopkin · Answer

ahh okay you re welcome