Snowflake is a pretty amazing piece of engineering. I suspect that solutions to problems of this kind, resource allocation given conflicting constraints and objectives, will only get more sophisticated over time.