maxcompute tenant-level metadata service information schema overview - MaxCompute

This topic describes the functionality, limits, important considerations, list of metadata views, and Resource Access Management (RAM) user authorization procedures for MaxCompute’s tenant-level metadata service Information Schema.

Function Introduction

MaxCompute’s Information Schema provides project metadata and usage history data. The Tenant-level Information Schema is an enhanced version of the original Information Schema. It extends the ANSI SQL-92 Information Schema with MaxCompute-specific fields and views. Each Alibaba Cloud account includes a built-in project named SYSTEM_CATALOG, which contains a read-only INFORMATION_SCHEMA.

You can query metadata and usage history for all projects associated with your Alibaba Cloud account by accessing the read-only views in this built-in schema. Metadata and job history data are stored exclusively under SYSTEM_CATALOG.INFORMATION_SCHEMA.

Use the Information_Schema metadata views to browse and retrieve metadata.
Use the Information_Schema usage information views to analyze job runtime metrics, such as resource consumption, runtime duration, and data processing volume. This helps you optimize jobs or plan compute capacity.

Different views have varying data freshness levels and system-defined retention periods. Data older than the retention period becomes unavailable. To retain historical data beyond 14 days or back up job history using snapshots, periodically export data from Information_Schema to local tables or specified projects.

When exporting data, explicitly specify the view’s field names. Avoid using INSERT INTO SELECT * FROM information_schema.***. This prevents backup failures if new fields are added to the view.

Scope

The Information Schema provides metadata views for the current user only. It does not support cross-Metadata Center metadata access. Metadata Centers are grouped as follows:
- All regions in the Chinese mainland—Shanghai, Hangzhou, Beijing, Shenzhen, Chengdu, Zhangjiakou, and Ulanqab—form one Metadata Center.
- Hong Kong (China) forms one Metadata Center.
- Each region outside China forms one Metadata Center.
- Finance Cloud—Shanghai Finance Zone and Shenzhen Finance Zone—forms one Metadata Center.
- Alibaba Gov Cloud—Beijing—forms one Metadata Center.
The built-in SYSTEM_CATALOG project is read-only. Run queries from projects located in the same region. For metadata query examples, see Query Examples.
You can access tables through SQL only using MaxCompute SQL analysis, the latest version of the client, DataStudio in DataWorks, or SQL scheduling nodes.
Metadata system tables provide Near Real-Time views. For applications requiring high metadata timeliness, use the SDK or CLI to directly retrieve metadata for specific objects.

Billing

Compute Fees
- For pay-as-you-go compute resource projects, queries against Information Schema views incur standard query fees. These fees are calculated based on the underlying expanded SQL of the view.
  Information Schema views are optimized using range clustered tables to improve query performance and reduce input data volume.
  If you query the TASKS_HISTORY or TUNNELS_HISTORY views, query the previous day’s data after 6:00:00 daily and avoid querying the current day’s data. This minimizes input volume and reduces query fees.
- For subscription compute resource projects, querying Information Schema views consumes purchased compute units (CUs).
Storage Fees: You do not pay storage fees for Information Schema views.

Metadata View List

View	View Description	Timeliness	Latency Description
CATALOGS	List of projects.	Near Real-Time view	There is some latency with online data, approximately 3 hours.
CATALOG_PRIVILEGES	Project-level permissions.
COLUMNS	Column information for tables in each project.
COLUMN_LABEL_GRANTS	Label authorization information for table columns in each project.
COLUMN_LABELS	Label information at the column level for tables in each project.
COLUMN_PRIVILEGES	Permission information at the column level for tables in each project.
INSTALLED_PACKAGES	Information about installed packages in each project.
PACKAGE_PRIVILEGES	Package authorization information.
PACKAGE_OBJECTS	Object information in packages.
PARTITIONS	Table partition information for each project.
PARTITION_ACCESS_INFO	Access statistics for table partitions in each project.
RESOURCES	Resource information for each project.
RESOURCE_PRIVILEGES	Permission information for resources in each project.
ROLES	List of project-level and account-level roles.
TABLES	Table information for each project.
TABLE_ACCESS_INFO	Access statistics for tables in each project.
TABLE_LABEL_GRANTS	Label authorization information.
TABLE_LABELS	Label information for tables in each project.
TABLE_PRIVILEGES	Permission information for tables in each project.
UDF_PRIVILEGES	UDF authorization information for each project.
UDFS	UDF information for each project.
UDF_RESOURCES	Resource dependencies for UDFs in each project.
USERS	List of users.
USER_ROLES	Role information owned by users.
SCHEMAS	Schema information for projects.
TASKS	Real-time snapshots of running jobs for real-time job monitoring.		There is second-level latency with online data. This feature is currently in private preview, has no Service-Level Agreement (SLA) guarantee, and will be gradually released later.
TASKS_HISTORY	History of completed jobs in each project. This is a partitioned table that retains data for the last 14 days.		There is some latency with online data, approximately 3 hours.
TUNNELS_HISTORY	History of bulk upload and download data for data tunnels. This is a partitioned table that retains data for the last 14 days.

Query Examples

Query metadata information as follows:

Example 1: Query metadata for all tables in the target project.

-- Initiate a query in an SQL-executable project under the tenant.
USE <project_name>;
SET odps.namespace.schema=true;
SELECT * FROM SYSTEM_CATALOG.INFORMATION_SCHEMA.tables;

Example 2: Query all job history information in the Metadata Center where the target project resides, and include a date field for filtering.

-- Initiate a query in an SQL-executable project under the tenant.
USE <project_name>;
SET odps.namespace.schema=true;
SELECT * FROM SYSTEM_CATALOG.INFORMATION_SCHEMA.tasks_history where ds='yyyymmdd' limit 100;

RAM User Access Authorization

Information Schema views contain all tenant-level user data. By default, the Alibaba Cloud account (main account) can view this data. To allow a Resource Access Management (RAM) user (sub-account) to view it, grant appropriate authorization.

Note

Only the Alibaba Cloud account (main account) or a RAM user (sub-account) with the Super_Administrator or Admin role at the account level can perform authorization operations.

Log on to the MaxCompute console, and select a region in the upper-left corner.
In the navigation pane on the left, choose Manage Configurations > Tenants.
On the Tenants page, click the Roles tab.

On the Roles tab, click Add Role. In the Add Role dialog box, enter a Role Name and Policy Content, and then click OK to create the role.

For example, create a new role to view all views under SYSTEM_CATALOG.INFORMATION_SCHEMA. Configure the Policy Content as follows:

{
    "Statement":[
        {
            "Action":[
                "odps:Describe",
                "odps:Select"
            ],
            "Effect":"Allow",
            "Resource":[
                "acs:odps:*:catalogs/system_catalog/schemas/information_schema/tables/*"
            ]
        },
        {
            "Action":[
                "odps:List"
            ],
            "Effect":"Allow",
            "Resource":[
                "acs:odps:*:catalogs/system_catalog/schemas/information_schema"
            ]
        }
    ],
    "Version":"1"
}

On the Tenants page, click the Users tab.
On the Users tab, click Add Member. In the Add Member dialog box, select or add the accounts to which you want to assign roles. In the Batch Set Roles area, select the roles to assign, click , and then click OK.
For details about user management operations, see User Planning and Management.

CATALOGS

List of projects.

Field	Type	Value
catalog_name	STRING	Project name.
status	STRING	Project status. Values: Normal, Frozen.
create_time	DATETIME	Project creation time.
owner_id	STRING	Project owner ID.
owner_name	STRING	Alibaba Cloud account name of the project owner.
settings	STRING	Project property settings.
region	STRING	Project region.

CATALOG_PRIVILEGES

Project-level permissions, such as CreateInstance and ListTable.

Field	Type	Value
catalog_name	STRING	Project name.
user_catalog	STRING	Project to which the authorized account belongs.
user_name	STRING	Authorized account.
user_id	STRING	Authorized account ID.
grantor	STRING	Grantor account. This is a reserved field.
privilege_type	STRING	Permission type.

COLUMNS

Column information for tables in each project.

Field	Type	Value
table_catalog	STRING	Project name of the table.
table_schema	STRING	Schema of the table. Currently NULL.
table_name	STRING	Table name.
column_name	STRING	Column name.
ordinal_position	BIGINT	Column ordinal number.
column_default	STRING	Column default value.
is_nullable	BOOLEAN	Indicates whether NULL values are allowed.
data_type	STRING	Data type, such as STRING or BIGINT.
column_comment	STRING	Column comment.
is_partition_key	BOOLEAN	Indicates whether it is a partition key column.
is_primary_key	BOOLEAN	Indicates whether it is a primary key column.

COLUMN_LABEL_GRANTS

Label authorization information for table columns in each project.

Field	Type	Value
table_catalog	STRING	Project name of the table.
table_schema	STRING	Schema of the table.
table_name	STRING	Table name.
column_name	STRING	Column name.
user_catalog	STRING	Project name of the user.
user_name	STRING	User name.
user_id	STRING	User ID.
grantor	STRING	Grantor account. This is a reserved field.
label_level	STRING	Granted label level.
expired	DATETIME	Expired At.

COLUMN_LABELS

Column-level label information for tables in each project.

Field	Type	Value
table_catalog	STRING	Project name of the table.
table_schema	STRING	Schema of the table. Currently NULL.
table_name	STRING	Table name.
column_name	STRING	Column name.
label_type	STRING	Label type.
label_level	STRING	Label level.

COLUMN_PRIVILEGES

Column-level permission information for tables in each project.

Field	Type	Value
table_catalog	STRING	Project name of the table.
table_schema	STRING	Schema of the table.
table_name	STRING	Table name.
column_name	STRING	Column name.
user_catalog	STRING	Project name of the user.
user_name	STRING	User name.
user_id	STRING	User ID.
grantor	STRING	Grantor account. This is a reserved field.
privilege_type	STRING	Permission type.

INSTALLED_PACKAGES

Information about installed packages in each project.

Field	Type	Value
installed_package_catalog	STRING	Project name where the package is installed.
package_catalog	STRING	Project to which the package belongs.
package_name	STRING	Package name.
installed_time	STRING	Installation time.
allowed_label	STRING	Shared label settings.

PACKAGE_PRIVILEGES

Package authorization information.

Field	Type	Value
package_catalog	STRING	Project to which the package belongs.
package_name	STRING	Package name.
user_catalog	STRING	Project to which the authorized user belongs.
user_name	STRING	Authorized user name.
user_id	STRING	Authorized user ID.
grantor	STRING	Grantor account. This is a reserved field.
privilege_type	STRING	Permission type.

PACKAGE_OBJECTS

Object information in packages.

Field	Type	Value
package_catalog	STRING	Project to which the package belongs.
package_name	STRING	Package name.
object_schema	STRING	Schema to which the object in the package belongs.
object_type	STRING	Type of the package object.
object_name	STRING	Name of the package object.
column_name	STRING	Table column name. This requires the object_type to be set to table.
allowed_privilege	STRING	Shared permission settings.
allowed_label	STRING	Shared label settings.

PARTITIONS

Table partition information for each project.

Field	Type	Value
table_catalog	STRING	Project name of the table.
table_schema	STRING	Schema of the table.
table_name	STRING	Table name.
partition_name	STRING	Partition name.
create_time	DATETIME	Creation time of the partition.
last_modified_time	DATETIME	Last update time of the partition.
last_access_time	DATETIME	Last access time of the partition. This is a reference value, with a maximum 24-hour difference from the actual last data access time. This data has been progressively collected since July 2023. The last_access_time cannot be collected for data not accessed after the upgrade or accessed via ALGO jobs or Hologres direct read.
data_length	BIGINT	Partition data size, in bytes.
is_archived	BOOLEAN	Reserved field, no meaning.
is_exstore	BOOLEAN	Reserved field, no meaning.
storage_tier	STRING	Tiered storage identifier. Values: standard: Standard storage. lowfrequency: IA storage class. longterm: Long-term storage.
cluster_type	STRING	Clustering type of the MaxCompute table. Values: HASH RANGE
number_buckets	BIGINT	Optional field. Number of buckets for a clustered table. 0 indicates dynamic determination during job execution.
lifecycle_enabled	BOOLEAN	Indicates whether partition lifecycle is enabled.

PARTITION_ACCESS_INFO

Access statistics for table partitions in each project.

Field	Type	Value
table_catalog	STRING	Project name of the table.
table_schema	STRING	Schema of the table. For non-Layer 3 model projects, this is default.
table_name	STRING	Table name.
partition_name	STRING	Partition name.
access_count	BIGINT	Number of accesses on the archive date.
access_bytes	BIGINT	Total data accessed on the archive date, in bytes.
ds	STRING	Data archive date.

RESOURCES

Resource information for each project.

Field	Type	Value
resource_catalog	STRING	Project name of the resource.
resource_schema	STRING	Schema of the resource.
resource_name	STRING	Resource name.
resource_type	STRING	Resource type. Values: archive py jar table
owner_id	STRING	ID of the resource owner.
owner_name	STRING	Alibaba Cloud account name of the resource owner.
create_time	DATETIME	Creation time of the resource.
last_modified_time	DATETIME	Last update time of the resource.
size	BIGINT	Storage space occupied by the resource, in bytes.
comment	STRING	Resource comment.
is_temp_resource	BOOLEAN	Indicates whether it is a temporary resource.

RESOURCE_PRIVILEGES

Permission information for resources in each project.

Field	Type	Value
resource_catalog	STRING	Project name of the resource.
resource_schema	STRING	Schema of the resource.
resource_name	STRING	Resource name.
user_catalog	STRING	Project space of the authorized account.
user_name	STRING	Authorized account name.
user_id	STRING	Authorized account ID.
grantor	STRING	Grantor account. This is a reserved field.
privilege_type	STRING	Permission type.

ROLES

List of project-level and account-level roles.

Field	Type	Value
role_catalog	STRING	Project name of the role. NULL indicates a tenant role.
role_name	STRING	Role name.
role_label	STRING	Role label.
comment	STRING	Role comment.

TABLES

Table information for each project.

Field	Type	Value
table_catalog	STRING	Project name of the table.
table_schema	STRING	Schema of the table.
table_name	STRING	Table name.
table_type	STRING	Table type. Values: MANAGED_TABLE VIRTUAL_VIEW EXTERNAL_TABLE MATERIALIZED_VIEW
is_partitioned	BOOLEAN	Indicates whether it is a partitioned table.
owner_id	STRING	ID of the table owner.
owner_name	STRING	Alibaba Cloud account name of the table owner.
create_time	STRING	Creation time of the table.
last_modified_time	STRING	Last update time of the table data.
last_access_time	STRING	Last access time of the table. This is a reference value, with a maximum 24-hour difference from the actual last data access time. If the table is a partitioned table, this value is NULL. View the last access time for each partition in the PARTITIONS view. This data has been progressively collected since July 2023. The last_access_time cannot be collected for data not accessed after the upgrade or accessed via ALGO jobs or Hologres direct read.
data_length	BIGINT	Data volume, in bytes. If the table is not a partitioned table, this is the data volume of the table. If the table is a partitioned table, the system does not calculate the table's data volume, and this value is NULL. The PARTITIONS view contains the data volume for each partition of the partitioned table.
table_comment	STRING	Table comment.
lifecycle	BIGINT	Lifecycle, in days.
lifecycle_enabled	BOOLEAN	Indicates whether lifecycle recycling is enabled.
is_archived	BOOLEAN	Reserved field, no meaning.
table_exstore_type	STRING	Optional field. Identifies whether the current table is a logical table or a physical table of an extreme storage table. Values: EXSTORE_TABLE_VIRTUAL EXSTORE_TABLE_PHYSICAL
storage_tier	STRING	Tiered storage identifier. Values: standard: Standard storage. lowfrequency: IA storage class. longterm: Long-term storage.
cluster_type	STRING	Clustering type of the table. Values: HASH RANGE
number_buckets	BIGINT	Number of buckets for a clustered table. 0 indicates dynamic determination during job execution.
view_original_text	STRING	View definition for VIRTUAL_VIEW type tables.
has_primary_key	BOOLEAN	Indicates whether it has a primary key column.
is_transactional	BOOLEAN	Indicates whether it is a transactional table.
is_delta_table	BOOLEAN	Indicates whether it is a Delta Table.
table_storage	STRING	Table storage service.
table_format	STRING	Table storage format, such as ORC/Parquet.

TABLE_ACCESS_INFO

Access statistics for tables in each project.

Field	Type	Value
table_catalog	STRING	Project name of the table.
table_schema	STRING	Schema of the table. For non-Layer 3 model projects, this is default.
table_name	STRING	Table name.
access_count	BIGINT	Number of accesses on the archive date.
access_bytes	BIGINT	Total data accessed on the archive date, in bytes.
ds	STRING	Data archive date.

TABLE_LABEL_GRANTS

Label authorization information.

Field	Type	Value
table_catalog	STRING	Project name of the table.
table_schema	STRING	Schema of the table.
table_name	STRING	Table name.
user_catalog	STRING	Project to which the authorized account belongs.
user_name	STRING	Authorized account.
user_id	STRING	Authorized account ID.
grantor	STRING	Grantor account. This is a reserved field.
label_level	STRING	Label level.
expired	DATETIME	Expired At.

TABLE_LABELS

Label information for tables in each project.

Field	Type	Value
table_catalog	STRING	Project name of the table.
table_schema	STRING	Schema of the table. Currently NULL.
table_name	STRING	Table name.
label_type	STRING	Label type.
label_level	BIGINT	Label level.

TABLE_PRIVILEGES

Permission information for tables in each project.

Field	Type	Value
table_catalog	STRING	Project name of the table.
table_schema	STRING	Schema of the table. Currently NULL.
table_name	STRING	Table name.
user_catalog	STRING	Project space of the authorized account.
user_name	STRING	Authorized account.
user_id	STRING	Authorized account ID.
grantor	STRING	Grantor account. This is a reserved field.
privilege_type	STRING	Permission type.
expired	DATETIME	Permission expiration time.

TASKS

Real-time snapshots of currently running jobs for real-time monitoring.

Field	Type	Value
task_catalog	STRING	Project name of the task.
task_name	STRING	Job name.
task_type	STRING	Job type. Values: SQL: SQL job. CUPID: Spark or Mars job. SQLCost: SQL estimation job. SQLRT: Query acceleration SQL job. LOT: MapReduce job. PS: Parameter Server for PAI. AlgoTask: Machine learning job.
inst_id	STRING	Instance ID.
status	STRING	Job status. Values: Running Waiting
owner_id	STRING	Alibaba Cloud account ID of the job submitter.
owner_name	STRING	Alibaba Cloud account name of the job submitter.
start_time	DATETIME	Job start time.
priority	BIGINT	Job priority.
signature	STRING	Job signature.
quota_name	STRING	Compute Quota name.
cpu_usage	BIGINT	Current CPU usage. Value: core × 100.
mem_usage	BIGINT	Current memory usage, in MB.
gpu_usage	BIGINT	Current GPU usage. Value: cards × 100.
total_cpu_usage	BIGINT	Accumulated CPU usage. Value: core × 100 × seconds.
total_mem_usage	BIGINT	Accumulated memory usage. Value: MB × seconds.
total_gpu_usage	BIGINT	Accumulated GPU usage. Value: cards × 100 × seconds.
cpu_min_ratio	BIGINT	Current CPU occupancy ratio of the job's guaranteed queue watermark.
mem_min_ratio	BIGINT	Current memory occupancy ratio of the job's guaranteed queue watermark.
gpu_min_ratio	BIGINT	Current GPU occupancy ratio of the job's guaranteed queue watermark.
cpu_max_ratio	BIGINT	Current CPU occupancy ratio of the job's highest elastic queue watermark.
mem_max_ratio	BIGINT	Current memory occupancy ratio of the job's highest elastic queue watermark.
gpu_max_ratio	BIGINT	Current GPU occupancy ratio of the job's highest elastic queue watermark.
settings	STRING	Information passed by the upper-level scheduler or user, stored in JSON format. Includes fields such as USERAGENT, BIZID, SKYNET_ID, and SKYNET_NODENAME.
ext_platform_id	STRING	ID of the upper-level task scheduling platform.
ext_node_id	STRING	Node ID of the upper-level schedule.
ext_bizdate	STRING	Data timestamp of the upper-level scheduled task.
ext_task_id	STRING	Node instance ID of the upper-level schedule.
ext_dagtype	STRING	Running mode of the upper-level scheduling instance.
ext_node_name	STRING	Node name of the upper-level schedule.
ext_node_onduty	STRING	ID of the owner of the upper-level scheduling node.
ext_node_priority	BIGINT	Priority of the upper-level scheduling node.
ext_node_cyctype	STRING	Scheduling cycle type of the upper-level scheduling node.
ext_subtask_id	STRING	Subtask ID of the upper-level scheduling node.
additional_info	STRING	Additional information. This is a reserved field.

TASKS_HISTORY

History of completed jobs in each project. This is a partitioned table that retains data for the last 14 days.

Field	Type	Value
task_catalog	STRING	Project name of the task.
task_name	STRING	Job name.
task_type	STRING	Job type. Values: SQL: SQL job. CUPID: Spark or Mars job. SQLCost: SQL estimation job. SQLRT: Query acceleration SQL job. LOT: MapReduce job. PS: Parameter Server for PAI. AlgoTask: Machine learning job (no resource consumption or data scan information).
inst_id	STRING	Job instance ID.
status	STRING	Job status at the moment of data collection (not real-time). Values include the following: Terminated: The job has finished executing. Failed: The job failed. Cancelled: The job was canceled.
owner_id	STRING	Alibaba Cloud account ID of the job submitter.
owner_name	STRING	Alibaba Cloud account name of the job submitter.
result	STRING	Job execution error message.
priority	BIGINT	Job priority.
submit_time	DATETIME	Job submission time, which is the instance generation time.
start_time	DATETIME	Job start time, such as the SQL compilation start time.
end_time	DATETIME	Job end time.
input_records	BIGINT	Number of input records. Note This information is NULL when the SQL job hits the query acceleration caching mechanism.
output_records	BIGINT	Number of output records. Note This information is NULL when the SQL job hits the query acceleration caching mechanism.
input_bytes	BIGINT	Standard storage input data volume, in bytes. Note This information is NULL when the SQL job hits the query acceleration caching mechanism.
lowfrequency_storage_input_bytes	BIGINT	IA storage class input data volume, in bytes. Note This information is NULL when the SQL job hits the query acceleration caching mechanism.
longterm_storage_input_bytes	BIGINT	Long-term storage input data volume, in bytes. Note This information is NULL when the SQL job hits the query acceleration caching mechanism.
oss_input_bytes	BIGINT	OSS foreign table input data volume, in bytes. Note This information is NULL when the SQL job hits the query acceleration caching mechanism.
tablestore_input_bytes	BIGINT	Tablestore foreign table input data volume, in bytes. Note This information is NULL when the SQL job hits the query acceleration caching mechanism.
output_bytes	BIGINT	Output data volume, in bytes. Note This information is NULL when the SQL job hits the query acceleration caching mechanism.
input_tables	STRING	List of input tables, for SQL jobs only. Note This information is NULL when the SQL job hits the query acceleration caching mechanism.
output_tables	STRING	List of output tables, for SQL jobs only. Note This information is NULL when the SQL job hits the query acceleration caching mechanism.
operation_text	STRING	Job statement, with a maximum limit of 256 KB.
signature	STRING	Job signature.
quota_name	STRING	Compute Quota name.
complexity	DOUBLE	SQL job complexity.
cost_cpu	DOUBLE	Job CPU consumption (100 represents `1 core × 1 s`. For example, 10 cores running for 5 seconds results in a cost_cpu of 10 × 100 × 5 = 5000).
cost_mem	DOUBLE	Job memory consumption, value: MB × seconds.
cost_indicators	STRING	Job resource information, suitable for job resource analysis and optimization.
settings	STRING	Information passed by the upper-level scheduler or user, stored in JSON format. Includes fields such as USERAGENT, BIZID, SKYNET_ID, and SKYNET_NODENAME.
ext_platform_id	STRING	ID of the upper-level task scheduling platform. The requester must actively pass this information when initiating a job. For conventions on passing information, see Job Common Identifier Conventions.
ext_node_id	STRING	Node ID of the upper-level schedule. The requester must actively pass this information when initiating a job. For conventions on passing information, see Job Common Identifier Conventions.
ext_bizdate	STRING	Data timestamp of the upper-level scheduled task. The requester must actively pass this information when initiating a job. For conventions on passing information, see Job Common Identifier Conventions.
ext_task_id	STRING	Node instance ID of the upper-level schedule. The requester must actively pass this information when initiating a job. For conventions on passing information, see Job Common Identifier Conventions.
ext_dagtype	STRING	Running mode of the upper-level scheduling instance. The requester must actively pass this information when initiating a job. For conventions on passing information, see Job Common Identifier Conventions.
ext_node_name	STRING	Node name of the upper-level schedule. The requester must actively pass this information when initiating a job. For conventions on passing information, see Job Common Identifier Conventions.
ext_node_onduty	STRING	ID of the owner of the upper-level scheduling node. The requester must actively pass this information when initiating a job. For conventions on passing information, see Job Common Identifier Conventions.
ext_node_priority	BIGINT	Priority of the upper-level scheduling node. The requester must actively pass this information when initiating a job. For conventions on passing information, see Job Common Identifier Conventions.
ext_node_cyctype	STRING	Reserved field, no meaning. The requester must actively pass this information when initiating a job. For conventions on passing information, see Job Common Identifier Conventions.
ext_subtask_id	STRING	Subtask ID of the upper-level scheduling node. The requester must actively pass this information when initiating a job. For conventions on passing information, see Job Common Identifier Conventions.
ds	STRING	Data archive date.Archived based on the UTC+8 time zone of the job's `start_time`.

TUNNELS_HISTORY

Historical data for batch upload and download operations through the tunnel is retained for the past 14 days.

Field	Type	Value
tunnel_catalog	STRING	Project to which the operated resource belongs.
tunnel_schema	STRING	Schema to which the operated resource belongs. Currently NULL.
session_id	STRING	Session ID.
operate_type	STRING	Operation type. Values: UPLOADLOG DOWNLOADLOG DOWNLOADINSTANCELOG STORAGEAPIREAD STORAGEAPIWRITE
tunnel_type	STRING	Channel type. Values: TUNNEL LOG TUNNEL INSTANCE LOG
request_id	STRING	Request ID.
object_type	STRING	Operation object type. Values: TABLE INSTANCE
object_name	STRING	Operation object name, which is the table name or instance ID.
partition_spec	STRING	Partition for uploading or downloading partitioned tables. Example: `time=20130222, loc=beijing`
data_size	BIGINT	Data size in bytes.
block_id	BIGINT	Block number for Tunnel uploads. Valid only when operate_type is UPLOADLOG; otherwise empty.
offset	BIGINT	Starting offset position for downloads, indicating the record number from which to start (starting from 0).
length	BIGINT	Number of records uploaded or downloaded in this operation (for downloads, this is the specified length value).
owner_id	STRING	Alibaba Cloud account ID of the operator.
owner_name	STRING	Alibaba Cloud account name of the operator.
start_time	DATETIME	Time when the request is initiated.
end_time	DATETIME	Request end time.
client_ip	STRING	IP address of the client initiating the Tunnel request.
user_agent	STRING	User Agent, containing information about the client initiating the Tunnel request, such as Java version and operating system.
columns	STRING	Set of columns specified when downloading data via Tunnel.
quota_name	STRING	Tunnel Quota group name.
app_tag	STRING	Custom tag
ds	STRING	Data collection date, for example `ds=20190101`.Archived based on the UTC+8 time zone of the request's `start_time`.

UDF_PRIVILEGES

UDF authorization information for each project.

Field	Type	Value
udf_catalog	STRING	Project name where the UDF resides.
udf_schema	STRING	Schema where the UDF resides.
udf_name	STRING	UDF name.
user_catalog	STRING	Project space of the authorized account.
user_name	STRING	Authorized account.
user_id	STRING	Authorized account ID.
grantor	STRING	Grantor account. This is a reserved field.
privilege_type	STRING	Permission type.

UDFS

UDF information for each project.

Field	Type	Value
udf_catalog	STRING	Project name where the UDF resides.
udf_schema	STRING	Schema where the UDF resides. Currently NULL.
udf_name	STRING	UDF name.
owner_id	STRING	ID of the UDF owner.
owner_name	STRING	Alibaba Cloud account name of the UDF owner.
create_time	DATETIME	Creation time.
last_modified_time	DATETIME	Last update time.

UDF_RESOURCES

Resource dependencies for UDFs in each project.

Field	Type	Value
udf_catalog	STRING	Project name where the UDF resides.
udf_schema	STRING	Schema where the UDF resides.
udf_name	STRING	UDF name.
resource_catalog	STRING	Project where the resource resides.
resource_schema	STRING	Schema where the resource resides.
resource_name	STRING	Resource name.

USERS

List of users.

Field	Type	Value
user_catalog	STRING	Project name of the user. NULL indicates a tenant-level user.
identity_provider	STRING	Account type. Values: ALIYUN RAM RAMRole
user_name	STRING	User name.
user_id	STRING	User ID.
user_label	STRING	User label.

USER_ROLES

Role information assigned to users.

Field	Type	Value
user_role_catalog	STRING	Project name of the role. NULL indicates a tenant-level role.
role_name	STRING	Role name.
user_name	STRING	User name.
user_id	STRING	User ID.

SCHEMAS

Schema information for projects.

Field	Type	Value
schema_catalog	STRING	Project name where the Schema resides.
schema_name	STRING	Schema name.
owner_id	STRING	Alibaba Cloud account ID of the Schema owner.
owner_name	STRING	Alibaba Cloud account name of the Schema owner.
create_time	DATETIME	Schema creation time.
last_modified_time	DATETIME	Last update time of the Schema.
schema_type	STRING	Schema type.
comment	STRING	Schema comment.

QUOTA_USAGE

Real-time snapshots of subscription compute quota usage for real-time monitoring of compute resource consumption.

Field	Type	Value
name	STRING	Quota name.
create_time	DATETIME	Quota creation time.
last_modified_time	DATETIME	Last update time of the Quota.
cpu_elastic_quota_max	BIGINT	Non-reserved CPU upper limit of the Quota, in `core*100`.
cpu_elastic_quota_min	BIGINT	Non-reserved CPU lower limit of the Quota, in `core*100`.
cpu_elastic_quota_used	BIGINT	Non-reserved CPU usage of the Quota, in `core*100`.
mem_elastic_quota_max	BIGINT	Non-reserved memory upper limit of the Quota, in `MB`.
mem_elastic_quota_min	BIGINT	Non-reserved memory lower limit of the Quota, in `MB`.
mem_elastic_quota_used	BIGINT	Non-reserved memory usage of the Quota, in `MB`.
cpu_adhoc_quota	BIGINT	Elastic reserved CPU of the Quota, in `core*100`.
cpu_adhoc_quota_used	BIGINT	Elastic reserved CPU usage of the Quota, in `core*100`.
mem_adhoc_quota	BIGINT	Elastic reserved memory of the Quota, in `MB`.
mem_adhoc_quota_used	BIGINT	Elastic reserved memory usage of the Quota, in `MB`.
cpu_quota_max	BIGINT	Reserved CPU upper limit of the Quota, in `core*100`.
cpu_quota_min	BIGINT	Reserved CPU lower limit of the Quota, in `core*100`.
cpu_quota_used	BIGINT	Reserved CPU usage of the Quota, in `core*100`.
mem_quota_max	BIGINT	Reserved memory upper limit of the Quota, in `MB`.
mem_quota_min	BIGINT	Reserved memory lower limit of the Quota, in `MB`.
mem_quota_used	BIGINT	Reserved memory usage of the Quota, in `MB`.
region	STRING	Region where the resource resides.

VOLUMES

MaxCompute Volume view with approximately 3-hour latency.

Field	Type	Value
volume_catalog	STRING	Project name where the Volume resides.
volume_name	STRING	Volume name.
volume_type	STRING	Volume type. Values: INTERNAL EXTERNAL
owner_id	STRING	ID of the Volume owner.
owner_name	STRING	Alibaba Cloud account name of the Volume owner.
create_time	DATETIME	Volume creation time.
last_modified_time	DATETIME	Last update time of the Volume data.
location	STRING	Volume storage path.
comment	STRING	Volume comment.
storage_provider	STRING	Volume storage engine.
role_arn	STRING	Volume storage access role ARN.
lifecycle	BIGINT	Volume lifecycle, in days.
options	STRING	Volume option parameters.

FOREIGN_SERVERS

MaxCompute ForeignServer view with approximately 3-hour latency.

Field	Type	Value
server_name	STRING	Server name.
server_type	STRING	Server type.
owner_id	STRING	ID of the Server owner.
owner_name	STRING	Alibaba Cloud account name of the Server owner.
create_time	DATETIME	Server creation time.
last_modified_time	DATETIME	Last update time of the data.
options	STRING	Server option parameters.