Change Native App Compute Pool Size

The QPR ProcessAnalyzer Native App uses by default either the CPU_X64_XS or CPU_X64_S Snowflake compute pool sizes, depending when the Native App has been installed. You can verify the current compute pool size in Snowsight by navigating to Compute > Compute pools, where you will find the QPR_PROCESSANALYZER_COMPUTE_POOL.

To change the compute pool size, run the commands below. The Native App includes a PUBLIC.SET_COMPUTE_POOL_SIZE procedure that allows you to change the compute pool size for the compute pool owned by the Native App. This operation requires the application ADMINISTRATOR role. Note that if the Native App uses some other compute pool than the one owned by the Native App, this procedure cannot be used to change the compute pool size.

Available compute pool sizes include: CPU_X64_XS, CPU_X64_S, and CPU_X64_M. For detailed specifications and pricing, refer to the Snowflake documentation: https://docs.snowflake.com/en/developer-guide/snowpark-container-services/working-with-compute-pool.

Before changing the compute pool size, it is recommended to back up the Native App data, following the instructions provided below. To change the compute pool size, execute the following commands one-by-one in a Snowflake worksheet.

-- 1. Stop the application service
ALTER SERVICE QPR_PROCESSANALYZER.METADATA.QPR_PROCESSANALYZER_SERVICE SUSPEND;
CALL QPR_PROCESSANALYZER.METADATA.QPR_PROCESSANALYZER_SERVICE!SPCS_WAIT_FOR('SUSPENDED', 600);

-- 2. Create a database and schema for snapshots and take a snapshot
CREATE DATABASE QPRProcessAnalyzerBackups;
USE DATABASE QPRProcessAnalyzerBackups;  
CREATE SCHEMA Backups;
CREATE SNAPSHOT QPRProcessAnalyzerBackups.Backups.MySnapshot
  FROM SERVICE QPR_PROCESSANALYZER.METADATA.QPR_PROCESSANALYZER_SERVICE
  VOLUME "data"
  INSTANCE 0;

-- 3. Change the compute pool size
CALL QPR_PROCESSANALYZER.PUBLIC.SET_COMPUTE_POOL_SIZE('CPU_X64_XS');

-- 4. Start the service
ALTER SERVICE QPR_PROCESSANALYZER.METADATA.QPR_PROCESSANALYZER_SERVICE RESUME;
CALL QPR_PROCESSANALYZER.METADATA.QPR_PROCESSANALYZER_SERVICE!SPCS_WAIT_FOR('RUNNING', 600);