[ndm000]

I have worked with several companies that have their infrastucture on AWS but consider BigQuery or Snowflake for the serverless model they provide. This brings RedShift much closer to those options. I envision Redshift Serverless becoming the default options for most enterprises, mainly because it stays in the AWS ecosystem and you don't have to work with a different vendor and create different cost governance processes.

I beleive the real advantage AWS has here is in cost. Snowflake has positioned itself as price competitive with Redshift but this is primarily due to Snowflake's ability to scale on-demand, whereas prior Redshift versions required you to size for peak usage (RA3 helped with this). In my experience Snowflake is an order of magnitude more expensive if you compare similiar workloads and do not account for idle time. We will need to see the performance of a "Redshift Processing Unit" to be sure of the advantage, but even so AWS will be able provide significant downward cost pressure through this offering.

[ignoramous]

> In my experience Snowflake is an order of magnitude more expensive if you compare similiar workloads and do not account for idle time.

Cost reasons is why I'm most bullish about DataBricks's FOSS https://delta.io

[gizmodo59]

Delta is not the way. I’d prefer an Apache project like Iceberg https://iceberg.apache.org/ rather than delta lake.