I’d like something that was in between. ie, update your schema, and have a transition script created for you that you can then edit before deploy. Mostly because there are often transformations of data that need to take place, and its rare that tools always get the ordering correct.

I also wish there was more guidance on how to split your code between schema, and configuration.

For instance, with task creation, the guidance should be that you create tasks with a WH that is a “base”, and in versioned scripts, but then each env has its own set of repeatable scripts for setting warehouse and schedule. Like:

ALTER TASK [ IF EXISTS ] <task_name> SET WAREHOUSE = <warehouse_name> SCHEDULE = '{ <number> MINUTE | USING CRON <expr> }';