Shut down the app

Use this guide to take the RAI Native App offline when you no longer need it running. It explains when to stop the app and how to choose the right shutdown depth in SQL or through a Python client.

When to shut down the app

Shut down the app when:

• You are done using the app.
• You want to reduce ongoing costs while the app is idle.

Note

Shutting down the app does not uninstall it from your Snowflake account, so you can start it again later without reinstalling. No data is lost when you stop the app, but in-progress jobs are canceled.

What happens when you stop the app

There are three shutdown modes that achieve different levels of cost reduction by dropping different sets of resources. All modes suspend the app’s CDC service, delete all reasoners, and cancel in-progress jobs. The difference is whether the app service, app warehouse, and compute pools are only suspended or are dropped and recreated the next time you start the app.

Use the following table to choose a shutdown depth before you stop the app:

What to use	When to use it
Stop and suspend managed resources	Shuts down the app and suspends the app service, app warehouse, and compute pools. Delivers the smallest cost reduction of the three modes. Provides the fastest restart of the three modes.
Stop, suspend, and remove SPCS service	Shuts down the app, removes the app service, and suspends the warehouse and compute pools. Delivers more cost reduction than suspend-only mode, but less than removing all resources. Restarts more slowly than suspend-only mode, but faster than removing all resources.
Stop and remove all managed resources	Shuts down the app and removes the app service, app warehouse, and compute pools. Delivers the largest cost reduction of the three modes. Provides the slowest restart of the three modes.

Stop the app and suspend resources

Choose this option when you want to stop the app but leave the app service, app warehouse, and compute pools in place as suspended resources. This is the lightest shutdown and the quickest option to reverse.

SQL

Call the relationalai.app.deactivate() procedure with no arguments:

CALL relationalai.app.deactivate();

Output

+------------------------------------------------+
| RelationalAI service deactivated successfully. |
+------------------------------------------------+

Python

Create a Snowpark session from your default PyRel connection with create_config(), then call the relationalai.app.deactivate() SQL procedure with no arguments:

from relationalai.config import create_config

session = create_config().get_session()

session.sql("CALL relationalai.app.deactivate()").collect()

Stop the app and remove the SPCS service

Choose this option when you want a deeper shutdown that removes the app service but preserves the app warehouse and compute pools as suspended resources. Use it when you want more teardown than the default mode without fully removing the app’s managed infrastructure.

SQL

Call the relationalai.app.deactivate() procedure with 'service' as the argument:

CALL relationalai.app.deactivate('service');

Output

+------------------------------------------------+
| RelationalAI service deactivated successfully. |
+------------------------------------------------+

Python

Create a Snowpark session from your default PyRel connection with create_config(), then call the relationalai.app.deactivate() SQL procedure with 'service' as the argument:

from relationalai.config import create_config

session = create_config().get_session()

session.sql("CALL relationalai.app.deactivate('service')").collect()

Stop the app and drop all managed resources

Choose this option when you want the deepest shutdown and do not need to keep the app warehouse or compute pools available for the next start. Use it when cost reduction matters more than restart speed.

SQL

Call the relationalai.app.deactivate() procedure with 'all' as the argument:

CALL relationalai.app.deactivate('all');

Output

+------------------------------------------------+
| RelationalAI service deactivated successfully. |
+------------------------------------------------+

Python

Create a Snowpark session from your default PyRel connection with create_config(), then call the relationalai.app.deactivate() SQL procedure with 'all' as the argument:

from relationalai.config import create_config

session = create_config().get_session()

session.sql("CALL relationalai.app.deactivate('all')").collect()