get_service()#

relationalai.app
#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:

FieldTypeDescription
nameSTRINGThe name of the SPCS service.
ownerSTRINGThe name of the RAI Native App.
compute_poolSTRINGThe name of the service’s compute pool.
query_warehouseSTRINGThe name of the service’s warehouse.
resumed_onSTRINGThe time when the service was last resumed.
updated_onSTRINGThe 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#