I am working with both Azure Serverless SQL pool and Snowflake. My only gripe with Azure is the long checklist such as decide the type of partitioning, decide indexing, turn table stats on/off, workload management, resource class etc. that I need to follow if I want to achieve an optimal performance.

Snowflake has none of this overhead.