Change Native App Compute Pool Size

QPR ProcessAnalyzer Native App uses by default either the CPU_X64_XS or CPU_X64_S size Snowflake compute pool, depending when the Native App has been installed. The current compute pool size can be checked in Snowsight in Compute > Compute pools where the QPR_PROCESSANALYZER_COMPUTE_POOL compute pool can be found.

The compute pool can be changed using the commands below. Native App provides PUBLIC.SET_COMPUTE_POOL_SIZE procedure that will change the size of the compute pool for the compute pool owned by the Native App. The application role ADMINISTRATOR is required to run the procedure. 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.

Before changing the compute pool size, it's recommended to take a backup of the Native App data, as instructed below. To change the compute pool size, run the the following commands one-by-one by executing the commands in a Snowflake worksheet.

-- 1. Stop 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');

More information about Snowflake compute pools: https://docs.snowflake.com/en/developer-guide/snowpark-container-services/working-with-compute-pool.