I find Snowflake much easier to use than BigQuery, Redshift. It is also cloud-service-provider agnostic. So your only hook at that point is ingest + any snowflake-specific SQL (and obviously security migration etc.) So for retention, they compete on UX rather than walls.

W/r/t value, the idea is a disproportionate of egress from Oracle, Teradata, etc will end up at Snowflake, hence huge TAM, SAM, and SOM.