Introduces the tenant-level Information Schema, a metadata service in MaxCompute. - MaxCompute

This topic describes Information Schema, the tenant-level metadata service in MaxCompute, covering its features, limitations, considerations, metadata views, and RAM user authorization.

Features

The Information Schema in MaxCompute lets you access project metadata and usage history. The tenant-level Information Schema enhances the original Information Schema. It extends the ANSI SQL-92 Information Schema by adding fields and views specific to MaxCompute. For each Alibaba Cloud account, MaxCompute automatically creates a project named SYSTEM_CATALOG that contains a built-in INFORMATION_SCHEMA.

By accessing the read-only views in this built-in schema, you can query the metadata and usage history for all projects in your Alibaba Cloud account. The system stores the metadata and job history data exclusively in SYSTEM_CATALOG.INFORMATION_SCHEMA.

Use the metadata views in Information Schema to browse and retrieve metadata.
Use the usage information views in Information Schema to analyze job performance. You can review metrics such as resource consumption, runtime duration, and data processed to optimize jobs or plan resource capacity.

Different views have varying data freshness and default retention periods. Data that exceeds the retention period becomes inaccessible. If you need to create a snapshot of historical data or retain job history for more than 14 days, you can periodically export data from Information Schema to a local table or a specified project.

When exporting data, explicitly specify the column names from the view. Avoid using queries such as INSERT INTO SELECT * FROM information_schema.***. This practice prevents backup failures if new columns are added to the view.

Scope

Information Schema provides metadata views that are scoped to the current user. It does not support accessing metadata across metadata centers. The metadata centers are organized as follows:
- The Chinese mainland regions (China (Shanghai), China (Hangzhou), China (Beijing), China (Shenzhen), China (Chengdu), China (Zhangjiakou), and China (Ulanqab)) share one metadata center.
- The China (Hong Kong) region is a separate metadata center.
- Each international region has its own metadata center.
- The Finance Cloud (Shanghai Finance and Shenzhen Finance) shares one metadata center.
- The Government Cloud in China (Beijing) is a separate metadata center.
The built-in SYSTEM_CATALOG project is read-only. To query it, you must run a job from a project in the corresponding region. For examples, see Query examples.
Currently, you can query these tables using SQL only from MaxCompute SQL analysis, the latest client version, and DataWorks via DataStudio or an SQL scheduling node.
The metadata system tables provide near-real-time views. For applications requiring high metadata freshness, we recommend using the SDK/CLI to directly retrieve specific object metadata.

Fees

Computing costs
- For projects using pay-as-you-go compute resources, you incur query costs when you query Information Schema views. The cost depends on the underlying SQL query that runs when a view is accessed.
  To improve query performance and reduce the amount of data scanned, Information Schema views are optimized with range-clustered tables.
  To minimize the amount of data scanned and reduce query costs when querying the TASKS_HISTORY and TUNNELS_HISTORY views, wait until after 06:00:00 each day to query data from the previous day. Avoid querying data from the current day.
- For projects using subscription compute resources, queries against Information Schema views consume your purchased CUs (Compute Units).
Storage costs: You are not charged for storing Information Schema views.

Metadata views

View	Description	Timeliness	Delay description
CATALOGS	Lists projects.	Near-real-time view	Data is delayed by approximately 3 hours.
CATALOG_PRIVILEGES	Lists project-level privileges.
COLUMNS	Lists columns in each project.
COLUMN_DATA_MASKING_POLICIES	Lists data masking policies for columns in each project.
COLUMN_LABEL_GRANTS	Lists label grants on columns in each project.
COLUMN_LABELS	Lists column-level labels for tables in each project.
COLUMN_PRIVILEGES	Lists column-level privileges for tables in each project.
DATA_MASKING_POLICIES	Lists data masking policies in each project.
INSTALLED_PACKAGES	Lists installed packages in each project.
PACKAGE_PRIVILEGES	Lists privilege grants on packages.
PACKAGE_OBJECTS	Lists objects within packages.
PARTITIONS	Lists partitions in each project.
PARTITION_ACCESS_INFO	Lists access statistics for partitions in each project.
RESOURCES	Lists resources in each project.
RESOURCE_PRIVILEGES	Lists privileges on resources in each project.
ROLES	Lists roles at the project and account levels.
TABLES	Lists tables in each project.
TABLE_ACCESS_INFO	Lists access statistics for tables in each project.
TABLE_LABEL_GRANTS	Lists label grants on tables.
TABLE_LABELS	Lists labels on tables in each project.
TABLE_PRIVILEGES	Lists privileges on tables in each project.
UDF_PRIVILEGES	Lists privilege grants on UDFs in each project.
UDFS	Lists UDFs in each project.
UDF_RESOURCES	Lists the resource dependencies for UDFs in each project.
USERS	Lists users.
USER_ROLES	Lists roles assigned to users.
SCHEMAS	Lists schemas in each project.
TASKS	Provides a real-time snapshot of running tasks. Use this view for real-time task monitoring.		The data is delayed by several seconds. This feature is in Preview and is not covered by an SLA. It will be rolled out gradually.
TASKS_HISTORY	Provides a history of completed tasks in each project. This is a partitioned table that retains data for the last 14 days.		Data is delayed by approximately 3 hours.
TUNNELS_HISTORY	Provides a history of bulk uploads and downloads through tunnels. This is a partitioned table that retains data for the last 14 days.		Data is delayed by approximately 3 hours.

Query examples

The following examples show how to query metadata.

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

-- Run this query from a project in your tenant.
USE <project_name>;
SET odps.namespace.schema=true;
SELECT * FROM SYSTEM_CATALOG.INFORMATION_SCHEMA.tables;

Example 2: Query all job history from the target project's metadata center, and filter the results by a date field.

-- Run this query from a project in your tenant.
USE <project_name>;
SET odps.namespace.schema=true;
SELECT * FROM SYSTEM_CATALOG.INFORMATION_SCHEMA.tasks_history where ds='yyyymmdd' limit 100;

RAM user authorization

The views in Information Schema contain all tenant-level user data. By default, only an Alibaba Cloud account (primary account) can view this data. If a RAM user (sub-account) needs to access this data, you must grant the required permissions.

Note

Only an Alibaba Cloud account (primary account) or a RAM user (sub-account) with the account-level Super_Administrator or Admin role can grant these permissions.

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 pop-up Add Role dialog box, enter a custom Role Name and Policy Content, and then click OK to create the role.

For example, a new role is allowed to view all views under SYSTEM_CATALOG.INFORMATION_SCHEMA. The Policy Content is configured 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 manually add the accounts to which you want to assign a role. In the Batch Set Roles area, select the role to assign to these accounts, click , and then click OK to complete the configuration.
For more information about user management, see User planning and management.

Catalogs

Each catalog contains the following fields.

Parameter	Type	Description
catalog_name	STRING	The name of the catalog.
status	STRING	The status of the catalog. Valid values: Allowed and Denied.
create_time	DATETIME	The time the catalog was created.
owner_id	STRING	The ID of the catalog owner.
owner_name	STRING	The name of the catalog owner's Alibaba Cloud account.
settings	STRING	The settings for the catalog.
region	STRING	The region of the catalog.

CATALOG_PRIVILEGES

Project-level privileges, such as CreateInstance and ListTable.

Parameter	Type	Description
catalog_name	STRING	The project name.
user_catalog	STRING	The grantee's project.
user_name	STRING	The grantee's name.
user_id	STRING	The grantee ID.
grantor	STRING	The grantor. This field is reserved.
privilege_type	STRING	The privilege type.

Columns

This view lists the columns for tables in each project.

Parameter	Type	Description
table_catalog	STRING	The name of the project that contains the table.
table_schema	STRING	The schema that contains the table. This value is currently NULL.
table_name	STRING	The name of the table.
column_name	STRING	The name of the column.
ordinal_position	BIGINT	The ordinal position of the column.
column_default	STRING	The default value for the column.
is_nullable	BOOLEAN	`TRUE` if the column can contain NULL values; `FALSE` otherwise.
data_type	STRING	The data type of the column, such as STRING or BIGINT.
column_comment	STRING	The comment for the column.
is_partition_key	BOOLEAN	`TRUE` if the column is a partition column; `FALSE` otherwise.
is_primary_key	BOOLEAN	`TRUE` if the column is a primary key column; `FALSE` otherwise.

Column data masking policies

This view shows the data masking policies on table columns in each project.

Parameter	Type	Description
table_catalog	STRING	The name of the project to which the table belongs.
table_schema	STRING	The name of the schema to which the table belongs.
table_name	STRING	The name of the table.
column_name	STRING	The name of the column.
policy_name	STRING	The name of the policy.

COLUMN_LABEL_GRANTS

This view contains information about label grants for table columns in each project.

Parameter	Type	Value
table_catalog	STRING	The name of the project that contains the table.
table_schema	STRING	The schema that contains the table.
table_name	STRING	The name of the table.
column_name	STRING	The name of the column.
user_catalog	STRING	The name of the project that the user belongs to.
user_name	STRING	The name of the user.
user_id	STRING	The ID of the user.
grantor	STRING	The grantor of the label. This is a reserved field.
label_level	STRING	The level of the granted label.
expired	DATETIME	The expiration time.

Column labels

This view contains column-level label information for tables in each project.

Parameter	Type	Description
table_catalog	STRING	The name of the project containing the table.
table_schema	STRING	The schema containing the table. This is currently NULL.
table_name	STRING	The name of the table.
column_name	STRING	The name of the column.
label_type	STRING	The type of the label.
label_level	STRING	The level of the label.

COLUMN_PRIVILEGES

This view lists the column-level privileges on tables in each project.

Column	Type	Description
table_catalog	STRING	The name of the project that contains the table.
table_schema	STRING	The schema that contains the table.
table_name	STRING	The name of the table.
column_name	STRING	The name of the column.
user_catalog	STRING	The name of the project that contains the user.
user_name	STRING	The name of the user.
user_id	STRING	The user ID.
grantor	STRING	This field is reserved.
privilege_type	STRING	The type of the privilege.

Data masking policies

This view lists the data masking rules for each project.

Parameter	Type	Description
policy_catalog	STRING	The name of the project that contains the policy.
policy_name	STRING	The name of the policy.
policy_type	STRING	The type of data masking for the policy.
user_name	STRING	The user account that this policy applies to.
user_id	STRING	The ID of the user account that this policy applies to.
is_default	BOOLEAN	`TRUE` if this is the default policy; `FALSE` otherwise.
create_time	DATETIME	The time the policy was created.
last_modified_time	DATETIME	The time the policy was last modified.
options	STRING	The configuration options for the policy.

INSTALLED_PACKAGES

This view lists the packages installed in each project.

Parameter	Type	Description
installed_package_catalog	STRING	The name of the project where the package is installed.
package_catalog	STRING	The project that owns the package.
package_name	STRING	The name of the package.
installed_time	STRING	The date and time when the package was installed.
allowed_label	STRING	The labels that control sharing for the package.

Package privileges

Information about package privileges.

Parameter	Type	Description
package_catalog	STRING	The project that contains the package.
package_name	STRING	The package name.
user_catalog	STRING	The project that contains the grantee.
user_name	STRING	The grantee name.
user_id	STRING	The grantee ID.
grantor	STRING	The grantor. This field is reserved.
privilege_type	STRING	The privilege type.

PACKAGE_OBJECTS

This view describes the objects in a package.

Parameter	Type	Description
package_catalog	STRING	The project that contains the package.
package_name	STRING	The name of the package.
object_schema	STRING	The schema of the package object.
object_type	STRING	The type of the package object.
object_name	STRING	The name of the package object.
column_name	STRING	The name of the table column. This field is returned only when object_type is 'table'.
allowed_privilege	STRING	The allowed privileges for the object.
allowed_label	STRING	The allowed labels for the object.

Partitions

This view contains information about table partitions in each project.

Parameter	Type	Value
table_catalog	STRING	The name of the project that contains the table.
table_schema	STRING	The schema that contains the table.
table_name	STRING	The name of the table.
partition_name	STRING	The name of the partition.
create_time	DATETIME	The creation time of the partition.
last_modified_time	DATETIME	The last modified time of the partition.
last_access_time	DATETIME	The approximate last access time of the partition, which may differ from the actual time by up to 24 hours. Data collection for this field has been progressively upgraded since July 2023. The `last_access_time` is not recorded for partitions that have not been accessed since the upgrade; it is also not recorded for those accessed via ALGO jobs or direct reads from Hologres.
data_length	BIGINT	The data size of the partition, in bytes.
is_archived	BOOLEAN	Reserved for future use.
is_exstore	BOOLEAN	Reserved for future use.
storage_tier	STRING	The tiered storage identifier. Valid values: `standard`: standard storage. `lowfrequency`: Infrequent Access storage. `longterm`: long-term storage.
cluster_type	STRING	The cluster type of a MaxCompute table. Valid values: `HASH` `RANGE`
number_buckets	BIGINT	Optional. The number of buckets for a clustered table. A value of 0 means the system determines this number at job runtime.
lifecycle_enabled	BOOLEAN	Specifies whether a lifecycle policy is enabled for the partition.

PARTITION_ACCESS_INFO

This view lists access statistics for table partitions in each project.

Parameter	Type	Description
table_catalog	STRING	The name of the project that contains the table.
table_schema	STRING	The schema that contains the table. For projects that do not use a three-level model, this value is 'default'.
table_name	STRING	The table name.
partition_name	STRING	The partition name.
access_count	BIGINT	The total number of accesses on the archive date.
access_bytes	BIGINT	The total size of data accessed on the archive date, in bytes.
ds	STRING	The date when the data was archived.

Resources

Provides information about the resources in each project.

Parameter	Type	Description
resource_catalog	STRING	The name of the project that contains the resource.
resource_schema	STRING	The schema that contains the resource.
resource_name	STRING	The name of the resource.
resource_type	STRING	The type of the resource. Valid values are: archive py jar table
owner_id	STRING	The ID of the resource owner.
owner_name	STRING	The name of the Alibaba Cloud account that owns the resource.
create_time	DATETIME	The creation time of the resource.
last_modified_time	DATETIME	The last modified time of the resource.
size	BIGINT	The size of the resource in bytes.
comment	STRING	The resource comment.
is_temp_resource	BOOLEAN	Indicates whether the resource is temporary.

Resource privileges

Lists privileges for resources in each project.

Parameter	Type	Value
resource_catalog	STRING	The name of the project containing the resource.
resource_schema	STRING	The schema containing the resource.
resource_name	STRING	The name of the resource.
user_catalog	STRING	The grantee's project.
user_name	STRING	The name of the grantee.
user_id	STRING	The ID of the grantee.
grantor	STRING	The grantor. This is a reserved field.
privilege_type	STRING	The privilege type.

Roles

Lists roles at the project and account levels.

Parameter	Type	Description
role_catalog	STRING	The project that contains the role. A `NULL` value indicates a tenant role.
role_name	STRING	The role's name.
role_label	STRING	The role's label.
comment	STRING	A description for the role.

Tables

Describes the tables in each project.

Parameter	Type	Description
table_catalog	STRING	The name of the project that contains the table.
table_schema	STRING	The schema that contains the table.
table_name	STRING	The table name.
table_type	STRING	The table type. Valid values: `MANAGED_TABLE`: A managed table. `VIRTUAL_VIEW`: A view. `EXTERNAL_TABLE`: An external table. `MATERIALIZED_VIEW`: A materialized view.
is_partitioned	BOOLEAN	`TRUE` if the table is a partitioned table; `FALSE` otherwise.
owner_id	STRING	The ID of the table owner.
owner_name	STRING	The Alibaba Cloud account name of the table owner.
create_time	DATETIME	The time the table was created.
last_modified_time	DATETIME	The time the table data was last modified.
last_access_time	DATETIME	The time the table was last accessed. This is an approximate value and can differ from the actual last access time by up to 24 hours. If the table is a partitioned table, this value is `NULL`. To view the last access time for each partition, see the PARTITIONS view. Data collection for this field has been gradually upgraded since July 2023. The `last_access_time` cannot be collected for tables that have not been accessed since the upgrade or are accessed by ALGO jobs or direct reads from Hologres.
data_length	BIGINT	The data size of the table, in bytes. For a non-partitioned table, this is the data size of the table. For partitioned tables, this value is `NULL` because the system does not calculate the total data size. The PARTITIONS view contains the data size for each partition.
table_comment	STRING	The comment on the table.
lifecycle	BIGINT	The lifecycle of the table, in days.
lifecycle_enabled	BOOLEAN	`TRUE` if the lifecycle policy is enabled; `FALSE` otherwise.
is_archived	BOOLEAN	A reserved field.
table_exstore_type	STRING	Indicates whether the table is a logical or physical table in extreme storage. Valid values: `EXSTORE_TABLE_VIRTUAL`: A logical table. `EXSTORE_TABLE_PHYSICAL`: A physical table.
storage_tier	STRING	The table's tiered storage type. Valid values: `standard`: Standard storage. `lowfrequency`: Infrequent access storage. `longterm`: Archive storage.
cluster_type	STRING	The cluster type of the table. Valid values: `HASH` `RANGE`
number_buckets	BIGINT	The number of buckets for a clustered table. A value of 0 indicates the number is dynamically determined when a job runs.
view_original_text	STRING	The view definition, for tables where `table_type` is `VIRTUAL_VIEW`.
has_primary_key	BOOLEAN	`TRUE` if the table has a primary key; `FALSE` otherwise.
is_transactional	BOOLEAN	`TRUE` if the table is a transactional table; `FALSE` otherwise.
is_delta_table	BOOLEAN	`TRUE` if the table is a Delta Table; `FALSE` otherwise.
table_storage	STRING	The storage service of the table.
table_format	STRING	The storage format of the table, such as ORC or Parquet.

TABLE_ACCESS_INFO

This view provides access statistics for tables in each project.

Parameter	Type	Description
table_catalog	STRING	The name of the project that contains the table.
table_schema	STRING	The table's schema. This value is `default` for projects without the three-tier model.
table_name	STRING	The table name.
access_count	BIGINT	The access count on the archive date.
access_bytes	BIGINT	The total size of data accessed on the archive date, in bytes.
ds	STRING	The archive date of the data.

TABLE_LABEL_GRANTS

Lists the grants for table labels.

Parameter	Type	Description
table_catalog	STRING	The project that contains the table.
table_schema	STRING	The schema that contains the table.
table_name	STRING	The name of the table.
user_catalog	STRING	The project that contains the grantee account.
user_name	STRING	The name of the grantee account.
user_id	STRING	The ID of the grantee account.
grantor	STRING	The grantor account. This is a reserved field.
label_level	STRING	The level of the granted label.
expired	DATETIME	The date and time when the grant expires.

TABLE_LABELS

This view describes the labels applied to tables in each project.

Parameter	Type	Description
table_catalog	STRING	The name of the project that contains the table.
table_schema	STRING	The schema that contains the table. This is currently NULL.
table_name	STRING	The name of the table.
label_type	STRING	The type of the label.
label_level	BIGINT	The level of the label.

TABLE_PRIVILEGES

Provides information about the privileges on tables in each project.

Column	Type	Value
table_catalog	STRING	The name of the project that contains the table.
table_schema	STRING	The schema that contains the table. This is currently NULL.
table_name	STRING	The table name.
user_catalog	STRING	The name of the grantee's project.
user_name	STRING	The name of the grantee.
user_id	STRING	The ID of the grantee.
grantor	STRING	The grantor. This is a reserved field.
privilege_type	STRING	The privilege type.
expired	DATETIME	The privilege expiration time.

Tasks

Provides a real-time snapshot of running jobs.

Parameter	Type	Description
task_catalog	STRING	The name of the project that contains the job.
task_name	STRING	The name of the job.
task_type	STRING	The type of the job. Valid values: `SQL`: An SQL job. `CUPID`: A Spark or Mars job. `SQLCost`: An SQL cost estimation job. `SQLRT`: A query-accelerated SQL job. `LOT`: A MapReduce job. `PS`: A Parameter Server job for Platform of Artificial Intelligence (PAI). `AlgoTask`: A machine learning job.
inst_id	STRING	The instance ID.
status	STRING	The status of the job. Valid values: `Running` `Waiting`
owner_id	STRING	The ID of the Alibaba Cloud account that submitted the job.
owner_name	STRING	The name of the Alibaba Cloud account that submitted the job.
start_time	DATETIME	The start time of the job.
priority	BIGINT	The priority of the job.
signature	STRING	The signature of the job.
quota_name	STRING	The name of the computing quota.
cpu_usage	BIGINT	The current CPU usage, calculated as `cores × 100`.
mem_usage	BIGINT	The current memory usage, in megabytes (MB).
gpu_usage	BIGINT	The current GPU usage, calculated as `cards × 100`.
total_cpu_usage	BIGINT	The cumulative CPU usage, calculated as `(cores × 100) × seconds`.
total_mem_usage	BIGINT	The cumulative memory usage, in MB-seconds.
total_gpu_usage	BIGINT	The cumulative GPU usage, calculated as `(cards × 100) × seconds`.
cpu_min_ratio	BIGINT	The ratio of the job's current CPU usage to its queue's guaranteed resource level.
mem_min_ratio	BIGINT	The ratio of the job's current memory usage to its queue's guaranteed resource level.
gpu_min_ratio	BIGINT	The ratio of the job's current GPU usage to its queue's guaranteed resource level.
cpu_max_ratio	BIGINT	The ratio of the job's current CPU usage to its queue's maximum elastic resource level.
mem_max_ratio	BIGINT	The ratio of the job's current memory usage to its queue's maximum elastic resource level.
gpu_max_ratio	BIGINT	The ratio of the job's current GPU usage to its queue's maximum elastic resource level.
settings	STRING	Information passed from a higher-level scheduler or user, stored in JSON format. It may include fields such as `USERAGENT`, `BIZID`, `SKYNET_ID`, and `SKYNET_NODENAME`.
ext_platform_id	STRING	The ID of the upstream scheduling platform.
ext_node_id	STRING	The ID of the node in the upstream scheduler.
ext_bizdate	STRING	The business date of the job in the upstream scheduler.
ext_task_id	STRING	The ID of the instance in the upstream scheduler.
ext_dagtype	STRING	The running mode of the instance in the upstream scheduler.
ext_node_name	STRING	The name of the node in the upstream scheduler.
ext_node_onduty	STRING	The ID of the node's owner in the upstream scheduler.
ext_node_priority	BIGINT	The priority of the node in the upstream scheduler.
ext_node_cyctype	STRING	The scheduling cycle type of the node in the upstream scheduler.
ext_subtask_id	STRING	The subtask ID of the node in the upstream scheduler.
additional_info	STRING	A reserved field for additional information.

TASKS_HISTORY

Contains the history of completed jobs for each project. Data is retained for the last 14 days.

Parameter	Type	Description
task_catalog	STRING	The name of the project that contains the task.
task_name	STRING	The name of the task.
task_type	STRING	The type of the task. Possible values: `SQL`: An SQL task. `CUPID`: A Spark or Mars task. `SQLCost`: An SQL cost estimation task. `SQLRT`: An SQL task with query acceleration. `LOT`: A MapReduce task. `PS`: A Parameter Server task for PAI. `AlgoTask`: A machine learning task. Information about resource consumption and data scans is not available for this task type.
inst_id	STRING	The ID of the instance.
status	STRING	The status of the instance at the time of data collection. This is not a live status. Possible values: `Terminated`: The instance was completed. `Failed`: The instance failed. `Cancelled`: The instance was canceled.
owner_id	STRING	The ID of the Alibaba Cloud account that submitted the job.
owner_name	STRING	The name of the Alibaba Cloud account that submitted the job.
result	STRING	The error message for a failed job.
priority	BIGINT	The priority of the job.
submit_time	DATETIME	The time when the job was submitted and the instance was created.
start_time	DATETIME	The time when the task started. For an SQL task, this is the time when compilation began.
end_time	DATETIME	The time when the task ended.
input_records	BIGINT	The number of input records. Note This field is NULL if the SQL task hits the query acceleration cache.
output_records	BIGINT	The number of output records. Note This field is NULL if the SQL task hits the query acceleration cache.
input_bytes	BIGINT	The amount of input data from standard storage, in bytes. Note This field is NULL if the SQL task hits the query acceleration cache.
lowfrequency_storage_input_bytes	BIGINT	The amount of input data from infrequent access storage, in bytes. Note This field is NULL if the SQL task hits the query acceleration cache.
longterm_storage_input_bytes	BIGINT	The amount of input data from archive storage, in bytes. Note This field is NULL if the SQL task hits the query acceleration cache.
oss_input_bytes	BIGINT	The amount of input data from OSS external tables, in bytes. Note This field is NULL if the SQL task hits the query acceleration cache.
tablestore_input_bytes	BIGINT	The amount of input data from Tablestore external tables, in bytes. Note This field is NULL if the SQL task hits the query acceleration cache.
output_bytes	BIGINT	The amount of output data, in bytes. Note This field is NULL if the SQL task hits the query acceleration cache.
input_tables	STRING	A list of input tables. This field applies only to SQL tasks. Note This field is NULL if the SQL task hits the query acceleration cache.
output_tables	STRING	A list of output tables. This field applies only to SQL tasks. Note This field is NULL if the SQL task hits the query acceleration cache.
operation_text	STRING	The task statement. The maximum size is 256 KB.
signature	STRING	The task signature.
quota_name	STRING	The name of the compute quota.
complexity	DOUBLE	The complexity of the SQL task.
cost_cpu	DOUBLE	Job CPU consumption (A value of 100 represents `1 core × 1 s`. For example, if 10 cores run for 5 s, the cost_cpu is 10 × 100 × 5 = 5000).
cost_mem	DOUBLE	The memory consumption of the task, measured in MB-seconds.
cost_indicators	STRING	Job resource data for analysis and optimization.
settings	STRING	Data passed from an upper-level scheduling system or the user, stored as a JSON string. This field may include parameters such as `USERAGENT`, `BIZID`, `SKYNET_ID`, and `SKYNET_NODENAME`.
ext_platform_id	STRING	The ID of the upper-level scheduling platform. The client must provide this information when submitting the job. For more information, see Job identification conventions.
ext_node_id	STRING	The ID of the node from the upper-level scheduling system. The client must provide this information when submitting the job. For more information, see Job identification conventions.
ext_bizdate	STRING	The business date of the task from the upper-level scheduling system. The client must provide this information when submitting the job. For more information, see Job identification conventions.
ext_task_id	STRING	The instance ID of the task from the upper-level scheduling system. The client must provide this information when submitting the job. For more information, see Job identification conventions.
ext_dagtype	STRING	The running mode of the instance from the upper-level scheduling system. The client must provide this information when submitting the job. For more information, see Job identification conventions.
ext_node_name	STRING	The name of the node from the upper-level scheduling system. The client must provide this information when submitting the job. For more information, see Job identification conventions.
ext_node_onduty	STRING	The ID of the owner of the upper-level scheduling node. The client must provide this information when submitting the job. For more information, see Job identification conventions.
ext_node_priority	BIGINT	The priority of the upper-level scheduling node. The client must provide this information when submitting the job. For more information, see Job identification conventions.
ext_node_cyctype	STRING	A reserved field. The client must provide this information when submitting the job. For more information, see Job identification conventions.
ext_subtask_id	STRING	The ID of the sub-task from the upper-level scheduling node. The client must provide this information when submitting the job. For more information, see Job identification conventions.
ds	STRING	The archive date of the data.The data is archived based on the `start_time` of the job in the UTC+8 time zone.

TUNNELS_HISTORY

Contains the history of bulk upload and download operations via tunnels. Data is retained for 14 days.

Parameter	Type	Description
tunnel_catalog	STRING	The project that the target resource belongs to.
tunnel_schema	STRING	The schema that the target resource belongs to. This value is currently `NULL`.
session_id	STRING	The session ID.
operate_type	STRING	The operation type. Valid values: UPLOADLOG DOWNLOADLOG DOWNLOADINSTANCELOG STORAGEAPIREAD STORAGEAPIWRITE
tunnel_type	STRING	The tunnel type. Valid values: TUNNEL LOG TUNNEL INSTANCE LOG
request_id	STRING	The request ID.
object_type	STRING	The type of the target object. Valid values: table instance
object_name	STRING	The object's name, which is either a table name or an instance ID.
partition_spec	STRING	The partition specification for an operation on a partitioned table. For example, `time=20130222, loc=beijing`.
data_size	BIGINT	The size of the data, in bytes.
block_id	BIGINT	The ID of the block for a tunnel upload. This field is populated only when the operation type is `UPLOADLOG`.
offset	BIGINT	The 0-indexed starting record for a download.
length	BIGINT	The number of records uploaded or downloaded. For downloads, this value corresponds to the specified `length` parameter.
owner_id	STRING	The Alibaba Cloud account ID of the operator.
owner_name	STRING	The Alibaba Cloud account name of the operator.
start_time	DATETIME	The request start time.
end_time	DATETIME	The request end time.
client_ip	STRING	The client IP address used to make the tunnel request.
user_agent	STRING	The user agent string of the client that made the tunnel request. For example, this may include the Java version and operating system.
columns	STRING	The columns specified for a download operation.
quota_name	STRING	The tunnel quota group name.
app_tag	STRING	A user-defined tag.
ds	STRING	The data collection date. For example, `ds=20190101`. Data is archived based on the date of the request's `start_time` in the UTC+8 time zone.

UDF_PRIVILEGES

This view lists the UDF privileges in each project.

Column	Type	Value
udf_catalog	STRING	The name of the project containing the UDF.
udf_schema	STRING	The name of the schema containing the UDF.
udf_name	STRING	The UDF name.
user_catalog	STRING	The name of the grantee's project.
user_name	STRING	The name of the grantee.
user_id	STRING	The grantee ID.
grantor	STRING	The grantor. This is a reserved field.
privilege_type	STRING	The privilege type.

UDFs

Provides information about the UDFs in each project.

Parameter	Type	Value
udf_catalog	STRING	The name of the project that contains the UDF.
udf_schema	STRING	The schema that contains the UDF. The value is currently NULL.
udf_name	STRING	The name of the UDF.
owner_id	STRING	The ID of the UDF owner.
owner_name	STRING	The Alibaba Cloud account name of the UDF owner.
create_time	DATETIME	The creation time of the UDF.
last_modified_time	DATETIME	The last modified time of the UDF.

UDF_RESOURCES

This view lists the resource dependencies for User-Defined Functions (UDFs) in each project.

Parameter	Type	Value
udf_catalog	STRING	The name of the project that contains the UDF.
udf_schema	STRING	The schema that contains the UDF.
udf_name	STRING	The name of the UDF.
resource_catalog	STRING	The name of the project that contains the resource.
resource_schema	STRING	The schema that contains the resource.
resource_name	STRING	The name of the resource.

Users

The list of users.

Parameter	Type	Value
user_catalog	STRING	The name of the user's project. A value of `NULL` indicates a tenant-level user.
identity_provider	STRING	The account type. Valid values: `ALIYUN`: An Alibaba Cloud account. `RAM`: A RAM user. `RAMRole`: A RAM role.
user_name	STRING	The user name.
user_id	STRING	The user ID.
user_label	STRING	The user label.

User roles

Lists the roles assigned to each user.

Parameter	Type	Description
user_role_catalog	STRING	The name of the project where the role resides. A null value indicates a tenant-level role.
role_name	STRING	Name of the role.
user_name	STRING	Name of the user.
user_id	STRING	ID of the user.

Schemas

This view provides information about the schemas in each project.

Field	Type	Value
schema_catalog	STRING	The name of the project that contains the schema.
schema_name	STRING	The name of the schema.
owner_id	STRING	The Alibaba Cloud account ID of the schema owner.
owner_name	STRING	The Alibaba Cloud account name of the schema owner.
create_time	DATETIME	The time the schema was created.
last_modified_time	DATETIME	The time the schema was last modified.
schema_type	STRING	The type of the schema.
comment	STRING	The comment on the schema.

Quota usage

Provides a real-time snapshot of resource usage for subscription compute quotas. Use this view to monitor compute resource consumption.

Parameter	Type	Description
name	STRING	The name of the quota.
create_time	DATETIME	The quota's creation time.
last_modified_time	DATETIME	The quota's last modification time.
cpu_elastic_quota_max	BIGINT	The maximum elastic CPU quota. Unit: `core*100`.
cpu_elastic_quota_min	BIGINT	The minimum elastic CPU quota. Unit: `core*100`.
cpu_elastic_quota_used	BIGINT	The current usage of the elastic CPU quota. Unit: `core*100`.
mem_elastic_quota_max	BIGINT	The maximum elastic memory quota. Unit: `MB`.
mem_elastic_quota_min	BIGINT	The minimum elastic memory quota. Unit: `MB`.
mem_elastic_quota_used	BIGINT	The current usage of the elastic memory quota. Unit: `MB`.
cpu_adhoc_quota	BIGINT	The ad-hoc CPU quota. Unit: `core*100`.
cpu_adhoc_quota_used	BIGINT	The current usage of the ad-hoc CPU quota. Unit: `core*100`.
mem_adhoc_quota	BIGINT	The ad-hoc memory quota. Unit: `MB`.
mem_adhoc_quota_used	BIGINT	The current usage of the ad-hoc memory quota. Unit: `MB`.
cpu_quota_max	BIGINT	The maximum reserved CPU quota. Unit: `core*100`.
cpu_quota_min	BIGINT	The minimum reserved CPU quota. Unit: `core*100`.
cpu_quota_used	BIGINT	The current usage of the reserved CPU quota. Unit: `core*100`.
mem_quota_max	BIGINT	The maximum reserved memory quota. Unit: `MB`.
mem_quota_min	BIGINT	The minimum reserved memory quota. Unit: `MB`.
mem_quota_used	BIGINT	The current usage of the reserved memory quota. Unit: `MB`.
region	STRING	The resource's region.

Volumes

The VOLUMES view contains metadata about MaxCompute volumes. Data in this view has a latency of about three hours.

Parameter	Type	Description
volume_catalog	STRING	The name of the project where the volume resides.
volume_name	STRING	The name of the volume.
volume_type	STRING	The type of the volume. Valid values: INTERNAL EXTERNAL
owner_id	STRING	The ID of the volume owner.
owner_name	STRING	The name of the Alibaba Cloud account that owns the volume.
create_time	DATETIME	The creation time of the volume.
last_modified_time	DATETIME	The last modified time of the data in the volume.
location	STRING	The storage location of the volume.
comment	STRING	The comment on the volume.
storage_provider	STRING	The storage provider for the volume.
role_arn	STRING	The role ARN for accessing the volume's storage.
lifecycle	BIGINT	The lifecycle of the volume, in days.
options	STRING	The configuration options for the volume.

FOREIGN_SERVERS

This view contains metadata about foreign servers in MaxCompute. The data has a latency of approximately three hours.

Parameter	Type	Value
server_name	STRING	The name of the foreign server.
server_type	STRING	The type of the foreign server.
owner_id	STRING	The ID of the foreign server's owner.
owner_name	STRING	The name of the Alibaba Cloud account that owns the foreign server.
create_time	DATETIME	The foreign server's creation time.
last_modified_time	DATETIME	The time when the foreign server was last modified.
options	STRING	The foreign server's configuration options.