Skip to content

relationalai.app.get_service()

get_service()

A procedure that retrieves information about the RelationalAI (RAI) Native App’s Snowpark Container Services (SPCS) service. Requires the app_user application role.

Parameters

None.

Returns

JSON array (VARIANT) with one object with the following fields:

Field	Type	Description
`name`	`STRING`	The name of the SPCS service.
`owner`	`STRING`	The name of the RAI Native App.
`compute_pool`	`STRING`	The name of the service’s compute pool.
`query_warehouse`	`STRING`	The name of the service’s warehouse.
`resumed_on`	`STRING`	The time when the service was last resumed.
`updated_on`	`STRING`	The time when the service was last updated. See Upgrades for details on how the RAI Native App is upgraded.

Example

Use the app.get_service() procedure to retrieve information about the RAI Native App’s SPCS service:

CALL relationalai.app.get_service();
/*+-----------------------------------------------------------+
  | [                                                         |
  |     {                                                     |
  |         "name": "SPCS_CONTROL_PLANE",                     |
  |         "owner": "RELATIONALAI",                          |
  |         "compute_pool": "RELATIONAL_AI_ERP_COMPUTE_POOL", |
  |         "query_warehouse": "RELATIONAL_AI_ERP_WAREHOUSE", |
  |         "resumed_on": "2024-10-27T22:10:05Z",             |
  |         "updated_on": "2024-10-27T22:10:05Z"              |
  |     }                                                     |
  | ]                                                         |
  +-----------------------------------------------------------+ */

See App Management for more information on monitoring the RAI Native App’s status.

See Also