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
5 months agoAmie
4 months agoReuben
5 months agoCheryll
5 months agoJohna
6 months agoShanice
6 months agoEvan
4 months agoEden
5 months agoVal
5 months agoCeola
6 months agoGregoria
6 months agoErick
6 months agoAndrew
5 months agoWinifred
6 months agoAgustin
6 months agoSilva
6 months agoCeola
6 months ago