[Документация Yandex Cloud](../../../../index.md) > [Yandex Managed Service for Trino](../../../index.md) > Справочник API > [gRPC (англ.)](../index.md) > [Cluster](index.md) > Create # Managed Service for Trino API, gRPC: ClusterService.Create Creates a Trino Cluster resource. ## gRPC request **rpc Create ([CreateClusterRequest](#yandex.cloud.trino.v1.CreateClusterRequest)) returns ([operation.Operation](#yandex.cloud.operation.Operation))** ## CreateClusterRequest {#yandex.cloud.trino.v1.CreateClusterRequest} ```json { "folder_id": "string", "name": "string", "description": "string", "labels": "map", "trino": { "catalogs": [ { "name": "string", "connector": { // Includes only one of the fields `hive`, `iceberg`, `delta_lake`, `postgresql`, `clickhouse`, `tpch`, `tpcds`, `oracle`, `sqlserver`, `hudi`, `mysql`, `greenplum` "hive": { "metastore": { // Includes only one of the fields `hive`, `rest` "hive": { // Includes only one of the fields `uri`, `managed_cluster_id` "uri": "string", "managed_cluster_id": "string", // end of the list of possible fields "protocol": { // Includes only one of the fields `thrift`, `rest` "thrift": "Thrift", "rest": "IcebergRest" // end of the list of possible fields } }, "rest": { "uri": "string", "authorization": { // Includes only one of the fields `none` "none": "NoneAuth" // end of the list of possible fields } } // end of the list of possible fields }, "filesystem": { // Includes only one of the fields `s3`, `external_s3` "s3": "S3FileSystem", "external_s3": { "aws_access_key": "string", "aws_secret_key": "string", "aws_endpoint": "string", "aws_region": "string" } // end of the list of possible fields }, "additional_properties": "map" }, "iceberg": { "metastore": { // Includes only one of the fields `hive`, `rest` "hive": { // Includes only one of the fields `uri`, `managed_cluster_id` "uri": "string", "managed_cluster_id": "string", // end of the list of possible fields "protocol": { // Includes only one of the fields `thrift`, `rest` "thrift": "Thrift", "rest": "IcebergRest" // end of the list of possible fields } }, "rest": { "uri": "string", "authorization": { // Includes only one of the fields `none` "none": "NoneAuth" // end of the list of possible fields } } // end of the list of possible fields }, "filesystem": { // Includes only one of the fields `s3`, `external_s3` "s3": "S3FileSystem", "external_s3": { "aws_access_key": "string", "aws_secret_key": "string", "aws_endpoint": "string", "aws_region": "string" } // end of the list of possible fields }, "additional_properties": "map" }, "delta_lake": { "metastore": { // Includes only one of the fields `hive`, `rest` "hive": { // Includes only one of the fields `uri`, `managed_cluster_id` "uri": "string", "managed_cluster_id": "string", // end of the list of possible fields "protocol": { // Includes only one of the fields `thrift`, `rest` "thrift": "Thrift", "rest": "IcebergRest" // end of the list of possible fields } }, "rest": { "uri": "string", "authorization": { // Includes only one of the fields `none` "none": "NoneAuth" // end of the list of possible fields } } // end of the list of possible fields }, "filesystem": { // Includes only one of the fields `s3`, `external_s3` "s3": "S3FileSystem", "external_s3": { "aws_access_key": "string", "aws_secret_key": "string", "aws_endpoint": "string", "aws_region": "string" } // end of the list of possible fields }, "additional_properties": "map" }, "postgresql": { "connection": { // Includes only one of the fields `on_premise`, `connection_manager` "on_premise": { "connection_url": "string", "user_name": "string", "password": "string" }, "connection_manager": { "connection_id": "string", "database": "string", "connection_properties": "map" } // end of the list of possible fields }, "additional_properties": "map" }, "clickhouse": { "connection": { // Includes only one of the fields `on_premise`, `connection_manager` "on_premise": { "connection_url": "string", "user_name": "string", "password": "string" }, "connection_manager": { "connection_id": "string", "database": "string", "connection_properties": "map" } // end of the list of possible fields }, "additional_properties": "map" }, "tpch": { "additional_properties": "map" }, "tpcds": { "additional_properties": "map" }, "oracle": { "connection": { // Includes only one of the fields `on_premise` "on_premise": { "connection_url": "string", "user_name": "string", "password": "string" } // end of the list of possible fields }, "additional_properties": "map" }, "sqlserver": { "connection": { // Includes only one of the fields `on_premise` "on_premise": { "connection_url": "string", "user_name": "string", "password": "string" } // end of the list of possible fields }, "additional_properties": "map" }, "hudi": { "metastore": { // Includes only one of the fields `hive`, `rest` "hive": { // Includes only one of the fields `uri`, `managed_cluster_id` "uri": "string", "managed_cluster_id": "string", // end of the list of possible fields "protocol": { // Includes only one of the fields `thrift`, `rest` "thrift": "Thrift", "rest": "IcebergRest" // end of the list of possible fields } }, "rest": { "uri": "string", "authorization": { // Includes only one of the fields `none` "none": "NoneAuth" // end of the list of possible fields } } // end of the list of possible fields }, "filesystem": { // Includes only one of the fields `s3`, `external_s3` "s3": "S3FileSystem", "external_s3": { "aws_access_key": "string", "aws_secret_key": "string", "aws_endpoint": "string", "aws_region": "string" } // end of the list of possible fields }, "additional_properties": "map" }, "mysql": { "connection": { // Includes only one of the fields `on_premise`, `connection_manager` "on_premise": { "connection_url": "string", "user_name": "string", "password": "string" }, "connection_manager": { "connection_id": "string", "connection_properties": "map" } // end of the list of possible fields }, "additional_properties": "map" }, "greenplum": { "connection": { // Includes only one of the fields `on_premise`, `connection_manager` "on_premise": { "connection_url": "string", "user_name": "string", "password": "string" }, "connection_manager": { "connection_id": "string", "database": "string", "connection_properties": "map" } // end of the list of possible fields }, "additional_properties": "map" } // end of the list of possible fields }, "description": "string", "labels": "map" } ], "coordinator_config": { "resources": { "resource_preset_id": "string" } }, "worker_config": { "resources": { "resource_preset_id": "string" }, "scale_policy": { // Includes only one of the fields `fixed_scale`, `auto_scale` "fixed_scale": { "count": "int64" }, "auto_scale": { "min_count": "int64", "max_count": "int64" } // end of the list of possible fields } }, "retry_policy": { "policy": "RetryPolicy", "exchange_manager": { "additional_properties": "map", "storage": { // Includes only one of the fields `service_s3`, `s3` "service_s3": "ServiceS3", "s3": { "bucket": "string" } // end of the list of possible fields } }, "additional_properties": "map" }, "version": "string", "access_control": { "catalogs": [ { "users": [ "string" ], "groups": [ "string" ], "catalog": { // Includes only one of the fields `name_regexp`, `ids`, `names` "name_regexp": "string", "ids": { "any": [ "string" ] }, "names": { "any": [ "string" ] } // end of the list of possible fields }, "permission": "Permission", "description": "string" } ], "schemas": [ { "users": [ "string" ], "groups": [ "string" ], "catalog": { // Includes only one of the fields `name_regexp`, `ids`, `names` "name_regexp": "string", "ids": { "any": [ "string" ] }, "names": { "any": [ "string" ] } // end of the list of possible fields }, "schema": { // Includes only one of the fields `name_regexp`, `names` "name_regexp": "string", "names": { "any": [ "string" ] } // end of the list of possible fields }, "owner": "Owner", "description": "string" } ], "tables": [ { "users": [ "string" ], "groups": [ "string" ], "catalog": { // Includes only one of the fields `name_regexp`, `ids`, `names` "name_regexp": "string", "ids": { "any": [ "string" ] }, "names": { "any": [ "string" ] } // end of the list of possible fields }, "schema": { // Includes only one of the fields `name_regexp`, `names` "name_regexp": "string", "names": { "any": [ "string" ] } // end of the list of possible fields }, "table": { // Includes only one of the fields `name_regexp`, `names` "name_regexp": "string", "names": { "any": [ "string" ] } // end of the list of possible fields }, "privileges": [ "Privilege" ], "columns": [ { "name": "string", "access": "AccessMode", "mask": "string" } ], "filter": "string", "description": "string" } ], "functions": [ { "users": [ "string" ], "groups": [ "string" ], "catalog": { // Includes only one of the fields `name_regexp`, `ids`, `names` "name_regexp": "string", "ids": { "any": [ "string" ] }, "names": { "any": [ "string" ] } // end of the list of possible fields }, "schema": { // Includes only one of the fields `name_regexp`, `names` "name_regexp": "string", "names": { "any": [ "string" ] } // end of the list of possible fields }, "function": { // Includes only one of the fields `name_regexp`, `names` "name_regexp": "string", "names": { "any": [ "string" ] } // end of the list of possible fields }, "privileges": [ "Privilege" ], "description": "string" } ], "procedures": [ { "users": [ "string" ], "groups": [ "string" ], "catalog": { // Includes only one of the fields `name_regexp`, `ids`, `names` "name_regexp": "string", "ids": { "any": [ "string" ] }, "names": { "any": [ "string" ] } // end of the list of possible fields }, "schema": { // Includes only one of the fields `name_regexp`, `names` "name_regexp": "string", "names": { "any": [ "string" ] } // end of the list of possible fields }, "procedure": { // Includes only one of the fields `name_regexp`, `names` "name_regexp": "string", "names": { "any": [ "string" ] } // end of the list of possible fields }, "privileges": [ "Privilege" ], "description": "string" } ], "queries": [ { "users": [ "string" ], "groups": [ "string" ], "query_owners": [ "string" ], "privileges": [ "Privilege" ], "description": "string" } ], "system_session_properties": [ { "users": [ "string" ], "groups": [ "string" ], "property": { // Includes only one of the fields `name_regexp`, `names` "name_regexp": "string", "names": { "any": [ "string" ] } // end of the list of possible fields }, "allow": "Allow", "description": "string" } ], "catalog_session_properties": [ { "users": [ "string" ], "groups": [ "string" ], "catalog": { // Includes only one of the fields `name_regexp`, `ids`, `names` "name_regexp": "string", "ids": { "any": [ "string" ] }, "names": { "any": [ "string" ] } // end of the list of possible fields }, "property": { // Includes only one of the fields `name_regexp`, `names` "name_regexp": "string", "names": { "any": [ "string" ] } // end of the list of possible fields }, "allow": "Allow", "description": "string" } ] }, "resource_management": { "resource_groups": { "root_groups": [ { "name": "string", "max_queued": "int64", "soft_concurrency_limit": "int64", "hard_concurrency_limit": "int64", "soft_memory_limit": "string", "soft_cpu_limit": "string", "hard_cpu_limit": "string", "scheduling_policy": "SchedulingPolicy", "scheduling_weight": "int64", "sub_groups": [ "ResourceGroupConfig" ] } ], "selectors": [ { "user": "string", "user_group": "string", "source": "string", "query_type": "QueryType", "client_tags": [ "string" ], "group": "string" } ], "cpu_quota_period": "string" }, "query": { "properties": "map" } }, "tls": { "trusted_certificates": [ "string" ] } }, "network": { "subnet_ids": [ "string" ], "security_group_ids": [ "string" ], "private_access": { "enabled": "bool" } }, "deletion_protection": "bool", "service_account_id": "string", "logging": { // Includes only one of the fields `folder_id`, `log_group_id` "folder_id": "string", "log_group_id": "string", // end of the list of possible fields "enabled": "bool", "min_level": "Level" }, "maintenance_window": { // Includes only one of the fields `anytime`, `weekly_maintenance_window` "anytime": "AnytimeMaintenanceWindow", "weekly_maintenance_window": { "day": "WeekDay", "hour": "int64" } // end of the list of possible fields } } ``` #| ||Field | Description || || folder_id | **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"}. The maximum string length in characters for each value is 63. The string length in characters for each key must be 1-63. Each key must match the regular expression ` [a-z][-_0-9a-z]* `. Each value must match the regular expression ` [-_0-9a-z]* `. No more than 64 per resource. || || trino | **[TrinoConfigSpec](#yandex.cloud.trino.v1.TrinoConfigSpec)** Required field. Configuration of Trino components. || || network | **[NetworkConfig](#yandex.cloud.trino.v1.NetworkConfig)** Required field. Network related configuration options. || || deletion_protection | **bool** Deletion Protection inhibits deletion of the cluster. || || service_account_id | **string** Required field. Service account used to access Cloud resources. The maximum string length in characters is 50. || || logging | **[LoggingConfig](#yandex.cloud.trino.v1.LoggingConfig)** Cloud logging configuration. || || maintenance_window | **[MaintenanceWindow](#yandex.cloud.trino.v1.MaintenanceWindow)** Window of maintenance operations. || |# ## TrinoConfigSpec {#yandex.cloud.trino.v1.TrinoConfigSpec} #| ||Field | Description || || catalogs[] | **[CatalogSpec](#yandex.cloud.trino.v1.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. || || coordinator_config | **[CoordinatorConfig](#yandex.cloud.trino.v1.CoordinatorConfig)** Required field. Configuration for the coordinator, specifying computational resources and other settings. || || worker_config | **[WorkerConfig](#yandex.cloud.trino.v1.WorkerConfig)** Required field. Configuration for worker nodes, including scaling policy and computational resources. || || retry_policy | **[RetryPolicyConfig](#yandex.cloud.trino.v1.RetryPolicyConfig)** Configuration for retry policy, specifying the spooling storage destination and other settings. || || version | **string** Trino version. Format: "Number". || || access_control | **[AccessControlConfig](#yandex.cloud.trino.v1.AccessControlConfig)** Configuration for access control, specifying the fine-grained access rules. || || resource_management | **[ResourceManagementConfig](#yandex.cloud.trino.v1.ResourceManagementConfig)** Configuration for cluster resource management, specifying the resource groups. || || tls | **[TLSConfig](#yandex.cloud.trino.v1.TLSConfig)** Configuration for TLS. || |# ## CatalogSpec {#yandex.cloud.trino.v1.CatalogSpec} CatalogSpec defines the desired state of a new catalog. #| ||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-z]([a-z0-9_-]*[a-z0-9])? `. || || connector | **[Connector](#yandex.cloud.trino.v1.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. The maximum string length in characters for each value is 63. The string length in characters for each key must be 1-63. Each key must match the regular expression ` [a-z][-_0-9a-z]* `. Each value must match the regular expression ` [-_0-9a-z]* `. No more than 64 per resource. || |# ## Connector {#yandex.cloud.trino.v1.Connector} Connector configuration. Exactly one connector type must be specified. #| ||Field | Description || || hive | **[HiveConnector](#yandex.cloud.trino.v1.HiveConnector)** Hive connector configuration. Includes only one of the fields `hive`, `iceberg`, `delta_lake`, `postgresql`, `clickhouse`, `tpch`, `tpcds`, `oracle`, `sqlserver`, `hudi`, `mysql`, `greenplum`. || || iceberg | **[IcebergConnector](#yandex.cloud.trino.v1.IcebergConnector)** Iceberg connector configuration. Includes only one of the fields `hive`, `iceberg`, `delta_lake`, `postgresql`, `clickhouse`, `tpch`, `tpcds`, `oracle`, `sqlserver`, `hudi`, `mysql`, `greenplum`. || || delta_lake | **[DeltaLakeConnector](#yandex.cloud.trino.v1.DeltaLakeConnector)** Delta Lake connector configuration. Includes only one of the fields `hive`, `iceberg`, `delta_lake`, `postgresql`, `clickhouse`, `tpch`, `tpcds`, `oracle`, `sqlserver`, `hudi`, `mysql`, `greenplum`. || || postgresql | **[PostgresqlConnector](#yandex.cloud.trino.v1.PostgresqlConnector)** PostgreSQL connector configuration. Includes only one of the fields `hive`, `iceberg`, `delta_lake`, `postgresql`, `clickhouse`, `tpch`, `tpcds`, `oracle`, `sqlserver`, `hudi`, `mysql`, `greenplum`. || || clickhouse | **[ClickhouseConnector](#yandex.cloud.trino.v1.ClickhouseConnector)** ClickHouse connector configuration. Includes only one of the fields `hive`, `iceberg`, `delta_lake`, `postgresql`, `clickhouse`, `tpch`, `tpcds`, `oracle`, `sqlserver`, `hudi`, `mysql`, `greenplum`. || || tpch | **[TPCHConnector](#yandex.cloud.trino.v1.TPCHConnector)** TPC-H connector for synthetic benchmarking. Includes only one of the fields `hive`, `iceberg`, `delta_lake`, `postgresql`, `clickhouse`, `tpch`, `tpcds`, `oracle`, `sqlserver`, `hudi`, `mysql`, `greenplum`. || || tpcds | **[TPCDSConnector](#yandex.cloud.trino.v1.TPCDSConnector)** TPC-DS connector for synthetic benchmarking. Includes only one of the fields `hive`, `iceberg`, `delta_lake`, `postgresql`, `clickhouse`, `tpch`, `tpcds`, `oracle`, `sqlserver`, `hudi`, `mysql`, `greenplum`. || || oracle | **[OracleConnector](#yandex.cloud.trino.v1.OracleConnector)** Oracle connector configuration for connecting to Oracle Database instances. Includes only one of the fields `hive`, `iceberg`, `delta_lake`, `postgresql`, `clickhouse`, `tpch`, `tpcds`, `oracle`, `sqlserver`, `hudi`, `mysql`, `greenplum`. || || sqlserver | **[SQLServerConnector](#yandex.cloud.trino.v1.SQLServerConnector)** SQLServer connector configuration for connecting to SQLServer Database instances. Includes only one of the fields `hive`, `iceberg`, `delta_lake`, `postgresql`, `clickhouse`, `tpch`, `tpcds`, `oracle`, `sqlserver`, `hudi`, `mysql`, `greenplum`. || || hudi | **[HudiConnector](#yandex.cloud.trino.v1.HudiConnector)** Hudi connector configuration. Includes only one of the fields `hive`, `iceberg`, `delta_lake`, `postgresql`, `clickhouse`, `tpch`, `tpcds`, `oracle`, `sqlserver`, `hudi`, `mysql`, `greenplum`. || || mysql | **[MysqlConnector](#yandex.cloud.trino.v1.MysqlConnector)** MySQL connector configuration for connecting to MySQL Database instances. Includes only one of the fields `hive`, `iceberg`, `delta_lake`, `postgresql`, `clickhouse`, `tpch`, `tpcds`, `oracle`, `sqlserver`, `hudi`, `mysql`, `greenplum`. || || greenplum | **[GreenplumConnector](#yandex.cloud.trino.v1.GreenplumConnector)** Greenplum connector configuration for connecting to Greenplum or Cloudberry Database instances. Includes only one of the fields `hive`, `iceberg`, `delta_lake`, `postgresql`, `clickhouse`, `tpch`, `tpcds`, `oracle`, `sqlserver`, `hudi`, `mysql`, `greenplum`. || |# ## HiveConnector {#yandex.cloud.trino.v1.HiveConnector} #| ||Field | Description || || metastore | **[Metastore](#yandex.cloud.trino.v1.Metastore)** Required field. Metastore configuration. || || filesystem | **[FileSystem](#yandex.cloud.trino.v1.FileSystem)** Required field. File system configuration. || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || |# ## Metastore {#yandex.cloud.trino.v1.Metastore} Metastore configuration. #| ||Field | Description || || hive | **[HiveMetastore](#yandex.cloud.trino.v1.Metastore.HiveMetastore)** Apache Hive Metastore. Includes only one of the fields `hive`, `rest`. || || rest | **[RestMetastore](#yandex.cloud.trino.v1.Metastore.RestMetastore)** Iceberg REST Catalog compatible Metastore. Includes only one of the fields `hive`, `rest`. || |# ## HiveMetastore {#yandex.cloud.trino.v1.Metastore.HiveMetastore} Configuration of Hive's metastore type. #| ||Field | Description || || uri | **string** URI of the Hive Metastore. Includes only one of the fields `uri`, `managed_cluster_id`. || || managed_cluster_id | **string** ID of the Managed Hive Metastore cluster. Includes only one of the fields `uri`, `managed_cluster_id`. || || protocol | **[Protocol](#yandex.cloud.trino.v1.Metastore.HiveMetastore.Protocol)** Hive metastore client protocol. If null, thrift protocol will be used. || |# ## Protocol {#yandex.cloud.trino.v1.Metastore.HiveMetastore.Protocol} Hive Metastore client protocol configuration. #| ||Field | Description || || thrift | **[Thrift](#yandex.cloud.trino.v1.Metastore.HiveMetastore.Protocol.Thrift)** Thrift client protocol. Includes only one of the fields `thrift`, `rest`. || || rest | **[IcebergRest](#yandex.cloud.trino.v1.Metastore.HiveMetastore.Protocol.IcebergRest)** Iceberg REST client protocol. Includes only one of the fields `thrift`, `rest`. || |# ## Thrift {#yandex.cloud.trino.v1.Metastore.HiveMetastore.Protocol.Thrift} Thrift client protocol configuration. #| ||Field | Description || || Empty | > || |# ## IcebergRest {#yandex.cloud.trino.v1.Metastore.HiveMetastore.Protocol.IcebergRest} Iceberg REST client protocol configuration. #| ||Field | Description || || Empty | > || |# ## RestMetastore {#yandex.cloud.trino.v1.Metastore.RestMetastore} Configuration of Iceberg REST Catalog compatible metastore type. #| ||Field | Description || || uri | **string** URI of the REST Catalog metastore. || || authorization | **[Authorization](#yandex.cloud.trino.v1.Metastore.RestMetastore.Authorization)** Authorization properties. || |# ## Authorization {#yandex.cloud.trino.v1.Metastore.RestMetastore.Authorization} #| ||Field | Description || || none | **[NoneAuth](#yandex.cloud.trino.v1.Metastore.RestMetastore.Authorization.NoneAuth)** Disabled authorization Includes only one of the fields `none`. || |# ## NoneAuth {#yandex.cloud.trino.v1.Metastore.RestMetastore.Authorization.NoneAuth} None authorization. #| ||Field | Description || || Empty | > || |# ## FileSystem {#yandex.cloud.trino.v1.FileSystem} Configuration of file system used by a connector. #| ||Field | Description || || s3 | **[S3FileSystem](#yandex.cloud.trino.v1.FileSystem.S3FileSystem)** Yandex Cloud S3 filesystem. Includes only one of the fields `s3`, `external_s3`. || || external_s3 | **[ExternalS3FileSystem](#yandex.cloud.trino.v1.FileSystem.ExternalS3FileSystem)** External S3 filesystem. Includes only one of the fields `s3`, `external_s3`. || |# ## S3FileSystem {#yandex.cloud.trino.v1.FileSystem.S3FileSystem} Describes YandexCloud native S3 file system. Currently does not require configuration. #| ||Field | Description || || Empty | > || |# ## ExternalS3FileSystem {#yandex.cloud.trino.v1.FileSystem.ExternalS3FileSystem} Describes External S3 compatible file system. #| ||Field | Description || || aws_access_key | **string** Required field. AWS access key. || || aws_secret_key | **string** Required field. AWS secret key. || || aws_endpoint | **string** Required field. AWS endpoint. Value must match the regular expression ` ^https?://.+$ `. || || aws_region | **string** Required field. AWS region. || |# ## IcebergConnector {#yandex.cloud.trino.v1.IcebergConnector} #| ||Field | Description || || metastore | **[Metastore](#yandex.cloud.trino.v1.Metastore)** Required field. Metastore configuration. || || filesystem | **[FileSystem](#yandex.cloud.trino.v1.FileSystem)** Required field. File system configuration. || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || |# ## DeltaLakeConnector {#yandex.cloud.trino.v1.DeltaLakeConnector} #| ||Field | Description || || metastore | **[Metastore](#yandex.cloud.trino.v1.Metastore)** Required field. Metastore configuration. || || filesystem | **[FileSystem](#yandex.cloud.trino.v1.FileSystem)** Required field. File system configuration. || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || |# ## PostgresqlConnector {#yandex.cloud.trino.v1.PostgresqlConnector} #| ||Field | Description || || connection | **[PostgresqlConnection](#yandex.cloud.trino.v1.PostgresqlConnection)** Connection configuration. || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || |# ## PostgresqlConnection {#yandex.cloud.trino.v1.PostgresqlConnection} #| ||Field | Description || || on_premise | **[OnPremise](#yandex.cloud.trino.v1.PostgresqlConnection.OnPremise)** Connection configured manually. Includes only one of the fields `on_premise`, `connection_manager`. || || connection_manager | **[ConnectionManager](#yandex.cloud.trino.v1.PostgresqlConnection.ConnectionManager)** Connection configured using Yandex Cloud Connection Manager. Includes only one of the fields `on_premise`, `connection_manager`. || |# ## OnPremise {#yandex.cloud.trino.v1.PostgresqlConnection.OnPremise} #| ||Field | Description || || connection_url | **string** Required field. Connection to the Postgresql. Value must match the regular expression ` ^jdbc:postgresql://(?:.+:\d+)/(?:.*)$ `. || || user_name | **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. || |# ## ConnectionManager {#yandex.cloud.trino.v1.PostgresqlConnection.ConnectionManager} #| ||Field | Description || || connection_id | **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_-]* `. || || connection_properties | **object** (map<**string**, **string**>) Additional connection properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-zA-Z]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_]* `. No more than 256 per resource. || |# ## ClickhouseConnector {#yandex.cloud.trino.v1.ClickhouseConnector} #| ||Field | Description || || connection | **[ClickhouseConnection](#yandex.cloud.trino.v1.ClickhouseConnection)** Connection configuration. || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || |# ## ClickhouseConnection {#yandex.cloud.trino.v1.ClickhouseConnection} #| ||Field | Description || || on_premise | **[OnPremise](#yandex.cloud.trino.v1.ClickhouseConnection.OnPremise)** Connection configured manually. Includes only one of the fields `on_premise`, `connection_manager`. || || connection_manager | **[ConnectionManager](#yandex.cloud.trino.v1.ClickhouseConnection.ConnectionManager)** Connection configured using Yandex Cloud Connection Manager. Includes only one of the fields `on_premise`, `connection_manager`. || |# ## OnPremise {#yandex.cloud.trino.v1.ClickhouseConnection.OnPremise} #| ||Field | Description || || connection_url | **string** Required field. Connection to the Clickhouse. Value must match the regular expression ` ^jdbc:clickhouse://(?:.+:\d+)/(?:.*)$ `. || || user_name | **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. || |# ## ConnectionManager {#yandex.cloud.trino.v1.ClickhouseConnection.ConnectionManager} #| ||Field | Description || || connection_id | **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_-]* `. || || connection_properties | **object** (map<**string**, **string**>) Additional connection properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-zA-Z_]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_]* `. No more than 256 per resource. || |# ## TPCHConnector {#yandex.cloud.trino.v1.TPCHConnector} #| ||Field | Description || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || |# ## TPCDSConnector {#yandex.cloud.trino.v1.TPCDSConnector} #| ||Field | Description || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || |# ## OracleConnector {#yandex.cloud.trino.v1.OracleConnector} #| ||Field | Description || || connection | **[OracleConnection](#yandex.cloud.trino.v1.OracleConnection)** Connection configuration. || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || |# ## OracleConnection {#yandex.cloud.trino.v1.OracleConnection} #| ||Field | Description || || on_premise | **[OnPremise](#yandex.cloud.trino.v1.OracleConnection.OnPremise)** Connection configured manually. Includes only one of the fields `on_premise`. || |# ## OnPremise {#yandex.cloud.trino.v1.OracleConnection.OnPremise} #| ||Field | Description || || connection_url | **string** Required field. Connection to the Oracle. Value must match the regular expression ` ^jdbc:oracle:(?s:.*)$ `. || || user_name | **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. || |# ## SQLServerConnector {#yandex.cloud.trino.v1.SQLServerConnector} #| ||Field | Description || || connection | **[SQLServerConnection](#yandex.cloud.trino.v1.SQLServerConnection)** Connection configuration. || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || |# ## SQLServerConnection {#yandex.cloud.trino.v1.SQLServerConnection} #| ||Field | Description || || on_premise | **[OnPremise](#yandex.cloud.trino.v1.SQLServerConnection.OnPremise)** Connection configured manually. Includes only one of the fields `on_premise`. || |# ## OnPremise {#yandex.cloud.trino.v1.SQLServerConnection.OnPremise} #| ||Field | Description || || connection_url | **string** Required field. Connection to the SQLServer. Value must match the regular expression ` ^jdbc:sqlserver:(?s:.*)$ `. || || user_name | **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. || |# ## HudiConnector {#yandex.cloud.trino.v1.HudiConnector} #| ||Field | Description || || metastore | **[Metastore](#yandex.cloud.trino.v1.Metastore)** Required field. Metastore configuration. || || filesystem | **[FileSystem](#yandex.cloud.trino.v1.FileSystem)** Required field. File system configuration. || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || |# ## MysqlConnector {#yandex.cloud.trino.v1.MysqlConnector} #| ||Field | Description || || connection | **[MysqlConnection](#yandex.cloud.trino.v1.MysqlConnection)** Connection configuration. || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || |# ## MysqlConnection {#yandex.cloud.trino.v1.MysqlConnection} #| ||Field | Description || || on_premise | **[OnPremise](#yandex.cloud.trino.v1.MysqlConnection.OnPremise)** Connection configured manually. Includes only one of the fields `on_premise`, `connection_manager`. || || connection_manager | **[ConnectionManager](#yandex.cloud.trino.v1.MysqlConnection.ConnectionManager)** Connection configured using Yandex Cloud Connection Manager. Includes only one of the fields `on_premise`, `connection_manager`. || |# ## OnPremise {#yandex.cloud.trino.v1.MysqlConnection.OnPremise} #| ||Field | Description || || connection_url | **string** Required field. Connection to the MySQL. Value must match the regular expression ` ^jdbc:mysql://(?:.+:\d+)(?:/?.*)$ `. || || user_name | **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. || |# ## ConnectionManager {#yandex.cloud.trino.v1.MysqlConnection.ConnectionManager} #| ||Field | Description || || connection_id | **string** Required field. Connection ID. The string length in characters must be 1-50. || || connection_properties | **object** (map<**string**, **string**>) Additional connection properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-zA-Z_]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_]* `. No more than 256 per resource. || |# ## GreenplumConnector {#yandex.cloud.trino.v1.GreenplumConnector} #| ||Field | Description || || connection | **[GreenplumConnection](#yandex.cloud.trino.v1.GreenplumConnection)** Connection configuration || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || |# ## GreenplumConnection {#yandex.cloud.trino.v1.GreenplumConnection} #| ||Field | Description || || on_premise | **[OnPremise](#yandex.cloud.trino.v1.GreenplumConnection.OnPremise)** Connection configured manually. Includes only one of the fields `on_premise`, `connection_manager`. || || connection_manager | **[ConnectionManager](#yandex.cloud.trino.v1.GreenplumConnection.ConnectionManager)** Connection configured using Yandex Cloud Connection Manager. Includes only one of the fields `on_premise`, `connection_manager`. || |# ## OnPremise {#yandex.cloud.trino.v1.GreenplumConnection.OnPremise} #| ||Field | Description || || connection_url | **string** Required field. Connection to the Greenplum/Cloudberry. Value must match the regular expression ` ^jdbc:postgresql://(?:.+:\d+)/(?:.*)$ `. || || user_name | **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. || |# ## ConnectionManager {#yandex.cloud.trino.v1.GreenplumConnection.ConnectionManager} #| ||Field | Description || || connection_id | **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_-]* `. || || connection_properties | **object** (map<**string**, **string**>) Additional connection properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-zA-Z]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_]* `. No more than 256 per resource. || |# ## CoordinatorConfig {#yandex.cloud.trino.v1.CoordinatorConfig} #| ||Field | Description || || resources | **[Resources](#yandex.cloud.trino.v1.Resources)** Required field. Configuration for computational resources assigned to the coordinator instance. || |# ## Resources {#yandex.cloud.trino.v1.Resources} #| ||Field | Description || || resource_preset_id | **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. || |# ## WorkerConfig {#yandex.cloud.trino.v1.WorkerConfig} #| ||Field | Description || || resources | **[Resources](#yandex.cloud.trino.v1.Resources)** Required field. Configuration for computational resources for worker instances. || || scale_policy | **[WorkerScalePolicy](#yandex.cloud.trino.v1.WorkerConfig.WorkerScalePolicy)** Required field. Configuration for scaling policy for worker instances. || |# ## WorkerScalePolicy {#yandex.cloud.trino.v1.WorkerConfig.WorkerScalePolicy} #| ||Field | Description || || fixed_scale | **[FixedScalePolicy](#yandex.cloud.trino.v1.FixedScalePolicy)** A fixed scaling policy that specifies a fixed number of worker instances. Includes only one of the fields `fixed_scale`, `auto_scale`. Defines the scaling type for worker instances. Only one type of scaling can be specified at a time. || || auto_scale | **[AutoScalePolicy](#yandex.cloud.trino.v1.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 `fixed_scale`, `auto_scale`. Defines the scaling type for worker instances. Only one type of scaling can be specified at a time. || |# ## FixedScalePolicy {#yandex.cloud.trino.v1.FixedScalePolicy} #| ||Field | Description || || count | **int64** Specifies the number of worker instances. Acceptable values are 1 to 512, inclusive. || |# ## AutoScalePolicy {#yandex.cloud.trino.v1.AutoScalePolicy} #| ||Field | Description || || min_count | **int64** Minimum number of worker instances. Acceptable values are 0 to 512, inclusive. || || max_count | **int64** Maximum number of worker instances. Acceptable values are 1 to 512, inclusive. || |# ## RetryPolicyConfig {#yandex.cloud.trino.v1.RetryPolicyConfig} #| ||Field | Description || || policy | enum **RetryPolicy** Retry policy level. - `QUERY`: Retry policy for queries. - `TASK`: Retry policy for tasks. || || exchange_manager | **[ExchangeManagerConfig](#yandex.cloud.trino.v1.ExchangeManagerConfig)** Configuration for exchange manager. || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || |# ## ExchangeManagerConfig {#yandex.cloud.trino.v1.ExchangeManagerConfig} #| ||Field | Description || || additional_properties | **object** (map<**string**, **string**>) Additional properties. The maximum string length in characters for each value is 128. The string length in characters for each key must be 1-128. Each key must match the regular expression ` [a-z][-_0-9a-z.]* `. Each value must match the regular expression ` [-_0-9a-zA-Z.,:\/_ *]* `. No more than 256 per resource. || || storage | **[ExchangeManagerStorage](#yandex.cloud.trino.v1.ExchangeManagerStorage)** Storage for spooled data by exchange manager. || |# ## ExchangeManagerStorage {#yandex.cloud.trino.v1.ExchangeManagerStorage} #| ||Field | Description || || service_s3 | **[ServiceS3](#yandex.cloud.trino.v1.ExchangeManagerStorage.ServiceS3)** Use a service side S3 bucket for exchange manager. Includes only one of the fields `service_s3`, `s3`. || || s3 | **[S3](#yandex.cloud.trino.v1.ExchangeManagerStorage.S3)** Use an S3 bucket for exchange manager. Includes only one of the fields `service_s3`, `s3`. || |# ## ServiceS3 {#yandex.cloud.trino.v1.ExchangeManagerStorage.ServiceS3} #| ||Field | Description || || Empty | > || |# ## S3 {#yandex.cloud.trino.v1.ExchangeManagerStorage.S3} #| ||Field | Description || || bucket | **string** Required field. Name of the bucket to be used as the spool destination for exchange manager. || |# ## AccessControlConfig {#yandex.cloud.trino.v1.AccessControlConfig} #| ||Field | Description || || catalogs[] | **[CatalogAccessRule](#yandex.cloud.trino.v1.CatalogAccessRule)** Catalog access control rules. || || schemas[] | **[SchemaAccessRule](#yandex.cloud.trino.v1.SchemaAccessRule)** Schema access control rules. || || tables[] | **[TableAccessRule](#yandex.cloud.trino.v1.TableAccessRule)** Table access control rules. || || functions[] | **[FunctionAccessRule](#yandex.cloud.trino.v1.FunctionAccessRule)** Function access control rules. || || procedures[] | **[ProcedureAccessRule](#yandex.cloud.trino.v1.ProcedureAccessRule)** Procedures access control rules. || || queries[] | **[QueryAccessRule](#yandex.cloud.trino.v1.QueryAccessRule)** Queries access control rules. || || system_session_properties[] | **[SystemSessionPropertyAccessRule](#yandex.cloud.trino.v1.SystemSessionPropertyAccessRule)** System session property access control rules. || || catalog_session_properties[] | **[CatalogSessionPropertyAccessRule](#yandex.cloud.trino.v1.CatalogSessionPropertyAccessRule)** Catalog session property access control rules. || |# ## CatalogAccessRule {#yandex.cloud.trino.v1.CatalogAccessRule} #| ||Field | Description || || users[] | **string** IAM user IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || groups[] | **string** IAM group IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || catalog | **[CatalogAccessRuleMatcher](#yandex.cloud.trino.v1.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. || |# ## CatalogAccessRuleMatcher {#yandex.cloud.trino.v1.CatalogAccessRuleMatcher} #| ||Field | Description || || name_regexp | **string** Catalog name regexp the rule is applied to. The maximum string length in characters is 256. Includes only one of the fields `name_regexp`, `ids`, `names`. || || ids | **[CatalogIds](#yandex.cloud.trino.v1.CatalogAccessRuleMatcher.CatalogIds)** Catalog IDs rule is applied to. Includes only one of the fields `name_regexp`, `ids`, `names`. || || names | **[CatalogNames](#yandex.cloud.trino.v1.CatalogAccessRuleMatcher.CatalogNames)** Catalog names rule is applied to. Includes only one of the fields `name_regexp`, `ids`, `names`. || |# ## CatalogIds {#yandex.cloud.trino.v1.CatalogAccessRuleMatcher.CatalogIds} #| ||Field | Description || || any[] | **string** List of table names. The rule will be applied if a table name is within this list. The maximum string length in characters for each value is 63. The maximum number of elements is 128. || |# ## CatalogNames {#yandex.cloud.trino.v1.CatalogAccessRuleMatcher.CatalogNames} #| ||Field | Description || || any[] | **string** List of catalog names. The rule will be applied if a catalog name is within this list. The maximum string length in characters for each value is 63. The maximum number of elements is 128. || |# ## SchemaAccessRule {#yandex.cloud.trino.v1.SchemaAccessRule} #| ||Field | Description || || users[] | **string** IAM user IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || groups[] | **string** IAM group IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || catalog | **[CatalogAccessRuleMatcher](#yandex.cloud.trino.v1.CatalogAccessRuleMatcher)** Catalog matcher specifying what catalogs the rule is applied to. || || schema | **[SchemaAccessRuleMatcher](#yandex.cloud.trino.v1.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. || |# ## SchemaAccessRuleMatcher {#yandex.cloud.trino.v1.SchemaAccessRuleMatcher} #| ||Field | Description || || name_regexp | **string** Schema name regexp the rule is applied to. The maximum string length in characters is 256. Includes only one of the fields `name_regexp`, `names`. || || names | **[SchemaNames](#yandex.cloud.trino.v1.SchemaAccessRuleMatcher.SchemaNames)** Schema names the rule is applied to. Includes only one of the fields `name_regexp`, `names`. || |# ## SchemaNames {#yandex.cloud.trino.v1.SchemaAccessRuleMatcher.SchemaNames} #| ||Field | Description || || any[] | **string** List of schema names. The rule will be applied if a schema name is within this list. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [a-z0-9_-]+ `. The maximum number of elements is 128. || |# ## TableAccessRule {#yandex.cloud.trino.v1.TableAccessRule} #| ||Field | Description || || users[] | **string** IAM user IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || groups[] | **string** IAM group IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || catalog | **[CatalogAccessRuleMatcher](#yandex.cloud.trino.v1.CatalogAccessRuleMatcher)** Catalog matcher specifying what catalogs the rule is applied to. || || schema | **[SchemaAccessRuleMatcher](#yandex.cloud.trino.v1.SchemaAccessRuleMatcher)** Schema matcher specifying what schemas the rule is applied to. || || table | **[TableAccessRuleMatcher](#yandex.cloud.trino.v1.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](#yandex.cloud.trino.v1.TableAccessRule.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. || |# ## TableAccessRuleMatcher {#yandex.cloud.trino.v1.TableAccessRuleMatcher} #| ||Field | Description || || name_regexp | **string** Table name regexp the rule is applied to. The maximum string length in characters is 256. Includes only one of the fields `name_regexp`, `names`. || || names | **[TableNames](#yandex.cloud.trino.v1.TableAccessRuleMatcher.TableNames)** Table names the rule is applied to. Includes only one of the fields `name_regexp`, `names`. || |# ## TableNames {#yandex.cloud.trino.v1.TableAccessRuleMatcher.TableNames} #| ||Field | Description || || any[] | **string** List of table names. The rule will be applied if a table name is within this list. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [a-z0-9_-]+ `. The maximum number of elements is 128. || |# ## Column {#yandex.cloud.trino.v1.TableAccessRule.Column} #| ||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. || |# ## FunctionAccessRule {#yandex.cloud.trino.v1.FunctionAccessRule} #| ||Field | Description || || users[] | **string** IAM user IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || groups[] | **string** IAM group IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || catalog | **[CatalogAccessRuleMatcher](#yandex.cloud.trino.v1.CatalogAccessRuleMatcher)** Catalog matcher specifying what catalogs the rule is applied to. || || schema | **[SchemaAccessRuleMatcher](#yandex.cloud.trino.v1.SchemaAccessRuleMatcher)** Schema matcher specifying what schema the rule is applied to. || || function | **[FunctionAccessRuleMatcher](#yandex.cloud.trino.v1.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. || |# ## FunctionAccessRuleMatcher {#yandex.cloud.trino.v1.FunctionAccessRuleMatcher} #| ||Field | Description || || name_regexp | **string** Function name regexp the rule is applied to. The maximum string length in characters is 256. Includes only one of the fields `name_regexp`, `names`. || || names | **[FunctionNames](#yandex.cloud.trino.v1.FunctionAccessRuleMatcher.FunctionNames)** Function names the rule is applied to. Includes only one of the fields `name_regexp`, `names`. || |# ## FunctionNames {#yandex.cloud.trino.v1.FunctionAccessRuleMatcher.FunctionNames} #| ||Field | Description || || any[] | **string** List of function names. The rule will be applied if a function name is within this list. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [a-z0-9_-]+ `. The maximum number of elements is 128. || |# ## ProcedureAccessRule {#yandex.cloud.trino.v1.ProcedureAccessRule} #| ||Field | Description || || users[] | **string** IAM user IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || groups[] | **string** IAM group IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || catalog | **[CatalogAccessRuleMatcher](#yandex.cloud.trino.v1.CatalogAccessRuleMatcher)** Catalog matcher specifying what catalogs the rule is applied to. || || schema | **[SchemaAccessRuleMatcher](#yandex.cloud.trino.v1.SchemaAccessRuleMatcher)** Schema matcher specifying what schema the rule is applied to. || || procedure | **[ProcedureAccessRuleMatcher](#yandex.cloud.trino.v1.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. || |# ## ProcedureAccessRuleMatcher {#yandex.cloud.trino.v1.ProcedureAccessRuleMatcher} #| ||Field | Description || || name_regexp | **string** Procedure name regexp the rule is applied to. The maximum string length in characters is 256. Includes only one of the fields `name_regexp`, `names`. || || names | **[ProcedureNames](#yandex.cloud.trino.v1.ProcedureAccessRuleMatcher.ProcedureNames)** Procedure names the rule is applied to. Includes only one of the fields `name_regexp`, `names`. || |# ## ProcedureNames {#yandex.cloud.trino.v1.ProcedureAccessRuleMatcher.ProcedureNames} #| ||Field | Description || || any[] | **string** List of procedure names. The rule will be applied if a procedure name is within this list. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [a-z0-9_-]+ `. The maximum number of elements is 128. || |# ## QueryAccessRule {#yandex.cloud.trino.v1.QueryAccessRule} #| ||Field | Description || || users[] | **string** IAM user IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || groups[] | **string** IAM group IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || query_owners[] | **string** Owners of queries the rule is applied to. Cannot be combined with EXECUTE privilege. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || 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. || |# ## SystemSessionPropertyAccessRule {#yandex.cloud.trino.v1.SystemSessionPropertyAccessRule} #| ||Field | Description || || users[] | **string** IAM user IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || groups[] | **string** IAM group IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || property | **[PropertyAccessRuleMatcher](#yandex.cloud.trino.v1.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. || |# ## PropertyAccessRuleMatcher {#yandex.cloud.trino.v1.PropertyAccessRuleMatcher} #| ||Field | Description || || name_regexp | **string** Property name regexp the rule is applied to. The maximum string length in characters is 256. Includes only one of the fields `name_regexp`, `names`. || || names | **[PropertyNames](#yandex.cloud.trino.v1.PropertyAccessRuleMatcher.PropertyNames)** Property names the rule is applied to. Includes only one of the fields `name_regexp`, `names`. || |# ## PropertyNames {#yandex.cloud.trino.v1.PropertyAccessRuleMatcher.PropertyNames} #| ||Field | Description || || any[] | **string** List of property names. The rule will be applied if a property name is within this list. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [a-z_]+ `. The maximum number of elements is 128. || |# ## CatalogSessionPropertyAccessRule {#yandex.cloud.trino.v1.CatalogSessionPropertyAccessRule} #| ||Field | Description || || users[] | **string** IAM user IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || groups[] | **string** IAM group IDs the rule is applied to. The maximum string length in characters for each value is 63. Each value must match the regular expression ` [-_0-9a-z]+ `. The maximum number of elements is 128. || || catalog | **[CatalogAccessRuleMatcher](#yandex.cloud.trino.v1.CatalogAccessRuleMatcher)** Catalog matcher specifying what catalogs the rule is applied to. || || property | **[PropertyAccessRuleMatcher](#yandex.cloud.trino.v1.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. || |# ## ResourceManagementConfig {#yandex.cloud.trino.v1.ResourceManagementConfig} #| ||Field | Description || || resource_groups | **[ResourceGroupsConfig](#yandex.cloud.trino.v1.ResourceGroupsConfig)** Resource groups configuration. || || query | **[QueryConfig](#yandex.cloud.trino.v1.QueryConfig)** Query management confiugration. || |# ## ResourceGroupsConfig {#yandex.cloud.trino.v1.ResourceGroupsConfig} #| ||Field | Description || || root_groups[] | **[ResourceGroupConfig](#yandex.cloud.trino.v1.ResourceGroupConfig)** Root resource groups configuration. The number of elements must be greater than 0. || || selectors[] | **[SelectorRuleConfig](#yandex.cloud.trino.v1.SelectorRuleConfig)** Selector rules for routing queries to resource groups. The number of elements must be greater than 0. || || cpu_quota_period | **string** Period for CPU quota calculations. || |# ## ResourceGroupConfig {#yandex.cloud.trino.v1.ResourceGroupConfig} #| ||Field | Description || || name | **string** Required field. Resource group name. || || max_queued | **int64** Maximum number of queued queries. Value must be greater than 0. || || soft_concurrency_limit | **int64** Number of concurrently running queries after which new queries only run if peer groups are below soft limits. || || hard_concurrency_limit | **int64** Maximum number of queries that can run concurrently. Value must be greater than 0. || || soft_memory_limit | **string** Maximum amount of distributed memory this group can use. || || soft_cpu_limit | **string** Maximum CPU time per period this group can use before applying penalty to running queries (requires hard_cpu_limit). || || hard_cpu_limit | **string** Maximum CPU time per period this group can use. || || scheduling_policy | 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. || || scheduling_weight | **int64** Weight for weighted and weighted_fair scheduling policies. || || sub_groups[] | **[ResourceGroupConfig](#yandex.cloud.trino.v1.ResourceGroupConfig)** List of sub-groups. || |# ## SelectorRuleConfig {#yandex.cloud.trino.v1.SelectorRuleConfig} #| ||Field | Description || || user | **string** Regex to match against username. || || user_group | **string** Regex to match against user groups. || || source | **string** Regex to match against query source. || || query_type | enum **QueryType** Type of query to match. - `SELECT`: SELECT query. - `EXPLAIN`: EXPLAIN query. - `DESCRIBE`: DESCRIBE query. - `INSERT`: INSERT query. - `UPDATE`: UPDATE query. - `MERGE`: MERGE query. - `DELETE`: DELECT query. - `ANALYZE`: ANALYZE query. - `DATA_DEFINITION`: Data definition query. - `ALTER_TABLE_EXECUTE`: ALTER TABLE EXECUTE query. || || client_tags[] | **string** Tags that must all be present in the query's client tags. || || group | **string** Required field. Target resource group name. || |# ## QueryConfig {#yandex.cloud.trino.v1.QueryConfig} #| ||Field | Description || || properties | **object** (map<**string**, **string**>) Query properties. || |# ## TLSConfig {#yandex.cloud.trino.v1.TLSConfig} #| ||Field | Description || || trusted_certificates[] | **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 string length in characters for each value is 8192. The maximum number of elements is 8. || |# ## NetworkConfig {#yandex.cloud.trino.v1.NetworkConfig} #| ||Field | Description || || subnet_ids[] | **string** IDs of VPC network subnets where instances of the cluster are attached. || || security_group_ids[] | **string** User security groups. || || private_access | **[PrivateAccessConfig](#yandex.cloud.trino.v1.PrivateAccessConfig)** Private link configuration for secure connectivity to the cluster. || |# ## PrivateAccessConfig {#yandex.cloud.trino.v1.PrivateAccessConfig} #| ||Field | Description || || enabled | **bool** Enables access to the cluster only via private endpoint. || |# ## LoggingConfig {#yandex.cloud.trino.v1.LoggingConfig} #| ||Field | Description || || folder_id | **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 `folder_id`, `log_group_id`. Destination of log records. || || log_group_id | **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 `folder_id`, `log_group_id`. Destination of log records. || || enabled | **bool** Logs generated by the Trino components are delivered to Cloud Logging. || || min_level | enum **Level** Minimum log entry level. See [LogLevel.Level](../../../../logging/api-ref/grpc/Export/get.md#yandex.cloud.logging.v1.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. || |# ## MaintenanceWindow {#yandex.cloud.trino.v1.MaintenanceWindow} #| ||Field | Description || || anytime | **[AnytimeMaintenanceWindow](#yandex.cloud.trino.v1.AnytimeMaintenanceWindow)** The cluster may be restarted for maintenance at any time. Includes only one of the fields `anytime`, `weekly_maintenance_window`. || || weekly_maintenance_window | **[WeeklyMaintenanceWindow](#yandex.cloud.trino.v1.WeeklyMaintenanceWindow)** Maintenance is allowed only within the specified weekly window. Includes only one of the fields `anytime`, `weekly_maintenance_window`. || |# ## AnytimeMaintenanceWindow {#yandex.cloud.trino.v1.AnytimeMaintenanceWindow} #| ||Field | Description || || Empty | > || |# ## WeeklyMaintenanceWindow {#yandex.cloud.trino.v1.WeeklyMaintenanceWindow} #| ||Field | Description || || day | enum **WeekDay** Day of the week when maintenance can occur. - `MON`: Monday. - `TUE`: Tuesday. - `WED`: Wednesday. - `THU`: Thursday. - `FRI`: Friday. - `SAT`: Saturday. - `SUN`: Sunday. || || hour | **int64** Hour of the day in UTC when the maintenance window starts. Acceptable values are 1 to 24, inclusive. || |# ## operation.Operation {#yandex.cloud.operation.Operation} ```json { "id": "string", "description": "string", "created_at": "google.protobuf.Timestamp", "created_by": "string", "modified_at": "google.protobuf.Timestamp", "done": "bool", "metadata": "google.protobuf.Any", // Includes only one of the fields `error`, `response` "error": "google.rpc.Status", "response": "google.protobuf.Any" // end of the list of possible fields } ``` An Operation resource. For more information, see [Operation](../../../../api-design-guide/concepts/operation.md). #| ||Field | Description || || id | **string** ID of the operation. || || description | **string** Description of the operation. 0-256 characters long. || || created_at | **[google.protobuf.Timestamp](https://developers.google.com/protocol-buffers/docs/reference/google.protobuf#timestamp)** Creation timestamp. || || created_by | **string** ID of the user or service account who initiated the operation. || || modified_at | **[google.protobuf.Timestamp](https://developers.google.com/protocol-buffers/docs/reference/google.protobuf#timestamp)** The time when the Operation resource was last modified. || || done | **bool** 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 | **[google.protobuf.Any](https://developers.google.com/protocol-buffers/docs/proto3#any)** 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 | **[google.rpc.Status](https://cloud.google.com/tasks/docs/reference/rpc/google.rpc#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 | **[google.protobuf.Any](https://developers.google.com/protocol-buffers/docs/proto3#any)** 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](https://developers.google.com/protocol-buffers/docs/reference/google.protobuf#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. || |#