drop_service()#

relationalai.app
#drop_service()

Stops the RelationalAI (RAI) container service running on Snowpark Container Services and drops the service’s Snowflake warehouse and [compute pool]https://docs.snowflake.com/en/developer-guide/snowpark-container-services/working-with-compute-pool). Engine compute pools, existing RAI engines, and RAI schemas remain intact.

Requires the app_admin application role.

Example#

You can drop the service to reduce costs when you are not using the RAI Native App. To suspend CDC, delete all engines, and drop the service:

#-- Suspend CDC
CALL relationalai.app.suspend_cdc();

-- List the engines
SELECT * FROM relationalai.api.engines;

-- For each engine name in the output of the above `SELECT` statement (if any),
-- fill in the engine name in the following command and run it
CALL relationalai.api.delete_engine('<engine_name>', TRUE);

-- Drop the service
CALL relationalai.app.drop_service();

If you need to use the service again, use create_service() to recreate the service and then set up CDC with a new engine:

#-- Recreate the service after dropping it
CALL relationalai.app.create_service();

-- Create a CDC engine
CALL relationalai.api.create_engine('<cdc_engine_name>', 'HIGHMEM_X64_S');

-- Setup CDC
CALL relationalai.app.setup_cdc('<cdc_engine_name>');

relationalai Python package users can recreate their engines using the rai engines:create command in the RAI CLI.

See Also#