The catalog view SYSCAT.EXTERNALMODELS is defined to provide metadata about externally
defined Large Language Models (LLM) that are integrated into the database system via the CREATE
EXTERNAL MODEL statement. This view captures essential information about the external model's
identity, provider, access configuration, and user-defined options.
Table 1. SYSCAT.EXTERNALMODELS catalog
view
| Column Name |
Data Type |
Nullable |
Description |
| MODELSCHEMA |
VARCHAR(128) |
No |
Schema name of the external model. |
| MODELNAME |
VARCHAR(128) |
No |
Unqualified name of the external model. |
| PROVIDER |
VARCHAR(128) |
No |
External model provider (e.g. WATSONX or OPENAI). |
| MODELID |
VARCHAR(256) |
No |
Unique identifier of the model within the provider's system. |
| MODELTYPE |
VARCHAR(32) |
No |
Type of the model, for example:
- TEXT_EMBEDDING
- TEXT_GENERATION
|
| RETURNTYPE |
VARCHAR(128) |
No |
Return type of the external model, for example: VECTOR(768,FLOAT32). |
| URL |
VARCHAR(512) |
No |
URL endpoint used to invoke the external model. |
| OWNER |
VARCHAR(128) |
No |
Authorization ID of the owner of the external model. |
| OWNERTYPE |
VARCHAR(1) |
No |
- S = The owner is the system
- U = The owner is an individual user.
|
Table 2. SYSCAT.EXTERNALMODELOPTIONS
Catalog View
| Column Name |
Data Type |
Nullable |
Description |
| MODELSCHEMA |
VARCHAR(128) |
No |
Schema of the external model. |
| MODELNAME |
VARCHAR(128) |
No |
Unqualified name of the external model. |
| OPTION |
VARCHAR(128) |
No |
Name of the external model option. |
| SETTING |
VARCHAR(256) |
No |
Value of the external model option. |
Table 3. SYSCAT.EXTERNALMODELAUTH
catalog view
| Column Name |
Data Type |
Nullable |
Description |
| GRANTOR |
VARCHAR(128) |
No |
Grantor of a privilege. |
| GRANTEE |
CHAR(1) |
No |
Indicates type of grantor:
|
| GRANTEE |
VARCHAR(128) |
No |
Holder of a privilege |
| GRANTEETYPE |
CHAR(1) |
No |
Type of grantee:
- G = Group
- R = Role
- U = Individual user
|
| MODELSCHEMA |
VARCHAR(128) |
No |
Schema name of the external model to which this privilege applies. |
| MODELNAME |
VARCHAR(128) |
No |
Unqualified name of the external model to which this privilege applies. |
| ALTERAUTH |
CHAR(1) |
No |
Privilege to alter the model:
- G = Held and grantable
- Y = Held
- N = Not held
|
| USAGEAUTH |
CHAR(1) |
No |
Privilege to use the model:
- G = Held and grantable
- Y = Held
- N = Not held
|
| GRANT_TIME |
TIMESTAMP |
No |
Time at which the privilege was granted. |
| GRANTREVOKE_TIME |
TIMESTAMP |
No |
Time at which the privilege was last granted or revoked. |