Managed Service for Trino API, REST: Cluster.Create

Field

Description

folderId

string

Required field. ID of the folder to create Trino cluster in.

The maximum string length in characters is 50.

name

string

Required field. Name of the Trino cluster. The name must be unique within the folder.

The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

description

string

Description of the Trino cluster.

The maximum string length in characters is 256.

labels

object (map<string, string>)

Custom labels for the Trino cluster as key:value pairs.
For example: {"env": "prod"}.

No more than 64 per resource. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]*. The string length in characters for each key must be 1-63. Each key must match the regular expression [a-z][-_0-9a-z]*.

trino

TrinoConfigSpec

Required field. Configuration of Trino components.

network

NetworkConfig

Required field. Network related configuration options.

deletionProtection

boolean

Deletion Protection inhibits deletion of the cluster.

serviceAccountId

string

Required field. Service account used to access Cloud resources.

The maximum string length in characters is 50.

logging

LoggingConfig

Cloud logging configuration.

maintenanceWindow

MaintenanceWindow

Window of maintenance operations.

Field

Description

catalogs[]

CatalogSpec

List of catalogs that enable integration with various data sources.
Each catalog defines a connection to an external data source that Trino can query.

coordinatorConfig

CoordinatorConfig

Required field. Configuration for the coordinator, specifying computational resources and other settings.

workerConfig

WorkerConfig

Required field. Configuration for worker nodes, including scaling policy and computational resources.

retryPolicy

RetryPolicyConfig

Configuration for retry policy, specifying the spooling storage destination and other settings.

version

string

Trino version.
Format: "Number".

accessControl

AccessControlConfig

Configuration for access control, specifying the fine-grained access rules.

resourceManagement

ResourceManagementConfig

Configuration for cluster resource management, specifying the resource groups.

tls

TLSConfig

Configuration for TLS.

Field

Description

name

string

Required field. Name of the catalog.
Must be unique within a Trino cluster.

The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

connector

Connector

Required field. Connector backing this catalog.

description

string

Description of the catalog.

The maximum string length in characters is 256.

labels

object (map<string, string>)

Labels associated with the catalog.

No more than 64 per resource. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]*. The string length in characters for each key must be 1-63. Each key must match the regular expression [a-z][-_0-9a-z]*.

Field

Description

hive

HiveConnector

Hive connector configuration.

Includes only one of the fields hive, iceberg, deltaLake, postgresql, clickhouse, tpch, tpcds, oracle, sqlserver, hudi, mysql, greenplum.

iceberg

IcebergConnector

Iceberg connector configuration.

Includes only one of the fields hive, iceberg, deltaLake, postgresql, clickhouse, tpch, tpcds, oracle, sqlserver, hudi, mysql, greenplum.

deltaLake

DeltaLakeConnector

Delta Lake connector configuration.

Includes only one of the fields hive, iceberg, deltaLake, postgresql, clickhouse, tpch, tpcds, oracle, sqlserver, hudi, mysql, greenplum.

postgresql

PostgresqlConnector

PostgreSQL connector configuration.

Includes only one of the fields hive, iceberg, deltaLake, postgresql, clickhouse, tpch, tpcds, oracle, sqlserver, hudi, mysql, greenplum.

clickhouse

ClickhouseConnector

ClickHouse connector configuration.

Includes only one of the fields hive, iceberg, deltaLake, postgresql, clickhouse, tpch, tpcds, oracle, sqlserver, hudi, mysql, greenplum.

tpch

TPCHConnector

TPC-H connector for synthetic benchmarking.

Includes only one of the fields hive, iceberg, deltaLake, postgresql, clickhouse, tpch, tpcds, oracle, sqlserver, hudi, mysql, greenplum.

tpcds

TPCDSConnector

TPC-DS connector for synthetic benchmarking.

Includes only one of the fields hive, iceberg, deltaLake, postgresql, clickhouse, tpch, tpcds, oracle, sqlserver, hudi, mysql, greenplum.

oracle

OracleConnector

Oracle connector configuration for connecting to Oracle Database instances.

Includes only one of the fields hive, iceberg, deltaLake, postgresql, clickhouse, tpch, tpcds, oracle, sqlserver, hudi, mysql, greenplum.

sqlserver

SQLServerConnector

SQLServer connector configuration for connecting to SQLServer Database instances.

Includes only one of the fields hive, iceberg, deltaLake, postgresql, clickhouse, tpch, tpcds, oracle, sqlserver, hudi, mysql, greenplum.

hudi

HudiConnector

Hudi connector configuration.

Includes only one of the fields hive, iceberg, deltaLake, postgresql, clickhouse, tpch, tpcds, oracle, sqlserver, hudi, mysql, greenplum.

mysql

MysqlConnector

MySQL connector configuration for connecting to MySQL Database instances.

Includes only one of the fields hive, iceberg, deltaLake, postgresql, clickhouse, tpch, tpcds, oracle, sqlserver, hudi, mysql, greenplum.

greenplum

GreenplumConnector

Greenplum connector configuration for connecting to Greenplum or Cloudberry Database instances.

Includes only one of the fields hive, iceberg, deltaLake, postgresql, clickhouse, tpch, tpcds, oracle, sqlserver, hudi, mysql, greenplum.

Field

Description

metastore

Metastore

Required field. Metastore configuration.

filesystem

FileSystem

Required field. File system configuration.

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

hive

HiveMetastore

Includes only one of the fields hive.

Field

Description

uri

string

URI or cluster ID of the Hive Metastore.

Includes only one of the fields uri.

Field

Description

s3

object

Includes only one of the fields s3, externalS3.

externalS3

ExternalS3FileSystem

Includes only one of the fields s3, externalS3.

Field

Description

awsAccessKey

string

Required field.

awsSecretKey

string

Required field.

awsEndpoint

string

Required field.

awsRegion

string

Required field.

Field

Description

metastore

Metastore

Required field. Metastore configuration.

filesystem

FileSystem

Required field. File system configuration.

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

metastore

Metastore

Required field. Metastore configuration.

filesystem

FileSystem

Required field. File system configuration.

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

connection

PostgresqlConnection

Connection configuration.

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

onPremise

OnPremise

Includes only one of the fields onPremise, connectionManager.

connectionManager

ConnectionManager

Includes only one of the fields onPremise, connectionManager.

Field

Description

connectionUrl

string

Required field. Connection to the Postgresql.

Value must match the regular expression ^jdbc:[a-z0-9]+://(?:.+:\d+)/(?:.*)$.

userName

string

Required field. Name of the Postgresql user.

The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

password

string

Required field. Password of the Postgresql user.

The string length in characters must be 0-128.

Field

Description

connectionId

string

Required field. Connection ID.

The string length in characters must be 1-50.

database

string

Required field. Database.

The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

connectionProperties

object (map<string, string>)

Additional connection properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-zA-Z]*.

Field

Description

connection

ClickhouseConnection

Connection configuration.

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

onPremise

OnPremise

Includes only one of the fields onPremise, connectionManager.

connectionManager

ConnectionManager

Includes only one of the fields onPremise, connectionManager.

Field

Description

connectionUrl

string

Required field. Connection to the Clickhouse.

Value must match the regular expression ^jdbc:[a-z0-9]+://(?:.+:\d+)/(?:.*)$.

userName

string

Required field. Name of the Clickhouse user.

The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

password

string

Required field. Password of the Clickhouse user.

The string length in characters must be 0-128.

Field

Description

connectionId

string

Required field. Connection ID.

The string length in characters must be 1-50.

database

string

Required field. Database.

The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

connectionProperties

object (map<string, string>)

Additional connection properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-zA-Z_]*.

Field

Description

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

connection

OracleConnection

Connection configuration.

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

onPremise

OnPremise

Includes only one of the fields onPremise.

Field

Description

connectionUrl

string

Required field. Connection to the Oracle.

Value must match the regular expression ^jdbc:[a-z0-9]+:(?s:.*)$.

userName

string

Required field. Name of the Oracle user.

The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

password

string

Required field. Password of the Oracle user.

The string length in characters must be 0-128.

Field

Description

connection

SQLServerConnection

Connection configuration.

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

onPremise

OnPremise

Includes only one of the fields onPremise.

Field

Description

connectionUrl

string

Required field. Connection to the SQLServer.

Value must match the regular expression ^jdbc:[a-z0-9]+:(?s:.*)$.

userName

string

Required field. Name of the SQLServer user.

The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

password

string

Required field. Password of the SQLServer user.

The string length in characters must be 0-128.

Field

Description

metastore

Metastore

Required field. Metastore configuration.

filesystem

FileSystem

Required field. File system configuration.

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

connection

MysqlConnection

Connection configuration.

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

onPremise

OnPremise

Includes only one of the fields onPremise, connectionManager.

connectionManager

ConnectionManager

Includes only one of the fields onPremise, connectionManager.

Field

Description

connectionUrl

string

Required field. Connection to the MySQL.

Value must match the regular expression ^jdbc:[a-z0-9]+://(?:.+:\d+)/(?:.*)$.

userName

string

Required field. Name of the MySQL user.

The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

password

string

Required field. Password of the MySQL user.

The string length in characters must be 0-128.

Field

Description

connectionId

string

Required field. Connection ID.

The string length in characters must be 1-50.

connectionProperties

object (map<string, string>)

Additional connection properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-zA-Z_]*.

Field

Description

connection

GreenplumConnection

Connection configuration

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

onPremise

OnPremise

Includes only one of the fields onPremise, connectionManager.

connectionManager

ConnectionManager

Includes only one of the fields onPremise, connectionManager.

Field

Description

connectionUrl

string

Required field. Connection to the Greenplum/Cloudberry.

Value must match the regular expression ^jdbc:[a-z0-9]+://(?:.+:\d+)/(?:.*)$.

userName

string

Required field. Name of the Greenplum/Cloudberry user.

The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

password

string

Required field. Password of the Greenplum/Cloudberry user.

The string length in characters must be 0-128.

Field

Description

connectionId

string

Required field. Connection ID.

The string length in characters must be 1-50.

database

string

Required field. Database.

The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

connectionProperties

object (map<string, string>)

Additional connection properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-zA-Z]*.

Field

Description

resources

Resources

Required field. Configuration for computational resources assigned to the coordinator instance.

Field

Description

resourcePresetId

string

Required field. ID of the preset for computational resources allocated to a instance (e.g., CPU, memory, etc.).

The maximum string length in characters is 50.

Field

Description

resources

Resources

Required field. Configuration for computational resources for worker instances.

scalePolicy

WorkerScalePolicy

Required field. Configuration for scaling policy for worker instances.

Field

Description

fixedScale

FixedScalePolicy

A fixed scaling policy that specifies a fixed number of worker instances.

Includes only one of the fields fixedScale, autoScale.

Defines the scaling type for worker instances.
Only one type of scaling can be specified at a time.

autoScale

AutoScalePolicy

A scaling policy that dynamically adjusts the number of worker instances
based on the cluster's workload. The system automatically increases or
decreases the number of instances within the defined range.

Includes only one of the fields fixedScale, autoScale.

Defines the scaling type for worker instances.
Only one type of scaling can be specified at a time.

Field

Description

count

string (int64)

Specifies the number of worker instances.

Acceptable values are 1 to 512, inclusive.

Field

Description

minCount

string (int64)

Acceptable values are 0 to 512, inclusive.

maxCount

string (int64)

Acceptable values are 1 to 512, inclusive.

Field

Description

policy

enum (RetryPolicy)

Retry policy level.

• QUERY
• TASK

exchangeManager

ExchangeManagerConfig

Configuration for exchange manager.

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

storage

ExchangeManagerStorage

Field

Description

serviceS3

object

Use service side s3 bucket for exchange manager.

Includes only one of the fields serviceS3.

Field

Description

catalogs[]

CatalogAccessRule

Catalog access control rules.

schemas[]

SchemaAccessRule

Schema access control rules.

tables[]

TableAccessRule

Table access control rules.

functions[]

FunctionAccessRule

Function access control rules.

procedures[]

ProcedureAccessRule

Procedures access control rules.

queries[]

QueryAccessRule

Queries access control rules.

systemSessionProperties[]

SystemSessionPropertyAccessRule

System session property access control rules.

catalogSessionProperties[]

CatalogSessionPropertyAccessRule

Catalog session property access control rules.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

catalog

CatalogAccessRuleMatcher

Catalog matcher specifying what catalogs the rule is applied to.

permission

enum (Permission)

Required field. Permission granted by the rule.

• NONE: Denies all operations on the catalog entities.
• ALL: Allows all operations on catalog entities.
• READ_ONLY: Allows only read operations on catalog entities.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

nameRegexp

string

Catalog name regexp the rule is applied to.

The maximum string length in characters is 256.

Includes only one of the fields nameRegexp, ids, names.

ids

CatalogIds

Catalog IDs rule is applied to.

Includes only one of the fields nameRegexp, ids, names.

names

CatalogNames

Catalog names rule is applied to.

Includes only one of the fields nameRegexp, ids, names.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

catalog

CatalogAccessRuleMatcher

Catalog matcher specifying what catalogs the rule is applied to.

schema

SchemaAccessRuleMatcher

Schema matcher specifying what schemas the rule is applied to.

owner

enum (Owner)

Required field. Ownership granted by the rule.

• NO: User is not considered an owner of the schema.
• YES: User is considered an owner of the schema.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

nameRegexp

string

Schema name regexp the rule is applied to.

The maximum string length in characters is 256.

Includes only one of the fields nameRegexp, names.

names

SchemaNames

Schema names the rule is applied to.

Includes only one of the fields nameRegexp, names.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [a-z0-9_-]+.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

catalog

CatalogAccessRuleMatcher

Catalog matcher specifying what catalogs the rule is applied to.

schema

SchemaAccessRuleMatcher

Schema matcher specifying what schemas the rule is applied to.

table

TableAccessRuleMatcher

Table matcher specifying what tables the rule is applied to.

privileges[]

enum (Privilege)

Permission granted by the rule.

• SELECT: Allows SELECT statements on the table.
• INSERT: Allows INSERT statements on the table.
• DELETE: Allows DELETE statements on the table.
• UPDATE: Allows UPDATE statements on the table.
• OWNERSHIP: Allows CREATE, DROP, COMMENT ON and ALTER statements on the table.
• GRANT_SELECT: Allows SELECT statements on the table while creating view.

columns[]

Column

Column rules.

filter

string

Boolean SQL expression to filter table rows for particular user.

The maximum string length in characters is 128.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

nameRegexp

string

Table name regexp the rule is applied to.

The maximum string length in characters is 256.

Includes only one of the fields nameRegexp, names.

names

TableNames

Table names the rule is applied to.

Includes only one of the fields nameRegexp, names.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [a-z0-9_-]+.

Field

Description

name

string

Required field. Column name.

The maximum string length in characters is 63. Value must match the regular expression [a-z0-9_-]+.

access

enum (AccessMode)

Required field. Column access mode.

• NONE: Access to column is denied.
• ALL: Access to column is allowed.

mask

string

SQL expression mask to evaluate instead of original column values.
Mask should have the same type as original column.

The maximum string length in characters is 128.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

catalog

CatalogAccessRuleMatcher

Catalog matcher specifying what catalogs the rule is applied to.

schema

SchemaAccessRuleMatcher

Schema matcher specifying what schema the rule is applied to.

function

FunctionAccessRuleMatcher

Function matcher specifying what functions the rule is applied to.

privileges[]

enum (Privilege)

Privileges granted by the rule.

• EXECUTE: Allows to execute the function.
• GRANT_EXECUTE: Allows to use the function while view creation.
• OWNERSHIP: Allows to CREATE and DROP the function.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

nameRegexp

string

Function name regexp the rule is applied to.

The maximum string length in characters is 256.

Includes only one of the fields nameRegexp, names.

names

FunctionNames

Function names the rule is applied to.

Includes only one of the fields nameRegexp, names.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [a-z0-9_-]+.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

catalog

CatalogAccessRuleMatcher

Catalog matcher specifying what catalogs the rule is applied to.

schema

SchemaAccessRuleMatcher

Schema matcher specifying what schema the rule is applied to.

procedure

ProcedureAccessRuleMatcher

Procedure matcher specifying what functions the rule is applied to.

privileges[]

enum (Privilege)

Privileges granted by the rule.

• EXECUTE: Allows to execute the procedure.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

nameRegexp

string

Procedure name regexp the rule is applied to.

The maximum string length in characters is 256.

Includes only one of the fields nameRegexp, names.

names

ProcedureNames

Procedure names the rule is applied to.

Includes only one of the fields nameRegexp, names.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [a-z0-9_-]+.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

queryOwners[]

string

Owners of queries the rule is applied to.
Cannot be combined with EXECUTE privilege.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

privileges[]

enum (Privilege)

Privileges granted by the user.

• VIEW: Allows to view the query.
• EXECUTE: Allows to execute the query.
• KILL: Allows to kill the query.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

property

PropertyAccessRuleMatcher

Property matcher specifying what properties the rule is applied to.

allow

enum (Allow)

Required field. Whether the rule allows setting the property.

• NO: Denies setting the system session property.
• YES: Allows to set the system session property.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

nameRegexp

string

Property name regexp the rule is applied to.

The maximum string length in characters is 256.

Includes only one of the fields nameRegexp, names.

names

PropertyNames

Property names the rule is applied to.

Includes only one of the fields nameRegexp, names.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [a-z_]+.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

catalog

CatalogAccessRuleMatcher

Catalog matcher specifying what catalogs the rule is applied to.

property

PropertyAccessRuleMatcher

Property matcher specifying what properties the rule is applied to.

allow

enum (Allow)

Required field. Whether the rule allows setting the property.

• NO: Denies setting the catalog session property.
• YES: Allows to set the catalog session property.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

resourceGroups

ResourceGroupsConfig

Resource groups configuration.

query

QueryConfig

Query management confiugration.

Field

Description

rootGroups[]

ResourceGroupConfig

Root resource groups configuration.

The number of elements must be greater than 0.

selectors[]

SelectorRuleConfig

Selector rules for routing queries to resource groups.

The number of elements must be greater than 0.

cpuQuotaPeriod

string

Period for CPU quota calculations.

Field

Description

name

string

Required field. Resource group name.

maxQueued

string (int64)

Maximum number of queued queries.

Value must be greater than 0.

softConcurrencyLimit

string (int64)

Number of concurrently running queries after which new queries only run if peer groups are below soft limits.

hardConcurrencyLimit

string (int64)

Maximum number of queries that can run concurrently.

Value must be greater than 0.

softMemoryLimit

string

Maximum amount of distributed memory this group can use.

softCpuLimit

string

Maximum CPU time per period this group can use before applying penalty to running queries (requires hard_cpu_limit).

hardCpuLimit

string

Maximum CPU time per period this group can use.

schedulingPolicy

enum (SchedulingPolicy)

Policy for selecting queued queries and sub-group eligibility.

• FAIR: Queued queries processed first-in-first-out, sub-groups take turns starting queries.
• WEIGHTED: Queries selected stochastically by priority, sub-groups selected by schedulingWeight.
• WEIGHTED_FAIR: Sub-groups selected by schedulingWeight and concurrency relative to their share.
• QUERY_PRIORITY: Queued queries selected strictly by priority.

schedulingWeight

string (int64)

Weight for weighted and weighted_fair scheduling policies.

subGroups[]

ResourceGroupConfig

List of sub-groups.

Field

Description

user

string

Regex to match against username.

userGroup

string

Regex to match against user groups.

source

string

Regex to match against query source.

queryType

enum (QueryType)

Type of query to match.

• SELECT
• EXPLAIN
• DESCRIBE
• INSERT
• UPDATE
• MERGE
• DELETE
• ANALYZE
• DATA_DEFINITION
• ALTER_TABLE_EXECUTE

clientTags[]

string

Tags that must all be present in the query's client tags.

group

string

Required field. Target resource group name.

Field

Description

properties

object (map<string, string>)

Query properties.

Field

Description

trustedCertificates[]

string

Trusted CA-certificates. Each element should contain single self-signed CA-certificate or
chain of CA-certificates where first certificate is the leaf and last certificate is the self-signed root.

The maximum number of elements is 8. The maximum string length in characters for each value is 8192.

Field

Description

subnetIds[]

string

IDs of VPC network subnets where instances of the cluster are attached.

securityGroupIds[]

string

User security groups.

Field

Description

enabled

boolean

Logs generated by the Trino components are delivered to Cloud Logging.

folderId

string

Logs should be written to default log group for specified folder.

Value must match the regular expression ([a-zA-Z][-a-zA-Z0-9_.]{0,63})?.

Includes only one of the fields folderId, logGroupId.

Destination of log records.

logGroupId

string

Logs should be written to log group resolved by ID.

Value must match the regular expression ([a-zA-Z][-a-zA-Z0-9_.]{0,63})?.

Includes only one of the fields folderId, logGroupId.

Destination of log records.

minLevel

enum (Level)

Minimum log entry level.

See LogLevel.Level for details.

• TRACE: Trace log level.

  Possible use case: verbose logging of some business logic.

• DEBUG: Debug log level.

  Possible use case: debugging special cases in application logic.

• INFO: Info log level.

  Mostly used for information messages.

• WARN: Warn log level.

  May be used to alert about significant events.

• ERROR: Error log level.

  May be used to alert about errors in infrastructure, logic, etc.

• FATAL: Fatal log level.

  May be used to alert about unrecoverable failures and events.

Field

Description

anytime

object

Includes only one of the fields anytime, weeklyMaintenanceWindow.

weeklyMaintenanceWindow

WeeklyMaintenanceWindow

Includes only one of the fields anytime, weeklyMaintenanceWindow.

Field

Description

day

enum (WeekDay)

• MON
• TUE
• WED
• THU
• FRI
• SAT
• SUN

hour

string (int64)

Hour of the day in UTC.

Acceptable values are 1 to 24, inclusive.

Field

Description

id

string

ID of the operation.

description

string

Description of the operation. 0-256 characters long.

createdAt

string (date-time)

Creation timestamp.

String in RFC3339 text format. The range of possible values is from
0001-01-01T00:00:00Z to 9999-12-31T23:59:59.999999999Z, i.e. from 0 to 9 digits for fractions of a second.

To work with values in this field, use the APIs described in the
Protocol Buffers reference.
In some languages, built-in datetime utilities do not support nanosecond precision (9 digits).

createdBy

string

ID of the user or service account who initiated the operation.

modifiedAt

string (date-time)

The time when the Operation resource was last modified.

String in RFC3339 text format. The range of possible values is from
0001-01-01T00:00:00Z to 9999-12-31T23:59:59.999999999Z, i.e. from 0 to 9 digits for fractions of a second.

To work with values in this field, use the APIs described in the
Protocol Buffers reference.
In some languages, built-in datetime utilities do not support nanosecond precision (9 digits).

done

boolean

If the value is false, it means the operation is still in progress.
If true, the operation is completed, and either error or response is available.

metadata

CreateClusterMetadata

Service-specific metadata associated with the operation.
It typically contains the ID of the target resource that the operation is performed on.
Any method that returns a long-running operation should document the metadata type, if any.

error

Status

The error result of the operation in case of failure or cancellation.

Includes only one of the fields error, response.

The operation result.
If done == false and there was no failure detected, neither error nor response is set.
If done == false and there was a failure detected, error is set.
If done == true, exactly one of error or response is set.

response

Cluster

The normal response of the operation in case of success.
If the original method returns no data on success, such as Delete,
the response is google.protobuf.Empty.
If the original method is the standard Create/Update,
the response should be the target resource of the operation.
Any method that returns a long-running operation should document the response type, if any.

Includes only one of the fields error, response.

The operation result.
If done == false and there was no failure detected, neither error nor response is set.
If done == false and there was a failure detected, error is set.
If done == true, exactly one of error or response is set.

Field

Description

clusterId

string

ID of the Trino cluster that is being created.

Field

Description

code

integer (int32)

Error code. An enum value of google.rpc.Code.

message

string

An error message.

details[]

object

A list of messages that carry the error details.

Field

Description

id

string

Unique ID of the Trino cluster.
This ID is assigned by Cloud in the process of creating a Trino cluster.

folderId

string

ID of the folder that the Trino cluster belongs to.

createdAt

string (date-time)

The time when the Trino cluster was created.

String in RFC3339 text format. The range of possible values is from
0001-01-01T00:00:00Z to 9999-12-31T23:59:59.999999999Z, i.e. from 0 to 9 digits for fractions of a second.

To work with values in this field, use the APIs described in the
Protocol Buffers reference.
In some languages, built-in datetime utilities do not support nanosecond precision (9 digits).

name

string

Name of the Trino cluster.
The name is unique within the folder. 1-64 characters long.

description

string

Description of the Trino cluster. 0-256 characters long.

labels

object (map<string, string>)

Resource labels as key:value pairs. Maximum of 64 per resource.

monitoring[]

Monitoring

Monitoring systems relevant to the Trino cluster.

trino

TrinoConfig

Configuration of the Trino cluster.

health

enum (Health)

Aggregated cluster health.

• HEALTH_UNKNOWN: Object is in unknown state (we have no data)
• ALIVE: Object is alive and well (all hosts are alive)
• DEAD: Object is inoperable (it cannot perform any of its essential functions)
• DEGRADED: Object is partially alive (it can perform some of its essential functions)

status

enum (Status)

Cluster status.

• STATUS_UNKNOWN: Cluster state is unknown.
• CREATING: Cluster is being created.
• RUNNING: Cluster is running normally.
• ERROR: Cluster encountered a problem and cannot operate.
• STOPPING: Cluster is stopping.
• STOPPED: Cluster is stopped.
• STARTING: Cluster is starting.
• UPDATING: Cluster is being updated.

network

NetworkConfig

Network related configuration options.

deletionProtection

boolean

Deletion Protection inhibits deletion of the cluster.

serviceAccountId

string

Service account used to access Cloud resources.

The maximum string length in characters is 50.

logging

LoggingConfig

Cloud logging configuration.

coordinatorUrl

string

Address of Trino Coordinator.

maintenanceWindow

MaintenanceWindow

Window of maintenance operations.

plannedOperation

MaintenanceOperation

Maintenance operation planned at nearest maintenance_window.

Field

Description

name

string

Name of the monitoring system.

description

string

Description of the monitoring system.

link

string

Link to the monitoring system.

Field

Description

coordinatorConfig

CoordinatorConfig

Required field. Configuration for the coordinator, specifying computational resources and other settings.

workerConfig

WorkerConfig

Required field. Configuration for worker nodes, including scaling policy and computational resources.

version

string

Version of Trino.

retryPolicy

RetryPolicyConfig

Configuration for retry policy, specifying the spooling storage destination and other settings.

accessControl

AccessControlConfig

Configuration for access control, specifying the fine-grained rules of accesses.

resourceManagement

ResourceManagementConfig

Configuration for resource management, specifying the resource groups and other settings.

tls

TLSConfig

Configuration for TLS.

Field

Description

resources

Resources

Required field. Configuration for computational resources assigned to the coordinator instance.

Field

Description

resourcePresetId

string

Required field. ID of the preset for computational resources allocated to a instance (e.g., CPU, memory, etc.).

The maximum string length in characters is 50.

Field

Description

resources

Resources

Required field. Configuration for computational resources for worker instances.

scalePolicy

WorkerScalePolicy

Required field. Configuration for scaling policy for worker instances.

Field

Description

fixedScale

FixedScalePolicy

A fixed scaling policy that specifies a fixed number of worker instances.

Includes only one of the fields fixedScale, autoScale.

Defines the scaling type for worker instances.
Only one type of scaling can be specified at a time.

autoScale

AutoScalePolicy

A scaling policy that dynamically adjusts the number of worker instances
based on the cluster's workload. The system automatically increases or
decreases the number of instances within the defined range.

Includes only one of the fields fixedScale, autoScale.

Defines the scaling type for worker instances.
Only one type of scaling can be specified at a time.

Field

Description

count

string (int64)

Specifies the number of worker instances.

Acceptable values are 1 to 512, inclusive.

Field

Description

minCount

string (int64)

Acceptable values are 0 to 512, inclusive.

maxCount

string (int64)

Acceptable values are 1 to 512, inclusive.

Field

Description

policy

enum (RetryPolicy)

Retry policy level.

• QUERY
• TASK

exchangeManager

ExchangeManagerConfig

Configuration for exchange manager.

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

Field

Description

additionalProperties

object (map<string, string>)

Additional properties.

No more than 256 per resource. The maximum string length in characters for each value is 128. Each value must match the regular expression [-_0-9a-zA-Z.,:\/_ ]*. The string length in characters for each key must be 1-128. Each key must match the regular expression [a-z][-_0-9a-z.]*.

storage

ExchangeManagerStorage

Field

Description

serviceS3

object

Use service side s3 bucket for exchange manager.

Includes only one of the fields serviceS3.

Field

Description

catalogs[]

CatalogAccessRule

Catalog access control rules.

schemas[]

SchemaAccessRule

Schema access control rules.

tables[]

TableAccessRule

Table access control rules.

functions[]

FunctionAccessRule

Function access control rules.

procedures[]

ProcedureAccessRule

Procedures access control rules.

queries[]

QueryAccessRule

Queries access control rules.

systemSessionProperties[]

SystemSessionPropertyAccessRule

System session property access control rules.

catalogSessionProperties[]

CatalogSessionPropertyAccessRule

Catalog session property access control rules.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

catalog

CatalogAccessRuleMatcher

Catalog matcher specifying what catalogs the rule is applied to.

permission

enum (Permission)

Required field. Permission granted by the rule.

• NONE: Denies all operations on the catalog entities.
• ALL: Allows all operations on catalog entities.
• READ_ONLY: Allows only read operations on catalog entities.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

nameRegexp

string

Catalog name regexp the rule is applied to.

The maximum string length in characters is 256.

Includes only one of the fields nameRegexp, ids, names.

ids

CatalogIds

Catalog IDs rule is applied to.

Includes only one of the fields nameRegexp, ids, names.

names

CatalogNames

Catalog names rule is applied to.

Includes only one of the fields nameRegexp, ids, names.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

catalog

CatalogAccessRuleMatcher

Catalog matcher specifying what catalogs the rule is applied to.

schema

SchemaAccessRuleMatcher

Schema matcher specifying what schemas the rule is applied to.

owner

enum (Owner)

Required field. Ownership granted by the rule.

• NO: User is not considered an owner of the schema.
• YES: User is considered an owner of the schema.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

nameRegexp

string

Schema name regexp the rule is applied to.

The maximum string length in characters is 256.

Includes only one of the fields nameRegexp, names.

names

SchemaNames

Schema names the rule is applied to.

Includes only one of the fields nameRegexp, names.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [a-z0-9_-]+.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

catalog

CatalogAccessRuleMatcher

Catalog matcher specifying what catalogs the rule is applied to.

schema

SchemaAccessRuleMatcher

Schema matcher specifying what schemas the rule is applied to.

table

TableAccessRuleMatcher

Table matcher specifying what tables the rule is applied to.

privileges[]

enum (Privilege)

Permission granted by the rule.

• SELECT: Allows SELECT statements on the table.
• INSERT: Allows INSERT statements on the table.
• DELETE: Allows DELETE statements on the table.
• UPDATE: Allows UPDATE statements on the table.
• OWNERSHIP: Allows CREATE, DROP, COMMENT ON and ALTER statements on the table.
• GRANT_SELECT: Allows SELECT statements on the table while creating view.

columns[]

Column

Column rules.

filter

string

Boolean SQL expression to filter table rows for particular user.

The maximum string length in characters is 128.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

nameRegexp

string

Table name regexp the rule is applied to.

The maximum string length in characters is 256.

Includes only one of the fields nameRegexp, names.

names

TableNames

Table names the rule is applied to.

Includes only one of the fields nameRegexp, names.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [a-z0-9_-]+.

Field

Description

name

string

Required field. Column name.

The maximum string length in characters is 63. Value must match the regular expression [a-z0-9_-]+.

access

enum (AccessMode)

Required field. Column access mode.

• NONE: Access to column is denied.
• ALL: Access to column is allowed.

mask

string

SQL expression mask to evaluate instead of original column values.
Mask should have the same type as original column.

The maximum string length in characters is 128.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

catalog

CatalogAccessRuleMatcher

Catalog matcher specifying what catalogs the rule is applied to.

schema

SchemaAccessRuleMatcher

Schema matcher specifying what schema the rule is applied to.

function

FunctionAccessRuleMatcher

Function matcher specifying what functions the rule is applied to.

privileges[]

enum (Privilege)

Privileges granted by the rule.

• EXECUTE: Allows to execute the function.
• GRANT_EXECUTE: Allows to use the function while view creation.
• OWNERSHIP: Allows to CREATE and DROP the function.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

nameRegexp

string

Function name regexp the rule is applied to.

The maximum string length in characters is 256.

Includes only one of the fields nameRegexp, names.

names

FunctionNames

Function names the rule is applied to.

Includes only one of the fields nameRegexp, names.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [a-z0-9_-]+.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

catalog

CatalogAccessRuleMatcher

Catalog matcher specifying what catalogs the rule is applied to.

schema

SchemaAccessRuleMatcher

Schema matcher specifying what schema the rule is applied to.

procedure

ProcedureAccessRuleMatcher

Procedure matcher specifying what functions the rule is applied to.

privileges[]

enum (Privilege)

Privileges granted by the rule.

• EXECUTE: Allows to execute the procedure.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

nameRegexp

string

Procedure name regexp the rule is applied to.

The maximum string length in characters is 256.

Includes only one of the fields nameRegexp, names.

names

ProcedureNames

Procedure names the rule is applied to.

Includes only one of the fields nameRegexp, names.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [a-z0-9_-]+.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

queryOwners[]

string

Owners of queries the rule is applied to.
Cannot be combined with EXECUTE privilege.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

privileges[]

enum (Privilege)

Privileges granted by the user.

• VIEW: Allows to view the query.
• EXECUTE: Allows to execute the query.
• KILL: Allows to kill the query.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

property

PropertyAccessRuleMatcher

Property matcher specifying what properties the rule is applied to.

allow

enum (Allow)

Required field. Whether the rule allows setting the property.

• NO: Denies setting the system session property.
• YES: Allows to set the system session property.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

nameRegexp

string

Property name regexp the rule is applied to.

The maximum string length in characters is 256.

Includes only one of the fields nameRegexp, names.

names

PropertyNames

Property names the rule is applied to.

Includes only one of the fields nameRegexp, names.

Field

Description

any[]

string

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [a-z_]+.

Field

Description

users[]

string

IAM user IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

groups[]

string

IAM group IDs the rule is applied to.

The maximum number of elements is 128. The maximum string length in characters for each value is 63. Each value must match the regular expression [-_0-9a-z]+.

catalog

CatalogAccessRuleMatcher

Catalog matcher specifying what catalogs the rule is applied to.

property

PropertyAccessRuleMatcher

Property matcher specifying what properties the rule is applied to.

allow

enum (Allow)

Required field. Whether the rule allows setting the property.

• NO: Denies setting the catalog session property.
• YES: Allows to set the catalog session property.

description

string

Rule description.

The maximum string length in characters is 128.

Field

Description

resourceGroups

ResourceGroupsConfig

Resource groups configuration.

query

QueryConfig

Query management confiugration.

Field

Description

rootGroups[]

ResourceGroupConfig

Root resource groups configuration.

The number of elements must be greater than 0.

selectors[]

SelectorRuleConfig

Selector rules for routing queries to resource groups.

The number of elements must be greater than 0.

cpuQuotaPeriod

string

Period for CPU quota calculations.

Field

Description

name

string

Required field. Resource group name.

maxQueued

string (int64)

Maximum number of queued queries.

Value must be greater than 0.

softConcurrencyLimit

string (int64)

Number of concurrently running queries after which new queries only run if peer groups are below soft limits.

hardConcurrencyLimit

string (int64)

Maximum number of queries that can run concurrently.

Value must be greater than 0.

softMemoryLimit

string

Maximum amount of distributed memory this group can use.

softCpuLimit

string

Maximum CPU time per period this group can use before applying penalty to running queries (requires hard_cpu_limit).

hardCpuLimit

string

Maximum CPU time per period this group can use.

schedulingPolicy

enum (SchedulingPolicy)

Policy for selecting queued queries and sub-group eligibility.

• FAIR: Queued queries processed first-in-first-out, sub-groups take turns starting queries.
• WEIGHTED: Queries selected stochastically by priority, sub-groups selected by schedulingWeight.
• WEIGHTED_FAIR: Sub-groups selected by schedulingWeight and concurrency relative to their share.
• QUERY_PRIORITY: Queued queries selected strictly by priority.

schedulingWeight

string (int64)

Weight for weighted and weighted_fair scheduling policies.

subGroups[]

ResourceGroupConfig

List of sub-groups.

Field

Description

user

string

Regex to match against username.

userGroup

string

Regex to match against user groups.

source

string

Regex to match against query source.

queryType

enum (QueryType)

Type of query to match.

• SELECT
• EXPLAIN
• DESCRIBE
• INSERT
• UPDATE
• MERGE
• DELETE
• ANALYZE
• DATA_DEFINITION
• ALTER_TABLE_EXECUTE

clientTags[]

string

Tags that must all be present in the query's client tags.

group

string

Required field. Target resource group name.

Field

Description

properties

object (map<string, string>)

Query properties.

Field

Description

trustedCertificates[]

string

Trusted CA-certificates. Each element should contain single self-signed CA-certificate or
chain of CA-certificates where first certificate is the leaf and last certificate is the self-signed root.

The maximum number of elements is 8. The maximum string length in characters for each value is 8192.

Field

Description

subnetIds[]

string

IDs of VPC network subnets where instances of the cluster are attached.

securityGroupIds[]

string

User security groups.

Field

Description

enabled

boolean

Logs generated by the Trino components are delivered to Cloud Logging.

folderId

string

Logs should be written to default log group for specified folder.

Value must match the regular expression ([a-zA-Z][-a-zA-Z0-9_.]{0,63})?.

Includes only one of the fields folderId, logGroupId.

Destination of log records.

logGroupId

string

Logs should be written to log group resolved by ID.

Value must match the regular expression ([a-zA-Z][-a-zA-Z0-9_.]{0,63})?.

Includes only one of the fields folderId, logGroupId.

Destination of log records.

minLevel

enum (Level)

Minimum log entry level.

See LogLevel.Level for details.

• TRACE: Trace log level.

  Possible use case: verbose logging of some business logic.

• DEBUG: Debug log level.

  Possible use case: debugging special cases in application logic.

• INFO: Info log level.

  Mostly used for information messages.

• WARN: Warn log level.

  May be used to alert about significant events.

• ERROR: Error log level.

  May be used to alert about errors in infrastructure, logic, etc.

• FATAL: Fatal log level.

  May be used to alert about unrecoverable failures and events.

Field

Description

anytime

object

Includes only one of the fields anytime, weeklyMaintenanceWindow.

weeklyMaintenanceWindow

WeeklyMaintenanceWindow

Includes only one of the fields anytime, weeklyMaintenanceWindow.

Field

Description

day

enum (WeekDay)

• MON
• TUE
• WED
• THU
• FRI
• SAT
• SUN

hour

string (int64)

Hour of the day in UTC.

Acceptable values are 1 to 24, inclusive.

Field

Description

info

string

The maximum string length in characters is 256.

delayedUntil

string (date-time)

String in RFC3339 text format. The range of possible values is from
0001-01-01T00:00:00Z to 9999-12-31T23:59:59.999999999Z, i.e. from 0 to 9 digits for fractions of a second.

To work with values in this field, use the APIs described in the
Protocol Buffers reference.
In some languages, built-in datetime utilities do not support nanosecond precision (9 digits).

latestMaintenanceTime

string (date-time)

String in RFC3339 text format. The range of possible values is from
0001-01-01T00:00:00Z to 9999-12-31T23:59:59.999999999Z, i.e. from 0 to 9 digits for fractions of a second.

To work with values in this field, use the APIs described in the
Protocol Buffers reference.
In some languages, built-in datetime utilities do not support nanosecond precision (9 digits).

nextMaintenanceWindowTime

string (date-time)

String in RFC3339 text format. The range of possible values is from
0001-01-01T00:00:00Z to 9999-12-31T23:59:59.999999999Z, i.e. from 0 to 9 digits for fractions of a second.

To work with values in this field, use the APIs described in the
Protocol Buffers reference.
In some languages, built-in datetime utilities do not support nanosecond precision (9 digits).