How can a Snowsight user change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse?
To change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse, the warehouse must be in a suspended state. This ensures that no operations are disrupted during the modification process.
Suspend the Warehouse: Ensure that the warehouse is suspended.
ALTER WAREHOUSE my_warehouse SUSPEND;
Alter the Warehouse: Modify the warehouse to be Snowpark-optimized.
ALTER WAREHOUSE my_warehouse SET WAREHOUSE_TYPE = 'SNOWPARK-OPTIMIZED';
Resume the Warehouse: Resume the warehouse to make it operational.
ALTER WAREHOUSE my_warehouse RESUME;
References:
Snowflake Documentation: Creating Snowpark-Optimized Warehouses
Snowflake Documentation: ALTER WAREHOUSE
Erinn
6 months agoAmie
5 months agoReuben
5 months agoCheryll
5 months agoJohna
6 months agoShanice
6 months agoEvan
5 months agoEden
5 months agoVal
5 months agoCeola
7 months agoGregoria
7 months agoErick
7 months agoAndrew
6 months agoWinifred
6 months agoAgustin
7 months agoSilva
7 months agoCeola
7 months ago