There's the slim ci best practice and ways to deploying only what's changed in dbt, but these require some config and underlying knowledge.

Verifying schema changes pre-production is only part of the issues, figuring out the actual data changes caused by code logic changes is trickier.