Resources the app creates
This page inventories the Snowflake resources connected to the RelationalAI (RAI) Native App so you can answer on-call questions such as “what compute pools did the app create?” and “what is safe to suspend?”. It groups resources by who creates them and links to the guide that owns each one’s full lifecycle.
App-owned resources
Section titled “App-owned resources”The app creates and manages these resources. You do not create them directly, but you should know they exist.
| Resource | Name | Appears when | Cost trigger | Inspect with |
|---|---|---|---|---|
| Application database | RELATIONALAI (unless renamed at install) | Install | Storage only | SHOW APPLICATIONS; |
| App warehouse | RELATIONAL_AI_ERP_WAREHOUSE | First activation | Compute while running | SHOW WAREHOUSES; |
| Compute pools | RELATIONAL_AI_* | First activation | Reserved nodes or running reasoners | SHOW COMPUTE POOLS; |
| App service | Managed internally | First activation | Runs on the compute pools | app.service_status(), app.get_service() |
| CDC engine | CDC_MANAGED_ENGINE | app.resume_cdc() | Runs continuously while CDC is enabled | app.cdc_status() |
The default app.deactivate() suspends the app service, warehouse, and compute pools; deactivate('all') drops them and recreates them on the next activation.
Deactivation is not an uninstall: the application database persists.
Administrator-created resources
Section titled “Administrator-created resources”You create these while setting up access and connectivity. You own their lifecycle.
| Resource | Created by | Inspect with | Managed in |
|---|---|---|---|
RAI_ADMIN, RAI_DEVELOPER, and custom account roles | CREATE ROLE + application-role grants | SHOW GRANTS TO ROLE <role>; | Configure user access |
| Direct Access authentication objects (OAuth security integration, PAT, registered public key, network policy) | Direct Access setup | SHOW SECURITY INTEGRATIONS;, SHOW NETWORK POLICIES;, SHOW USER PROGRAMMATIC ACCESS TOKENS FOR USER <user>; | Set up Direct Access |
These objects are standard Snowflake objects. Remove them with the corresponding Snowflake commands only after confirming no other user depends on them.
Workload-created resources
Section titled “Workload-created resources”These appear as developers use the app. They are managed through their own APIs, not created by installation.
| Resource | Created by | Inspect with | Managed in |
|---|---|---|---|
| Data streams | Referencing a table in a model, or api.create_data_stream(...) | SELECT * FROM relationalai.api.data_streams; | Manage data streams |
| Reasoners | Running a model, or api.create_reasoner(...) | SELECT * FROM relationalai.api.reasoners; | Manage reasoners |
| Deployed model schemas | model.deploy() or rai models deploy | SHOW SCHEMAS IN DATABASE <db>; | Deploy a model |