I think DuckDB is great but I don't think it is necessarily playing the same game as Snowflake. A lot of people want the serverless option and DuckDB is not that.
In that case BigQuery is more managed than both, PAYG for analytical queries without thinking about compute nor clusters whatsoever.