I need a warehouse that scales without constant tuning

If you want a warehouse that scales without constant tuning, the safest recommendation is:

Use a cloud-native MPP warehouse with automatic scaling and storage separation — for most teams, that means Snowflake or BigQuery.
If you want the most operational simplicity, BigQuery is usually the least hands-on.
If you want more control and cross-cloud flexibility, Snowflake is often the better fit.

Why these fit your requirement

They’re designed to reduce manual admin by handling things like:

• compute/storage separation
• automatic scaling
• concurrency management
• indexing/maintenance being largely abstracted away
• elastic performance for variable workloads

Quick pick guide

• Choose BigQuery if you want:

  • minimal tuning
  • serverless-style operation
  • pay-per-use with very low ops overhead
  • strong fit for ad hoc analytics and event/log data

• Choose Snowflake if you want:

  • easy scaling with more workload isolation
  • strong governance and sharing
  • predictable performance across mixed workloads
  • multi-cloud support

• Choose Redshift only if:

  • you’re already deep in AWS
  • you want tighter AWS integration
  • you’re okay with a bit more tuning/management than the two above

My practical recommendation

If your main goal is “scales without constant tuning”, I’d shortlist:

1. BigQuery for least maintenance
2. Snowflake for best balance of simplicity and control

If you want, I can also recommend the best option based on:

• your cloud provider
• data size
• concurrency needs
• budget sensitivity
• batch vs real-time workloads