Introduction to the tenant-level metadata service Information Schema of MaxCompute - MaxCompute

This topic describes the features, scope, billing, metadata views, and RAM user authorization of the tenant-level Information Schema in MaxCompute.

Features

The Information Schema of MaxCompute provides project metadata and historical usage data. The tenant-level Information Schema is an upgraded version of the original Information Schema. It is based on the ANSI SQL-92 Information Schema but includes additional fields and views specific to MaxCompute. A project named SYSTEM_CATALOG is created for each Alibaba Cloud account and contains a built-in schema named INFORMATION_SCHEMA.

You can query the metadata and usage history of all projects for the current user by accessing the read-only views in this built-in schema. Metadata and job history data are stored only in SYSTEM_CATALOG.INFORMATION_SCHEMA.

Use the metadata views of Information Schema to browse and retrieve metadata.
Use the usage information views of Information Schema to analyze job execution details, such as resource consumption, runtime duration, and data processing volume. This helps you optimize jobs or plan resource capacity.

Different views have different data timeliness or default retention periods. Data that exceeds the retention period becomes inaccessible. To create snapshot backups 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 to back up the data for a longer period.

When you export data, explicitly select the field names of the view. Avoid using INSERT INTO SELECT * FROM information_schema.*** to prevent backup failures that may occur if new fields are added.

Scope

Information Schema provides metadata views for the current user. It does not support cross-metadata-center access. Metadata centers are categorized as follows:
- Regions in the Chinese mainland, including China (Shanghai), China (Hangzhou), China (Beijing), China (Shenzhen), China (Chengdu), China (Zhangjiakou), and China (Ulanqab), form one metadata center.
- The China (Hong Kong) region forms one metadata center.
- Each region outside China forms one metadata center.
- Alibaba Finance Cloud, including the China (Shanghai) Finance and China (Shenzhen) Finance regions, forms one metadata center.
- Alibaba Gov Cloud, including the China (Beijing) Gov region, forms one metadata center.
The built-in SYSTEM_CATALOG project is read-only. You must initiate a job in a project within the corresponding region to run queries. For query examples, see Query examples.
Currently, you can use SQL statements to access tables only from MaxCompute SQL Analysis, the latest version of the client, DataStudio in DataWorks, or SQL scheduling nodes in DataWorks.
The metadata system tables provide near-real-time views. For applications that require high data timeliness, you can use a software development kit (SDK) or the command-line interface (CLI) to directly obtain the metadata of a specific object.

Billing

Computing fees
- Pay-as-you-go compute resource projects: You are charged for queries on Information Schema views. The fees for an SQL query on a view are calculated based on the underlying SQL statement of the view.
  To improve query performance, Information Schema views are optimized using range-clustered tables to reduce the amount of input data.
  To minimize input data and reduce query fees when you query the TASKS_HISTORY and TUNNELS_HISTORY views, query the previous day's data after 06:00:00 each day and avoid querying data from the current day.
- Subscription compute resource projects: The compute units (CUs) that you purchased are consumed when you query Information Schema views.
Storage fees: You are not charged storage fees for Information Schema views.

List of metadata views

View	Description	Timeliness	Delay
CATALOGS	Lists projects.	Near Real-Time view	The data has a latency of about 3 hours compared with online data.
CATALOG_PRIVILEGES	The permissions at the project level.
COLUMNS	The information about table fields in each project.
COLUMN_LABEL_GRANTS	The label authorization information of table fields in each project.
COLUMN_LABELS	The label information at the table field level in each project.
COLUMN_PRIVILEGES	The permission information at the table field level in each project.
INSTALLED_PACKAGES	The information about installed packages in each project.
PACKAGE_PRIVILEGES	The authorization information of a package.
PACKAGE_OBJECTS	The object information in a package.
PARTITIONS	The information about table partitions in each project.
RESOURCES	The resource information in each project.
RESOURCE_PRIVILEGES	The permission information of resources in each project.
ROLES	The list of roles at the project and account levels.
TABLES	The table information in each project.
TABLE_LABEL_GRANTS	The label authorization information.
TABLE_LABELS	The label information of tables in each project.
TABLE_PRIVILEGES	The permission information of tables in each project.
UDF_PRIVILEGES	The UDF authorization information in each project.
UDFS	The UDF information in each project.
UDF_RESOURCES	The resource dependencies of UDFs in each project.
USERS	The user list.
USER_ROLES	The role information that a user has.
SCHEMAS	The schema information in a project.
TASKS	Real-time snapshots of running jobs, used for real-time job monitoring.		The data has a latency of seconds compared with online data. This view is in preview and has no SLA guarantee. It will be gradually opened to all users.
TASKS_HISTORY	The history of completed jobs in each project. This is a partitioned table that retains data from the last 14 days.		The data has a latency of about 3 hours compared with online data.
TUNNELS_HISTORY	The history of data uploaded and downloaded in batches through data tunnels. This is a partitioned table that retains data from the last 14 days.

Query examples

The following examples show how to query metadata information.

Example 1: Query the metadata of all tables in the destination project.

-- Initiate a query in a project under the tenant where you can run SQL statements.
use <project_name>;
set odps.namespace.schema=true;
select * from  SYSTEM_CATALOG.INFORMATION_SCHEMA.tables;

Example 2: Query the history of all jobs in the metadata center where the destination project is located, and filter the results by date.

-- Initiate a query in a project under the tenant where you can run SQL statements.
use <project_name>;
set odps.namespace.schema=true;
select * from  SYSTEM_CATALOG.INFORMATION_SCHEMA.tasks_history where ds='yyyymmdd' limit 100;

Grant permissions to a RAM user

The views in Information Schema contain all user data at the tenant level. By default, an Alibaba Cloud account can view this data. If a Resource Access Management (RAM) user needs to view the data, you must grant permissions to the RAM user.

Note

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

Log on to the MaxCompute console and select a region in the top-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, to create a role with permission to view all views in SYSTEM_CATALOG.INFORMATION_SCHEMA, set 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 more information about user management, see User planning and management.

CATALOGS

Lists projects.

Field	Type	Value
catalog_name	STRING	The project name.
status	STRING	Normal (Allowed), Freeze (Denied).
create_time	DATETIME	The creation time.
owner_id	STRING	The ID of the project owner.
owner_name	STRING	The name of the project owner.
settings	STRING	The project property settings.
region	STRING	The region where the project is located.

CATALOG_PRIVILEGES

Lists permissions at the project level, such as CreateInstance and ListTable.

Field	Type	Value
catalog_name	STRING	The project name.
user_catalog	STRING	The project to which the authorized account belongs.
user_name	STRING	The authorized account.
user_id	STRING	The ID of the authorized account.
grantor	STRING	The account that grants the permissions. This is a reserved field.
privilege_type	STRING	The permission type.

COLUMNS

Lists information about table fields in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table is located.
table_schema	STRING	The schema where the table is located. The current value is NULL.
table_name	STRING	The table name.
column_name	STRING	The column name.
ordinal_position	BIGINT	The ordinal number of the column.
column_default	STRING	The default value of the column.
is_nullable	BOOLEAN	Indicates whether NULL values are allowed.
data_type	STRING	The data type. For example, STRING or BIGINT.
column_comment	STRING	The column comment.
is_partition_key	BOOLEAN	Indicates whether the column is a partition key.

COLUMN_LABEL_GRANTS

Lists the label authorization information for table fields in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table is located.
table_schema	STRING	The schema where the table is located. The current value is NULL.
table_name	STRING	The table name.
column_name	STRING	The column name.
user_catalog	STRING	The name of the project where the user is located.
user_name	STRING	The username.
user_id	STRING	The ID of the user.
grantor	STRING	The account that grants the permissions. This is a reserved field.
label_level	STRING	The granted label level.
expired	DATETIME	The expiration time.

COLUMN_LABELS

Lists label information at the table field level in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table is located.
table_schema	STRING	The schema where the table is located. The current value is NULL.
table_name	STRING	The table name.
column_name	STRING	The column name.
label_type	STRING	The label type.
label_level	STRING	The label level.

COLUMN_PRIVILEGES

Lists permission information at the table field level in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table is located.
table_schema	STRING	The schema where the table is located. The current value is NULL.
table_name	STRING	The table name.
column_name	STRING	The column name.
user_catalog	STRING	The name of the project where the user is located.
user_name	STRING	The username.
user_id	STRING	The ID of the user.
grantor	STRING	The account that grants the permissions. This is a reserved field.
privilege_type	STRING	The permission type.

INSTALLED_PACKAGES

Lists information about installed packages in each project.

Field	Type	Value
installed_package_catalog	STRING	The name of the project where the package is installed.
package_catalog	STRING	The project to which the package belongs.
package_name	STRING	The package name.
installed_time	STRING	The installation time.
allowed_label	STRING	The settings for the shared label.

PACKAGE_PRIVILEGES

Lists the authorization information of packages.

Field	Type	Value
package_catalog	STRING	The project to which the package belongs.
package_name	STRING	The package name.
user_catalog	STRING	The project where the authorized user is located.
user_name	STRING	The name of the authorized user.
user_id	STRING	The ID of the authorized user.
grantor	STRING	The account that grants the permissions. This is a reserved field.
privilege_type	STRING	The permission type.

PACKAGE_OBJECTS

Lists object information in packages.

Field	Type	Value
package_catalog	STRING	The project to which the package belongs.
package_name	STRING	The package name.
object_schema	STRING	The schema to which the object in the package belongs. The current value is NULL.
object_type	STRING	The type of the package object.
object_name	STRING	The name of the package object.
column_name	STRING	The table column name. This is valid only if object_type is set to table.
allowed_privilege	STRING	The settings for the shared permission.
allowed_label	STRING	The settings for the shared label.

PARTITIONS

Lists information about table partitions in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table is located.
table_schema	STRING	The schema where the table is located. The current value is NULL.
table_name	STRING	The table name.
partition_name	STRING	The partition name.
create_time	DATETIME	The time when the partition was created.
last_modified_time	DATETIME	The time when the partition was last updated.
last_access_time	DATETIME	The time when the partition was last accessed. This time is for reference only and may have a difference of up to 24 hours from the actual last access time. Note Data collection for this field has been progressively upgraded since July 2023. The last_access_time cannot be collected for partitions that have not been accessed since the upgrade or have been accessed through ALGO jobs or Hologres direct reads.
data_length	BIGINT	The data size of the partition, in bytes.
is_archived	BOOLEAN	A reserved field that has no meaning.
is_exstore	BOOLEAN	A reserved field that has no meaning.
storage_tier	STRING	The tiered storage identifier. Valid values: standard: Standard storage. lowfrequency: IA storage. longterm: Long-Term storage.
cluster_type	STRING	The bucketing (clustering) type of the MaxCompute table. Valid values: HASH RANGE
number_buckets	BIGINT	An optional field. The number of buckets in the clustered table. A value of 0 indicates that the number is dynamically determined at runtime.
lifecycle_enabled	BOOLEAN	Indicates whether the partition lifecycle is enabled.

RESOURCES

Lists resource information in each project.

Field	Type	Value
resource_catalog	STRING	The name of the project where the resource is located.
resource_schema	STRING	The schema where the resource is located. The current value is NULL.
resource_name	STRING	The resource name.
resource_type	STRING	The resource type. Valid values: archive py jar table
owner_id	STRING	The ID of the resource owner.
owner_name	STRING	The Alibaba Cloud account name of the resource owner.
create_time	DATETIME	The time when the resource was created.
last_modified_time	DATETIME	The time when the resource was last updated.
size	BIGINT	The storage space occupied by the resource, in bytes.
comment	STRING	The comment on the resource.
is_temp_resource	BOOLEAN	Indicates whether the resource is a temporary resource.

RESOURCE_PRIVILEGES

Lists permission information for resources in each project.

Field	Type	Value
resource_catalog	STRING	The name of the project where the resource is located.
resource_schema	STRING	The schema where the resource is located. The current value is NULL.
resource_name	STRING	The resource name.
user_catalog	STRING	The project of the authorized account.
user_name	STRING	The authorized account.
user_id	STRING	The ID of the authorized account.
grantor	STRING	The account that grants the permissions. This is a reserved field.
privilege_type	STRING	The permission type.

ROLES

Lists roles at the project and account levels.

Field	Type	Value
role_catalog	STRING	The name of the project where the role is located. The value is NULL for a tenant role.
role_name	STRING	The role name.
role_label	STRING	The role label.
comment	STRING	The comment on the role.

TABLES

Lists table information in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table is located.
table_schema	STRING	The schema where the table is located. The current value is NULL.
table_name	STRING	The table name.
table_type	STRING	The table type. Valid values: MANAGED_TABLE VIRTUAL_VIEW EXTERNAL_TABLE MATERIALIZED_VIEW
is_partitioned	BOOLEAN	Indicates whether the table is a partitioned table.
owner_id	STRING	The ID of the table owner.
owner_name	STRING	The Alibaba Cloud account name of the table owner.
create_time	STRING	The time when the table was created.
last_modified_time	STRING	The time when the table data was last updated.
last_access_time	STRING	The time when the table was last accessed. This time is for reference only and may have a difference of up to 24 hours from the actual last access time. If the table is a partitioned table, this value is empty. You can view the last access time of each partition of the table in the PARTITIONS view. Note Data collection for this field has been progressively upgraded since July 2023. The last_access_time cannot be collected for tables that have not been accessed since the upgrade or have been accessed through ALGO jobs or Hologres direct reads.
data_length	BIGINT	The data volume, in bytes. If the table is a non-partitioned table, the value is the data volume of the table. If the table is a partitioned table, the system does not calculate the data volume of the table, and the value is NULL. The PARTITIONS view contains the data volume of each partition of a partitioned table.
table_comment	STRING	The comment on the table.
lifecycle	BIGINT	The lifecycle, in days.
lifecycle_enabled	BOOLEAN	Indicates whether lifecycle-based data revocation is enabled.
is_archived	BOOLEAN	A reserved field that has no meaning.
table_exstore_type	STRING	An optional field. It indicates whether the current table is a logical table or a physical table of an extreme storage table. Valid values: EXSTORE_TABLE_VIRTUAL EXSTORE_TABLE_PHYSICAL
storage_tier	STRING	The tiered storage identifier. Valid values: standard: Standard storage. lowfrequency: IA storage. longterm: Long-Term storage.
cluster_type	STRING	The bucketing (clustering) type of the MaxCompute table. Valid values: HASH RANGE
number_buckets	BIGINT	The number of buckets in the clustered table. A value of 0 indicates that the number is dynamically determined at runtime.
view_original_text	STRING	The view definition of a table of the VIRTUAL_VIEW type.

TABLE_LABEL_GRANTS

Lists label authorization information for tables.

Field	Type	Value
table_catalog	STRING	The name of the project where the table is located.
table_schema	STRING	The schema where the table is located. The current value is NULL.
table_name	STRING	The table name.
user_catalog	STRING	The project to which the authorized account belongs.
user_name	STRING	The authorized account.
user_id	STRING	The ID of the authorized account.
grantor	STRING	The account that grants the permissions. This is a reserved field.
label_level	STRING	The label level.
expired	DATETIME	The expiration time.

TABLE_LABELS

Lists label information for tables in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table is located.
table_schema	STRING	The schema where the table is located. The current value is NULL.
table_name	STRING	The table name.
label_type	STRING	The label type.
label_level	BIGINT	The label level.

TABLE_PRIVILEGES

Lists permission information for tables in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table is located.
table_schema	STRING	The schema where the table is located. The current value is NULL.
table_name	STRING	The table name.
user_catalog	STRING	The project of the authorized account.
user_name	STRING	The authorized account.
user_id	STRING	The ID of the authorized account.
grantor	STRING	The account that grants the permissions. This is a reserved field.
privilege_type	STRING	The permission type.

TASKS

Provides real-time snapshots of running jobs for real-time job monitoring.

Field	Type	Value
task_catalog	STRING	The name of the project where the task is located.
task_name	STRING	The job name.
task_type	STRING	The job type. 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 of PAI. AlgoTask: a machine learning job.
inst_id	STRING	The instance ID.
status	STRING	The job status. Valid values: Running Waiting
owner_id	STRING	The Alibaba Cloud account ID of the job submitter.
owner_name	STRING	The Alibaba Cloud account name of the job submitter.
start_time	DATETIME	The time when the job started.
priority	BIGINT	The job priority.
signature	STRING	The job signature.
quota_name	STRING	The name of the computing quota.
cpu_usage	BIGINT	The current CPU usage. Value: core × 100.
mem_usage	BIGINT	The current memory usage, in MB.
gpu_usage	BIGINT	The current GPU usage. Value: card × 100.
total_cpu_usage	BIGINT	The cumulative CPU usage. Value: core × 100 × seconds.
total_mem_usage	BIGINT	The cumulative memory usage. Value: MB × seconds.
total_gpu_usage	BIGINT	The cumulative GPU usage. Value: card × 100 × seconds.
cpu_min_ratio	BIGINT	The ratio of the current CPU usage of the job to the guaranteed CPU usage of the queue.
mem_min_ratio	BIGINT	The ratio of the current memory usage of the job to the guaranteed memory usage of the queue.
gpu_min_ratio	BIGINT	The ratio of the current GPU usage of the job to the guaranteed GPU usage of the queue.
cpu_max_ratio	BIGINT	The ratio of the current CPU usage of the job to the maximum elastic CPU usage of the queue.
mem_max_ratio	BIGINT	The ratio of the current memory usage of the job to the maximum elastic memory usage of the queue.
gpu_max_ratio	BIGINT	The ratio of the current GPU usage of the job to the maximum elastic GPU usage of the queue.
settings	STRING	Information passed from the upper-layer scheduler or user, stored in JSON format. It includes fields such as USERAGENT, BIZID, SKYNET_ID, and SKYNET_NODENAME.
additional_info	STRING	A reserved field for additional information.

TASKS_HISTORY

Lists the history of completed jobs in each project. Data from the last 14 days is retained.

Field	Type	Value
task_catalog	STRING	The name of the project where the task is located.
task_name	STRING	The job name.
task_type	STRING	The job type. 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 of PAI. AlgoTask: a machine learning job (no information about resource consumption or data scanning).
inst_id	STRING	The job instance ID.
status	STRING	The running status at the moment of data collection (not the real-time status). Valid values include the following: Terminated: The job has finished. Failed: The job failed. Cancelled: The job was canceled.
owner_id	STRING	The Alibaba Cloud account ID of the job submitter.
owner_name	STRING	The Alibaba Cloud account name of the job submitter.
result	STRING	The error message for the job execution.
priority	BIGINT	The job priority.
submit_time	DATETIME	The time when the job was submitted, which is when the instance was generated.
start_time	DATETIME	The time when the job started, such as when an SQL job began compilation.
end_time	DATETIME	The time when the job ended.
input_records	BIGINT	The number of input records. Note If an SQL job hits the query acceleration caching mechanism, the value of this parameter is NULL.
output_records	BIGINT	The number of output records. Note If an SQL job hits the query acceleration caching mechanism, this value is NULL.
input_bytes	BIGINT	The volume of input data from Standard storage, in bytes. Note When an SQL job hits the query acceleration caching mechanism, this information is NULL.
lowfrequency_storage_input_bytes	BIGINT	The volume of input data from IA storage, in bytes. Note If an SQL job hits the query acceleration caching mechanism, the value of this parameter is NULL.
longterm_storage_input_bytes	BIGINT	The volume of input data from Long-Term storage, in bytes. Note If an SQL job hits the query acceleration caching mechanism, the value of this parameter is NULL.
oss_input_bytes	BIGINT	The volume of input data from an OSS external table, in bytes. Note If an SQL job hits the query acceleration caching mechanism, the value of this parameter is NULL.
tablestore_input_bytes	BIGINT	The volume of input data from a Tablestore external table, in bytes. Note If an SQL job hits the query acceleration caching mechanism, the value of this parameter is NULL.
output_bytes	BIGINT	The volume of output data, in bytes. Note When an SQL job hits the query acceleration caching mechanism, this information is NULL.
input_tables	STRING	A list of input tables. This applies only to SQL jobs. Note When an SQL job hits the query acceleration caching mechanism, this information is NULL.
output_tables	STRING	A list of output tables. This applies only to SQL jobs. Note When an SQL job hits the caching mechanism for query acceleration, this information is NULL.
operation_text	STRING	The job statement. The maximum size is 256 KB.
signature	STRING	The job signature.
quota_name	STRING	The name of the computing quota.
complexity	DOUBLE	The complexity of the SQL job.
cost_cpu	DOUBLE	The CPU consumption of the job. 100 indicates `1 core × 1 s`. For example, if 10 cores run for 5s, cost_cpu is 10 × 100 × 5 = 5000.
cost_mem	DOUBLE	The memory consumption of the job. Value: MB × seconds.
settings	STRING	Information passed from the upper-layer scheduler or user, stored in JSON format. It includes fields such as USERAGENT, BIZID, SKYNET_ID, and SKYNET_NODENAME.
ext_platform_id	STRING	The ID of the upper-layer task scheduling platform.
ext_node_id	STRING	The ID of the upper-layer scheduling node.
ext_bizdate	STRING	The data timestamp of the upper-layer scheduling task.
ext_task_id	STRING	The instance ID of the upper-layer scheduling node.
ext_dagtype	STRING	The running mode of the upper-layer scheduling instance.
ext_node_name	STRING	The name of the upper-layer scheduling node.
ext_node_onduty	STRING	The ID of the owner of the upper-layer scheduling node.
ext_node_priority	BIGINT	The priority of the upper-layer scheduling node.
ext_node_cyctype	STRING	A reserved field that has no meaning.
ext_subtask_id	STRING	The subtask ID of the upper-layer scheduling node.
ds	STRING	The date when the data is archived.Data is archived based on the `start_time` of the job in the UTC+8 time zone.

TUNNELS_HISTORY

Lists the history of data uploaded and downloaded in batches through data tunnels. Data from the last 14 days is retained.

Field	Type	Value
tunnel_catalog	STRING	The project to which the operated resource belongs.
tunnel_schema	STRING	The schema to which the operated resource belongs. The current value is NULL.
session_id	STRING	The session ID.
operate_type	STRING	The operation type. Valid values: UPLOADLOG DOWNLOADLOG DOWNLOADINSTANCELOG STORAGEAPIREAD STORAGEAPIWRITE
tunnel_type	STRING	The channel type. Valid values: TUNNEL LOG TUNNEL INSTANCE LOG
request_id	STRING	The request ID.
object_type	STRING	The type of the operated object. Valid values: TABLE INSTANCE
object_name	STRING	The name of the operated object, which can be a table name or an instance ID.
partition_spec	STRING	The partition of the partitioned table to or from which data is uploaded or downloaded. For example, `time=20130222, loc=beijing`.
data_size	BIGINT	The data size, in bytes.
block_id	BIGINT	The block number of the tunnel upload. This is valid only when the operation type is UPLOADLOG. Otherwise, it is empty.
offset	BIGINT	The starting offset for the download, indicating the record from which to start (starting from 0).
length	BIGINT	The number of records downloaded or uploaded this time. The number of downloaded records is the specified length value.
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 time when the request is initiated.
end_time	DATETIME	The time when the request ended.
client_ip	STRING	The IP address of the client that initiated the tunnel request.
user_agent	STRING	The User Agent, which contains information about the client that initiated the tunnel request, such as the Java version and operating system.
columns	STRING	The collection of columns specified for a tunnel download.
quota_name	STRING	The name of the Tunnel Quota group.
ds	STRING	The data collection date, for example, `ds=20190101`.Data is archived based on the `start_time` of the request in the UTC+8 time zone.

UDF_PRIVILEGES

Lists UDF authorization information in each project.

Field	Type	Value
udf_catalog	STRING	The name of the project where the UDF is located.
udf_schema	STRING	The schema where the UDF is located. The current value is NULL.
udf_name	STRING	The UDF name.
user_catalog	STRING	The project of the authorized account.
user_name	STRING	The authorized account.
user_id	STRING	The ID of the authorized account.
grantor	STRING	The account that grants the permissions. This is a reserved field.
privilege_type	STRING	The permission type.

UDFS

Lists UDF information in each project.

Field	Type	Value
udf_catalog	STRING	The name of the project where the UDF is located.
udf_schema	STRING	The schema where the UDF is located. The current value is NULL.
udf_name	STRING	The UDF name.
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.
last_modified_time	DATETIME	The last update time.

UDF_RESOURCES

Lists the resource dependencies of UDFs in each project.

Field	Type	Value
udf_catalog	STRING	The name of the project where the UDF is located.
udf_schema	STRING	The schema where the UDF is located. The current value is NULL.
udf_name	STRING	The UDF name.
resource_catalog	STRING	The project where the resource is located.
resource_schema	STRING	The schema where the resource is located.
resource_name	STRING	The resource name.

USERS

Lists users.

Field	Type	Value
user_catalog	STRING	The name of the project where the user is located. A NULL value indicates a tenant-level user.
identity_provider	STRING	The account type. Valid values: ALIYUN RAM RAMRole
user_name	STRING	The username.
user_id	STRING	The user ID.
user_label	STRING	The user label.

USER_ROLES

Lists the roles that are assigned to users.

Field	Type	Value
user_role_catalog	STRING	The name of the project where the role is located. A NULL value indicates a tenant-level role.
role_name	STRING	The role name.
user_name	STRING	The username.
user_id	STRING	The user ID.

SCHEMAS

Lists schema information in each project.

Field	Type	Value
schema_catalog	STRING	The name of the project where the schema is located.
schema_name	STRING	The schema name.
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 when the schema was created.
last_modified_time	DATETIME	The time when the schema was last updated.
schema_type	STRING	The schema type.
comment	STRING	The comment on the schema.

QUOTA_USAGE

Provides real-time snapshots of resource usage for subscription computing quotas. This view is used for real-time monitoring of compute resource consumption.

Field	Type	Value
name	STRING	The quota name.
create_time	DATETIME	The time when the quota was created.
last_modified_time	DATETIME	The time when the quota was last updated.
cpu_elastic_quota_max	BIGINT	The upper limit of the non-reserved CPU quota. Unit: `core*100`.
cpu_elastic_quota_min	BIGINT	The lower limit of the non-reserved CPU quota. Unit: `core*100`.
cpu_elastic_quota_used	BIGINT	The usage of the non-reserved CPU quota. Unit: `core*100`.
mem_elastic_quota_max	BIGINT	The upper limit of the non-reserved memory quota. Unit: `MB`.
mem_elastic_quota_min	BIGINT	The lower limit of the non-reserved memory quota. Unit: `MB`.
mem_elastic_quota_used	BIGINT	The usage of the non-reserved memory quota. Unit: `MB`.
cpu_adhoc_quota	BIGINT	The elastically reserved CPU quota. Unit: `core*100`.
cpu_adhoc_quota_used	BIGINT	The usage of the elastically reserved CPU quota. Unit: `core*100`.
mem_adhoc_quota	BIGINT	The elastically reserved memory quota. Unit: `MB`.
mem_adhoc_quota_used	BIGINT	The usage of the elastically reserved memory quota. Unit: `MB`.
cpu_quota_max	BIGINT	The upper limit of the reserved CPU quota. Unit: `core*100`.
cpu_quota_min	BIGINT	The lower limit of the reserved CPU quota. Unit: `core*100`.
cpu_quota_used	BIGINT	The usage of the reserved CPU quota. Unit: `core*100`.
mem_quota_max	BIGINT	The upper limit of the reserved memory quota. Unit: `MB`.
mem_quota_min	BIGINT	The lower limit of the reserved memory quota. Unit: `MB`.
mem_quota_used	BIGINT	The usage of the reserved memory quota. Unit: `MB`.
region	STRING	The region where the resource is located.

VOLUMES

Provides the MaxCompute Volume view. The data latency is about 3 hours.

Field	Type	Value
volume_catalog	STRING	The name of the project where the volume is located.
volume_name	STRING	The volume name.
volume_type	STRING	The volume type. Valid values: INTERNAL EXTERNAL
owner_id	STRING	The ID of the volume owner.
owner_name	STRING	The Alibaba Cloud account name of the volume owner.
create_time	DATETIME	The time when the volume was created.
last_modified_time	DATETIME	The time when the volume data was last updated.
location	STRING	The storage path of the volume.
comment	STRING	The comment on the volume.
storage_provider	STRING	The storage engine of the volume.
role_arn	STRING	The Alibaba Cloud Resource Name (ARN) of the role for volume storage access.
lifecycle	BIGINT	The lifecycle of the volume, in days.
options	STRING	The option parameters of the volume.

FOREIGN_SERVERS

Provides the MaxCompute ForeignServer view. The data latency is about 3 hours.

Field	Type	Value
server_name	STRING	The server name.
server_type	STRING	The server type.
owner_id	STRING	The ID of the server owner.
owner_name	STRING	The Alibaba Cloud account name of the server owner.
create_time	DATETIME	The time when the server was created.
last_modified_time	DATETIME	The time when the data was last updated.
options	STRING	The option parameters of the server.