activate()#

#activate()

Activates the RelationalAI (RAI) Native App on Snowpark Container Services. Requires the app_admin application role.

Example#

To activate the RAI Native App after installing it, or to re-activate an app that has been deactivated, use the activate() procedure:

#CALL relationalai.app.activate();

When you activate your app for the first time, the necessary resources are provisioned:

• An X-SMALL Snowflake warehouse for executing queries against the RAI Native App’s Snowflake database. A dedicated warehouse is necessary to ensure that service operations against this database do not contend with other workloads.
• Five Snowflake compute pools:
  • One HIGHMEM_X64_S pool for hosting small RAI engines.
  • One HIGHMEM_X64_M pool for hosting medium engines.
  • Two CPU_X64_S pools for internal use.
  • One CPU_X64_M pool for internal use.

When you re-activate a deactivated app:

• All RAI engines that were deleted when the app was deactivated are re-created.
• The CDC service is configured with the engine that was used when the app was deactivated.
• If the CDC service was active when the app was deactivated, it is resumed. Otherwise, it remains suspended.

See Also#

• deactivate()
• service_status()