Hey Does anyone some good example to share on how Prefect 2

Question

Hey Does anyone some good example to share on how Prefect 2 0 dbt local cli run with Postgres Having abit of difficulties setting up all the blocks and profiles correctly

Anna Geller · Answer

You could specify it in YAML ```your project outputs dev client session keep alive false dbname postgres host localhost password your password port 5432 schema your project threads 4 type postgres user postgres target dev``` and point to it explicitly or store it in Users your user name dbt profiles yml

andres aava · Answer

Ideally would do something like this But I d have to register some special type block then on Prefect Cloud

andres aava · Answer

Also tried like this but with Postgre configurations could work it out by storing connectionstrinng as normal Secret Block on Prefect Cloud and then just load in the dict

andres aava · Answer

Maybe it s something to do with my local setup Getting weird error

andres aava · Answer

Shortly about my goals here slightly smiling face With Prefect 1 0 I have set up quite simple worker on Heroku 1 deploy worker 2 registers flow on Prefect Cloud 3 starts up localAgent on the worker 4 trigger scheduled runs from Prefect Cloud UI 5 reads dbt code from github repo 6 reads credentials from prefect cloud 1 0 kv store secrets 7 inputs credentials into dbt cli run task and does dbt run Trying to achieve something similar now with Prefect 2 0

Anna Geller · Answer

thanks for the writeup doing this on a restricted windows machine can be hard perhaps you can try sth similar to <https github com anna geller prefect dataplatform blob main dataplatform blocks dbt py|this> and run it first on GitHub Codespaces it s now free for everyone essentially a free Linux VM for development

andres aava · Answer

oh finally got it working sweat smile Github Codespaces was a good tip Thx Tried first manually creating profiles yml in the directory Now will try to move profiles yml to Blocks

Anna Geller · Answer

Nice work

Anna Geller · Answer

Feel free to share your solution maybe I could add it to the demo repo

andres aava · Answer

I ll be back on this topic later during this week hopefully Little tight on schedule right now slightly smiling face

andres aava · Answer

Didnt get into a such solution that it would be nice to share Might need abit more polishing grinning