Has anyone ever encountered an error where you are able to run your dbt project fine locally but when you use prefect it has screwed up using the custom schema and materializations utilized within your project?

Are you also triggering it locally with Prefect? I wonder if the environments are just out of sync

So I run a flow pulling down the latest git-repo in a different file location and then run another flow pointing exactly at that location where the most up to date repo is. I did this to try and avoid the environments being out of sync? Its all occurring locally

Do the custom schemas change based on the specified target or rely on any environment variables?

No I just run dbt run --target dev and prod which should have the same dbt schema structure

Would you mind sharing your flow code? Feel free to DM me if you prefer