Note
This view is available starting with V4.4.1.
Purpose
This view displays the access information of the AI models in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| ENDPOINT_ID | int(20) | NO | The unique ID of the access information. |
| ENDPOINT_NAME | varchar(128) | NO | The unique name of the access information. |
| AI_MODEL_NAME | varchar(128) | NO | The name of the AI model to which the access information belongs. |
| SCOPE | varchar(128) | NO | Reserved. The default value is all. This field is reserved for future use, such as for configuring model access information across regions or zones. |
| URL | varchar(2048) | NO | The URL of the model. The URL supports HTTP and HTTPS. Example: https://dashscope.aliyuncs.com/compatible-mode/v1/embeddings. |
| ACCESS_KEY | varchar(2048) | NO | The API Key used to call the model. |
| PROVIDER | varchar(128) | NO | The AI model provider, such as openai, aliyun, deepseek, or ollama. This field is used for internal API message format adaptation. If this field is empty, you must provide a UDF function; otherwise, an error will be reported. |
| REQUEST_MODEL_NAME | varchar(128) | YES | The user-defined model name in the request body. Example: bge-m3-custom. |
| PARAMETERS | varchar(2048) | YES | Reserved. Optional parameters used to configure additional parameters for model calls, such as context_window and max_output_tokens, to support batch operations. Example: {"context_window": 128000,"max_output_tokens": 8000}. |
| REQUEST_TRANSFORM_FN | varchar(64) | YES | Reserved. Used to construct the request data sent to the AI model. If this field is empty, the system will use the default message format based on the PROVIDER and the model type (embedding, rerank, or completion) to send the request. |
| RESPONSE_TRANSFORM_FN | varchar(64) | YES | Reserved. Used to parse the data returned by the AI model. If this field is empty, the system will use the default response format based on the PROVIDER and the model type (embedding, rerank, or completion) for processing. |
Sample query
Query the access information of the AI models in the user tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_AI_MODEL_ENDPOINTS;
The query result is as follows:
+-------------+--------------------+---------------+-------+-------------------+------------------------------------------------------------------+----------+--------------------+------------+----------------------+-----------------------+
| ENDPOINT_ID | ENDPOINT_NAME | AI_MODEL_NAME | SCOPE | URL | ACCESS_KEY | PROVIDER | REQUEST_MODEL_NAME | PARAMETERS | REQUEST_TRANSFORM_FN | RESPONSE_TRANSFORM_FN |
+-------------+--------------------+---------------+-------+-------------------+------------------------------------------------------------------+----------+--------------------+------------+----------------------+-----------------------+
| 1 | my_model_endpoint1 | my_ai_model_1 | ALL | your ai model url | EAF8BD8998A38C94B9EA596257E8D05CE4B8309E7134F81A78CCB59D60C39846 | openai | text-embedding-v2 | NULL | NULL | NULL |
+-------------+--------------------+---------------+-------+-------------------+------------------------------------------------------------------+----------+--------------------+------------+----------------------+-----------------------+
1 row in set