We did a PoC with Snowflake. scale up and down works as advertised. Be careful with large ETL streams. We would have to rewrite at least 20% of our ETL to make Snowflake meet or beat our current SLA's.
We looked at performance server to replace our MAKO Appliances IPS is really NPS 7.2. Concurrency was still set at 48. Performance server didn't make it to our POC.
Take a look at Snowflake and/or Yellowbrick
Hi, I currently have Mako appliances in production and a performance server in DR. We are able to do our normal NZBACKUP from Mako and NZRESTORE to our performance server