Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Struggling with prefect 3 and dbt cloud job run. Trying this example from docs<https://docs-3.prefect.io/integrations/prefect-dbt/index#run-a-dbt-cloud-job-and-wait-for-completion> but this leaves me with a question if/how to do run from deployments. The example calls main flow with _asyncio.run(run_dbt_job_flow())_ but I'd rather do something like _main_flow.from_source().deploy(),_ with dbt cloud job as a task but I'm unsure how to adapt. any examples or input on this?

Had it kind of working, but the error _"httpx.ConnectError: All connection attempts failed"_ confused me.
Turned out I was missing the dbt domain in the dbt Cloud Credentials block, since the domain field is optional..

image.png

Ok so seems like it can be run "as is" without modifying the deployment config. Thought I had to do something due to a network error but that was due to missing dbt domain as mentioned above.

Also value for retry count in documentation made the dbt cloud job instantly return as failed even in if it passed. had to set it to 1 or remove it (default to 1?) to make it await the cloud job and return correct status