Query Model Lists and Version Details via SHOW MODELS - MaxCompute

Prerequisites

Before you begin, make sure that a model object exists in the project. For more information, see Create and delete a model.

Supported clients

All commands in this topic can be run on:

Operations at a glance

Operation	Command	Required permission
List all models in the project	`SHOW MODELS`	List
List all versions of a model	`SHOW VERSIONS FOR MODEL`	—
View metadata for a model and its versions	`DESC MODEL`	Describe

List models

SHOW MODELS lists all user-created models in the current project. Public models are not included. To view public models, go to the console.

Syntax

SHOW MODELS;

Output

Column	Description
ModelName	The name of the model
Owner	The Alibaba Cloud account that owns the model
SourceType	How the model was added: `REMOTE` (PAI EAS endpoint) or `IMPORT` (imported from a file)
ModelType	The model type, such as `LLM`, `MLLM`, or `BOOSTED_TREE_CLASSIFIER`
DefaultVersion	The version used when no version is specified
CreateTime	When the model was created
LastModifiedTime	When the model was last updated
Comment	An optional description of the model

Example

SHOW MODELS;

Expected output:

+-------------------------+------------------------------+------------+-------------------------+----------------+---------------------+---------------------+-----------------------------------+
| ModelName               | Owner                        | SourceType | ModelType               | DefaultVersion | CreateTime          | LastModifiedTime    | Comment                           |
+-------------------------+------------------------------+------------+-------------------------+----------------+---------------------+---------------------+-----------------------------------+
| pai_eas_qwen25_omni_3b  | ALIYUN$odps_********_com | REMOTE     | MLLM                    | v1             | 2025-10-09 18:32:48 | 2025-10-09 18:32:48 | PAI EAS remote model binary input |
| test_xgboost_classifier | ALIYUN$odps_********_com | IMPORT     | BOOSTED_TREE_CLASSIFIER | v1             | 2025-10-09 18:41:29 | 2025-10-09 18:41:29 | Import XGBoost model v1           |
+-------------------------+------------------------------+------------+-------------------------+----------------+---------------------+---------------------+-----------------------------------+

List model versions

SHOW VERSIONS FOR MODEL lists all versions of a specified model.

Syntax

SHOW VERSIONS FOR MODEL <model_name>;

Parameters

Parameter	Required	Description
`model_name`	Yes	The name of the model

Output

A list of version names, one per line (for example, v1, v2).

Usage notes

Viewing versions of a public model

Public models in the BIGDATA_PUBLIC_MODELSET project require two extra steps before you can query them:

Enable public model access:
```
SET odps.sql.using.public.model=true;
```

Specify the project (and schema, if tenant-level schema syntax is enabled) in the model name:

-- If tenant-level schema syntax is enabled for the project:
SHOW VERSIONS FOR MODEL bigdata_public_modelset.default.<model_name>;

-- If tenant-level schema syntax is not enabled:
SHOW VERSIONS FOR MODEL bigdata_public_modelset.<model_name>;

For more information about tenant-level schema syntax, see Schema operations. For a list of available public models, see Model types.

Examples

List versions of a user-created model:

SHOW VERSIONS FOR MODEL PAI_EAS_Qwen25_Omni_3B;
-- Returns:
-- v1
-- v2

List versions of a public model:

-- If tenant-level schema syntax is enabled:
SET odps.sql.using.public.model=true;
SET odps.namespace.schema=true;
SHOW VERSIONS FOR MODEL bigdata_public_modelset.default.Qwen3-0.6B-GGUF;

-- If tenant-level schema syntax is not enabled:
SET odps.sql.using.public.model=true;
SET odps.namespace.schema=false;
SHOW VERSIONS FOR MODEL bigdata_public_modelset.Qwen3-0.6B-GGUF;
-- Returns: v1

View model details

DESC MODEL returns metadata for a model and a specific version. The output includes model-level information, version-level information, and the model's input schema.

Syntax

DESC MODEL <model_name> [WITH VERSION <version_name>];

Parameters

Parameter	Required	Description
`model_name`	Yes	The name of the model
`version_name`	No	The version to inspect. Defaults to the model's `DEFAULT_VERSION` if not specified. To change the default version, use `ALTER MODEL .. SET DEFAULT_VERSION ..`. For more information, see Modify a model version.

The same requirements for accessing public models apply here as for SHOW VERSIONS FOR MODEL. Run SET odps.sql.using.public.model=true; and qualify the model name with its project and schema before running DESC MODEL on a public model.

Output

Model Information section

Field	Description
Owner	The Alibaba Cloud account that owns the model
Project	The project the model belongs to
Model Name	The name of the model
Model Type	The model type: `LLM`, `MLLM`, `BOOSTED_TREE_CLASSIFIER`, etc.
Source Type	`REMOTE` or `IMPORT`
Default Version	The version used when no version is specified
CreateTime	When the model was created
LastModifiedTime	When the model was last updated
Comment	An optional description

Version Information section

Field	Description
Owner	The account that owns this version
Project	The project the model belongs to
Model Name	The name of the model
Model Type	The model type
Source Type	`REMOTE` or `IMPORT`
Version Name	The version identifier
Path	The file path (for `IMPORT` models)
CreateTime	When this version was created
LastModifiedTime	When this version was last updated

For REMOTE models, the Version Information section also includes:

Field	Description
APIKEY	The API key for the PAI EAS endpoint
ENDPOINT	The PAI EAS service URL
PAI_EAS_MODEL_NAME	The model name in PAI EAS
PAI_EAS_SERVICE_NAME	The PAI EAS service name
PAI_EAS_SYNC_MODE	Whether the service uses synchronous mode
REMOTE_SERVICE_TYPE	The remote service type, such as `PAI-EAS`

Input section

Lists the model's input columns, their data types, and comments.

Examples

Example 1: View a specific version of a user-created remote model

DESC MODEL PAI_EAS_Qwen25_Omni_3B WITH VERSION v1;

Expected output:

+------------------------------------------------------------------------------------+
|                  Model Information                                                 |
+------------------------------------------------------------------------------------+
| Owner:                    ALIYUN$odps_********_com                             |
| Project:                  ****_demo                                                |
| Model Name:               pai_eas_qwen25_omni_3b                                   |
| Model Type:               MLLM                                                     |
| Source Type:              REMOTE                                                   |
| Default Version:          v2                                                       |
| CreateTime:               2025-10-09 18:32:48                                      |
| LastModifiedTime:         2025-10-09 18:32:48                                      |
| Comment:                  PAI EAS remote model binary input                        |
+------------------------------------------------------------------------------------+
|                Version Information                                                 |
+------------------------------------------------------------------------------------+
| Owner:                    ALIYUN$odps_********_com                             |
| Project:                  ****_demo                                                |
| Model Name:               pai_eas_qwen25_omni_3b                                   |
| Model Type:               MLLM                                                     |
| Source Type:              REMOTE                                                   |
| Version Name:             v1                                                       |
| Path:                                                                              |
| CreateTime:               2025-10-09 18:32:48                                      |
| LastModifiedTime:         2025-10-09 18:32:48                                      |
| APIKEY:                   ZjA5NGR*********jMzMmU0OTZmZTQ1MT*********UyNjBhMmEzYw== |
| ENDPOINT:                 http://1126123********.cn-shanghai.pai-eas.aliyuncs.com |
| PAI_EAS_MODEL_NAME:       Qwen2.5-Omni-3B                                          |
| PAI_EAS_SERVICE_NAME:     test_remote_model                                        |
| PAI_EAS_SYNC_MODE:        true                                                     |
| REMOTE_SERVICE_TYPE:      PAI-EAS                                                  |
+------------------------------------------------------------------------------------+
| Input           | Type       | Comment                                             |
+------------------------------------------------------------------------------------+
| data            | binary     |                                                     |
| promt           | string     |                                                     |
+------------------------------------------------------------------------------------+

Example 2: View the default version of a public model

-- If tenant-level schema syntax is enabled:
SET odps.sql.using.public.model=true;
SET odps.namespace.schema=true;
DESC MODEL bigdata_public_modelset.default.Qwen3-4B-GGUF;

-- If tenant-level schema syntax is not enabled:
SET odps.sql.using.public.model=true;
SET odps.namespace.schema=false;
DESC MODEL bigdata_public_modelset.Qwen3-4B-GGUF;

Expected output:

+------------------------------------------------------------------------------------+
|                  Model Information                                                 |
+------------------------------------------------------------------------------------+
| Owner:                    ALIYUN$*********************                             |
| Project:                  bigdata_public_modelset                                  |
| Model Name:               Qwen3-4B-GGUF                                            |
| Model Type:               LLM                                                      |
| Source Type:              IMPORT                                                   |
| Default Version:          v1                                                       |
| CreateTime:               2025-09-25 23:38:35                                      |
| LastModifiedTime:         2025-09-25 23:38:35                                      |
| Comment:                  MaxCompute Public LLM Model Qwen3-4B-GGUF with 4-bit mixed quantization and K-means clustering (Q4_K_M), using default settings {"max_tokens": 500, "temperature": 0.6, "top_p": 0.95}. Source:https://huggingface.co/unsloth/Qwen3-4B-GGUF |
+------------------------------------------------------------------------------------+
|                Version Information                                                 |
+------------------------------------------------------------------------------------+
| Owner:                    ALIYUN$*********************                             |
| Project:                  bigdata_public_modelset                                  |
| Model Name:               Qwen3-4B-GGUF                                            |
| Model Type:               LLM                                                      |
| Source Type:              IMPORT                                                   |
| Version Name:             v1                                                       |
| Path:                                                                              |
| CreateTime:               2025-09-25 23:38:35                                      |
| LastModifiedTime:         2025-09-25 23:38:35                                      |
+------------------------------------------------------------------------------------+
| Input           | Type       | Comment                                             |
+------------------------------------------------------------------------------------+
| prompt          | string     |                                                     |
| settings        | string     |                                                     |
+------------------------------------------------------------------------------------+

What's next

Modify a model version — Change the default version or update model properties.
Model types — Browse available public models in the BIGDATA_PUBLIC_MODELSET project.
Schema operations — Learn how tenant-level schema syntax affects model name qualification.