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

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

Introduction

The MaxCompute Information Schema provides project metadata and usage history. The tenant-level Information Schema is an upgraded version of the original Information Schema. It builds on the ANSI SQL-92 Information Schema and adds views and fields specific to MaxCompute. Under each Alibaba Cloud account, a project named SYSTEM_CATALOG is created. This project 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 that belong to the current user. Metadata and job history data are stored only in SYSTEM_CATALOG.INFORMATION_SCHEMA.

You can use the Information Schema metadata views to browse and retrieve metadata.
You can use the Information Schema usage information views to analyze job performance metrics, such as resource consumption, runtime duration, and data processing volume. This helps you optimize jobs or plan resource capacity.

Different views have different data latency and default retention periods. Data is inaccessible after its retention period expires. 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.

When you export data, explicitly select the field names from the view. Avoid using statements such as INSERT INTO SELECT * FROM information_schema.*** to prevent backup failures 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 (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 and Shenzhen Finance) forms one Metadata Center.
- Alibaba Gov Cloud (Beijing) forms one Metadata Center.
The built-in SYSTEM_CATALOG project is read-only. To query it, you can run jobs from a project in the corresponding region. For query examples, see Query examples.
Currently, SQL access to the tables is supported only from the MaxCompute SQL analysis feature, the latest client version, DataStudio in DataWorks, and SQL scheduling nodes.
The metadata system tables currently provide near-real-time views. For applications that require high data freshness, use the software development kit (SDK) or command-line interface (CLI) to directly obtain the metadata of specific objects.

Billing

Compute fees
- Pay-as-you-go compute resource projects: Queries on Information Schema views incur query fees. The fees for an SQL query on a view are calculated based on the underlying SQL statement that the view expands to.
  To improve query performance, Information Schema views are optimized with underlying Range clustered tables to reduce the amount of data scanned.
  If you query the TASKS_HISTORY and TUNNELS_HISTORY views, query the previous day's data after 06:00:00 each day and avoid querying the current day's data. This minimizes the amount of scanned data and reduces query fees.
- Subscription compute resource projects: Queries on Information Schema views consume the Compute Units (CUs) that you purchased.
Storage fees: Storage fees are not charged for Information Schema views.

List of metadata views

View	View description	Timeliness	Latency description
CATALOGS	List of projects.	Near-real-time view	The data has a latency of about 3 hours compared with online data.
CATALOG_PRIVILEGES	Project-level permissions.
COLUMNS	Source table columns in each project.
COLUMN_LABEL_GRANTS	Label authorization information for table columns in each project.
COLUMN_LABELS	Column-level label information for tables in each project.
COLUMN_PRIVILEGES	Column-level permission information for tables in each project.
INSTALLED_PACKAGES	Information about installed packages in each project.
PACKAGE_PRIVILEGES	Authorization information for packages.
PACKAGE_OBJECTS	Object information in packages.
PARTITIONS	Table partition information in each project.
RESOURCES	Resource information in each project.
RESOURCE_PRIVILEGES	Permission information for resources in each project.
ROLES	List of project-level and account-level roles.
TABLES	Table information 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 in each project.
UDFS	UDF information in each project.
UDF_RESOURCES	Resource dependencies of UDFs in each project.
USERS	User List.
USER_ROLES	Information about roles that users have.
SCHEMAS	Schema information in a project.
TASKS	A real-time snapshot of running jobs, used for real-time monitoring.		The data has a latency of seconds compared with online data. This feature is in preview and is not covered by a Service-Level Agreement (SLA). It will be gradually rolled out.
TASKS_HISTORY	The history of completed jobs in each project. This is a partitioned table. Data from the last 14 days is retained.		The data has a latency of about 3 hours compared with online data.
TUNNELS_HISTORY	The history of batch uploads and downloads through the data tunnel. This is a partitioned table. Data from the last 14 days is retained.

Query examples

The following are examples of how to query metadata information.

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

-- Run the query from a project under the tenant where you can execute 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 target project resides, and filter the results by date.

-- Run the query from a project under the tenant where you can execute SQL statements.
USE <project_name>;
SET odps.namespace.schema=true;
SELECT * FROM SYSTEM_CATALOG.INFORMATION_SCHEMA.tasks_history where ds='yyyymmdd' limit 100;

Grant access to RAM users

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

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 that can view all views in 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 more information about user management, see User planning and management.

CATALOGS

Lists all projects.

Field	Type	Value
catalog_name	STRING	The project name.
status	STRING	Allowed or Denied.
create_time	DATETIME	The time when the project was created.
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 resides.

CATALOG_PRIVILEGES

Lists project-level permissions, 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 the columns of source tables in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table resides.
table_schema	STRING	The schema where the table resides. This field is currently 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 the column can be NULL.
data_type	STRING	The data type, such as 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 columns in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table resides.
table_schema	STRING	The schema where the table resides. This field is currently NULL.
table_name	STRING	The table name.
column_name	STRING	The column name.
user_catalog	STRING	The name of the project where the user resides.
user_name	STRING	The username.
user_id	STRING	The user ID.
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 the column-level label information for tables in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table resides.
table_schema	STRING	The schema where the table resides. This field is currently 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 the column-level permission information for tables in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table resides.
table_schema	STRING	The schema where the table resides. This field is currently NULL.
table_name	STRING	The table name.
column_name	STRING	The column name.
user_catalog	STRING	The name of the project where the user resides.
user_name	STRING	The username.
user_id	STRING	The user ID.
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 shared label settings.

PACKAGE_PRIVILEGES

Lists the authorization information for 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 resides.
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 within 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. This field is currently 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 field is valid only when object_type is set to table.
allowed_privilege	STRING	The shared permission settings.
allowed_label	STRING	The shared label settings.

PARTITIONS

Lists table partition information in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table resides.
table_schema	STRING	The schema where the table resides. This field is currently 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 last time when the partition was updated.
last_access_time	DATETIME	The last time when the partition was accessed. This is an approximate value and may differ from the actual last access time by up to 24 hours. Note This data has been collected 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	This is a reserved field and has no meaning.
is_exstore	BOOLEAN	This is a reserved field and has no meaning.
storage_tier	STRING	The tiered storage identifier. Valid values: standard: Standard lowfrequency: IA storage class longterm: long-term storage.
cluster_type	STRING	The clustering type of the MaxCompute table. Valid values: HASH RANGE
number_buckets	BIGINT	An optional field that specifies the number of buckets in a clustered table. A value of 0 indicates that the number is dynamically determined during job execution.
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 resides.
resource_schema	STRING	The schema where the resource resides. This field is currently 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 last time when the resource was updated.
size	BIGINT	The storage space occupied by the resource in bytes.
comment	STRING	The resource comment.
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 resides.
resource_schema	STRING	The schema where the resource resides. This field is currently 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 project-level and account-level roles.

Field	Type	Value
role_catalog	STRING	The name of the project where the role resides. This field is NULL for a tenant role.
role_name	STRING	The role name.
role_label	STRING	The role label.
comment	STRING	The role comment.

TABLES

Lists table information in each project.

Field	Type	Value
table_catalog	STRING	The name of the project where the table resides.
table_schema	STRING	The schema where the table resides. This field is currently 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 last time when the table data was updated.
last_access_time	STRING	The last time when the table was accessed. This is an approximate value and may differ from the actual last access time by up to 24 hours. If the table is a partitioned table, this value is empty. You can view the last access time of each partition in the PARTITIONS view. Note This data has been collected 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, this field indicates 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 in the partitioned table.
table_comment	STRING	The table comment.
lifecycle	BIGINT	The lifecycle in days.
lifecycle_enabled	BOOLEAN	Indicates whether lifecycle-based data retention is enabled.
is_archived	BOOLEAN	This is a reserved field and 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 lowfrequency: IA storage class longterm: For long-term storage.
cluster_type	STRING	The clustering type of the MaxCompute table. Valid values: HASH RANGE
number_buckets	BIGINT	The number of buckets in a clustered table. A value of 0 indicates that the number is dynamically determined during job execution.
view_original_text	STRING	The view definition for a VIRTUAL_VIEW table.

TABLE_LABEL_GRANTS

Label: authorization information.

Field	Type	Value
table_catalog	STRING	The name of the project where the table resides.
table_schema	STRING	The schema where the table resides. This field is currently 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 resides.
table_schema	STRING	The schema where the table resides. This field is currently 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 resides.
table_schema	STRING	The schema where the table resides. This field is currently 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 a real-time snapshot of running jobs, used for real-time monitoring.

Field	Type	Value
task_catalog	STRING	The name of the project where the job resides.
task_name	STRING	The job name.
task_type	STRING	The job type. Valid values: SQL: SQL job. CUPID: Spark or Mars job. SQLCost: SQL cost estimation job. SQLRT: query acceleration SQL job. LOT: MapReduce job. PS: Parameter Server job of PAI. AlgoTask: 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 user who submitted the job.
owner_name	STRING	The Alibaba Cloud account name of the user who submitted the job.
start_time	DATETIME	The time when the job started.
priority	BIGINT	The job priority.
signature	STRING	Job signature
quota_name	STRING	The name of the compute quota.
cpu_usage	BIGINT	The current CPU usage. The value is core × 100.
mem_usage	BIGINT	The current memory usage in MB.
gpu_usage	BIGINT	The current GPU usage. The value is card × 100.
total_cpu_usage	BIGINT	The cumulative CPU usage. The value is core × 100 × seconds.
total_mem_usage	BIGINT	The cumulative memory usage. The value is MB × seconds.
total_gpu_usage	BIGINT	The cumulative GPU usage. The value is card × 100 × seconds.
cpu_min_ratio	BIGINT	The ratio of the current CPU usage of the job to the guaranteed resource level of the queue.
mem_min_ratio	BIGINT	The ratio of the current memory usage of the job to the guaranteed resource level of the queue.
gpu_min_ratio	BIGINT	The ratio of the current GPU usage of the job to the guaranteed resource level of the queue.
cpu_max_ratio	BIGINT	The ratio of the current CPU usage of the job to the maximum elastic resource level of the queue.
mem_max_ratio	BIGINT	The ratio of the current memory usage of the job to the maximum elastic resource level of the queue.
gpu_max_ratio	BIGINT	The ratio of the current GPU usage of the job to the maximum elastic resource level of the queue.
settings	STRING	Information passed by the upper-level 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

Provides 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 job resides.
task_name	STRING	The job name.
task_type	STRING	The job type. Valid values: SQL: SQL job. CUPID: Spark or Mars job. SQLCost: SQL cost estimation job. SQLRT: query acceleration SQL job. LOT: MapReduce job. PS: Parameter Server job of PAI. AlgoTask: 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 ingestion (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 user who submitted the job.
owner_name	STRING	The Alibaba Cloud account name of the user who submitted the job.
result	STRING	The job execution error message.
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 statement began to compile.
end_time	DATETIME	The time when the job ended.
input_records	BIGINT	The number of input records. Note When an SQL job hits the query acceleration caching mechanism, this information is NULL.
output_records	BIGINT	The number of output records. Note When an SQL job hits the query acceleration caching mechanism, this information 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 When an SQL job hits the query acceleration caching mechanism, this information is NULL.
longterm_storage_input_bytes	BIGINT	Specifies the data volume for long-term storage, in bytes. Note When an SQL job hits the query acceleration caching mechanism, this information is NULL.
oss_input_bytes	BIGINT	The volume of input data from an OSS external table in bytes. Note When an SQL job hits the query acceleration caching mechanism, this information is NULL.
tablestore_input_bytes	BIGINT	The volume of input data from a Tablestore external table in bytes. Note When an SQL job hits the query acceleration caching mechanism, this information is NULL.
output_bytes	BIGINT	The volume of output data in bytes. Note When a SQL job hits the query acceleration caching mechanism, this information is NULL.
input_tables	STRING	The list of input tables. This field is valid only for SQL jobs. Note When an SQL job hits the query acceleration caching mechanism, this information is NULL.
output_tables	STRING	The list of output tables. This field is valid only for 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	Job signature
quota_name	STRING	The name of the compute quota.
complexity	DOUBLE	The complexity of the SQL job.
cost_cpu	DOUBLE	The CPU consumption of the job. A value of 100 indicates `1 core × 1 s`. For example, if a job runs on 10 cores for 5 seconds, the cost_cpu is 10 × 100 × 5 = 5,000.
cost_mem	DOUBLE	The memory consumption of the job. The value is MB × seconds.
settings	STRING	Information passed by the upper-level 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-level job scheduling platform. A requester VPC must pass information when initiating a job. For the required conventions, see Job Common Identity Convention.
ext_node_id	STRING	The ID of the upper-level scheduling node. The requester must provide information when initiating a job. For the conventions for passing information, see Job Common Identity Convention.
ext_bizdate	STRING	The data timestamp of the upper-level scheduling job. The requester VPC must pass information when it initiates a job. For information about the required conventions, see General Job Identity Convention.
ext_task_id	STRING	The instance ID of the upper-level scheduling node. When initiating a job from the requester VPC, you must provide the information as specified in General job identity convention.
ext_dagtype	STRING	The running mode of the upper-level scheduling instance. The requester VPC must pass this information when it initiates a job. For the required conventions, see Common Job Identifier Conventions.
ext_node_name	STRING	The name of the upper-level scheduling node. The requester VPC must provide the information when it initiates a job. For the information passing convention, see General Job Identity Convention.
ext_node_onduty	STRING	The ID of the owner of the upper-level scheduling node. The requester VPC must pass in this information when it initiates a job. For the required conventions, see General Job Identity Conventions.
ext_node_priority	BIGINT	The priority of the upper-level scheduling node. You must pass in this information when the requester VPC initiates a job. For the required conventions, see General Job Identity Convention.
ext_node_cyctype	STRING	This is a reserved field and has no meaning. When a requester VPC initiates a job, it must pass in information. For the required conventions, see Common Job Identity Conventions.
ext_subtask_id	STRING	The subtask ID of the upper-level scheduling node. The requester VPC must pass in this information when it initiates a job. For the information conventions, see General Job Identity Conventions.
ds	STRING	The data archiving date. Data is archived based on the `start_time` of the job in the UTC+8 time zone.

TUNNELS_HISTORY

Provides the history of batch uploads and downloads through the data tunnel. 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. This field 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 channel type. Valid values: TUNNEL LOG TUNNEL INSTANCE LOG
request_id	STRING	The request ID.
object_type	STRING	The object type. Valid values: TABLE INSTANCE
object_name	STRING	The object name, which can be a table name or an instance ID.
partition_spec	STRING	The partition of the partitioned table that is uploaded or downloaded. Example: `time=20130222, loc=beijing`
data_size	BIGINT	The data size in bytes.
block_id	BIGINT	The block number for a Tunnel upload. This field 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 uploaded or downloaded in the current operation. For downloads, this 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 client IP address from which the Tunnel request was initiated.
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 set of columns specified for a Tunnel data download.
quota_name	STRING	The name of the Tunnel quota group.
ds	STRING	The data ingestion date. Example: `ds=20190101`. Data is archived based on the `start_time` of the request in the UTC+8 time zone.

UDF_PRIVILEGES

Lists user-defined function (UDF) authorization information in each project.

Field	Type	Value
udf_catalog	STRING	The name of the project where the UDF resides.
udf_schema	STRING	The schema where the UDF resides. This field is currently 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 resides.
udf_schema	STRING	The schema where the UDF resides. This field is currently 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 resides.
udf_schema	STRING	The schema where the UDF resides. This field is currently NULL.
udf_name	STRING	The UDF name.
resource_catalog	STRING	The project where the resource resides.
resource_schema	STRING	The schema where the resource resides.
resource_name	STRING	The resource name.

USERS

Lists all users.

Field	Type	Value
user_catalog	STRING	The name of the project where the user resides. 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 tag.

USER_ROLES

Lists the roles assigned to users.

Field	Type	Value
user_role_catalog	STRING	The name of the project where the role resides. 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 a project.

Field	Type	Value
schema_catalog	STRING	The name of the project where the schema resides.
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 last time when the schema was updated.
schema_type	STRING	The schema type.
comment	STRING	The schema comment.

QUOTA_USAGE

Provides a real-time snapshot of resource usage for a subscription compute quota. You can use this view to monitor the consumption of compute resources in real time.

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

VOLUMES

Provides the MaxCompute Volume view. The data has a latency of about 3 hours.

Field	Type	Value
volume_catalog	STRING	The name of the project where the volume resides.
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 last time when the volume data was updated.
location	STRING	The storage path of the volume.
comment	STRING	The volume comment.
storage_provider	STRING	The storage engine of the volume.
role_arn	STRING	The ARN of the role used to access the volume storage.
lifecycle	BIGINT	The lifecycle of the volume in days.
options	STRING	The option parameters for the volume.

FOREIGN_SERVERS

Provides the MaxCompute ForeignServer view. The data has a latency of 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 last time when the data was updated.
options	STRING	The option parameters for the server.