oceanbase.CDB_OB_AI_MODEL_PROFILES

Overview

Displays the AI model parameter (Model Profile) configuration information for all tenants. It is commonly used to view the provider/model level parameters created or updated by each tenant using the ALTER_MODEL_PROFILE PL procedure under the sys tenant.

Columns

Sample query

The system tenant queries the AI model parameter configurations of all tenants.

1. Register the provider in the user tenant and set model parameters (replace access_key and base_url with actual values):

   CALL DBMS_AI_SERVICE.REGISTER_PROVIDER('test-provider', '{
   "protocol": "openai",
   "base_url": "https://xxx",
   "access_key": "sk-xxx"
   }');
   CALL DBMS_AI_SERVICE.ALTER_MODEL_PROFILE('test-provider/test-model', '{
   "model_config": {
       "max_tokens": 4096,
       "temperature": 0
   },
   "run_config": {
       "batch_size": 16,
       "max_image_size": 4194304,
       "min_concurrency": 10,
       "max_concurrency": 100
   }
   }');
   

2. Query in the sys tenant:

   SELECT TENANT_ID, MODEL, MODEL_CONFIG, RUN_CONFIG
   FROM oceanbase.CDB_OB_AI_MODEL_PROFILES
   WHERE MODEL = 'test-provider/test-model';
   

   The sample result is as follows:

   TENANT_ID	MODEL	MODEL_CONFIG	RUN_CONFIG
   1004	test-provider/test-model	{"max_tokens": 4096, "temperature": 0}	{"batch_size": 16, "max_image_size": 4194304, "max_concurrency": 100, "min_concurrency": 10}
   1 row in set
   

References

• ALTER_MODEL_PROFILE
• Monitoring AI Function Service