Snowpark-optimized Warehouses - Want to run ML / Memory Intensive application on snowflake

Yes, We have Snowpark-optimized warehouse which can leveraged to run memory intensive application mostly we know it as ML algorithms.

Snowpark workloads can run in below two type of warehouses

1. Standard
2. Snowpark-optimized

Compared to standard warehouses, the compute nodes of Snowpark-optimized warehouses have 16x the memory and 10x the local cache.

You can use it when you run into a “100357 (P0000): UDF available memory exhausted” error during development.

Create a new Snowpark-optimized warehouse

CREATE OR REPLACE WAREHOUSE {warehouse_name} WITH
  WAREHOUSE_SIZE = 'MEDIUM'
  WAREHOUSE_TYPE = 'SNOWPARK-OPTIMIZED';        

Snowpark-optimized warehouse does not support on x-small and small sizes