Getting information about catalogs in a Managed Service for Trino cluster

If you do not have the Yandex Cloud CLI installed yet, install and initialize it.

By default, the CLI uses the folder specified when creating the profile. To change the default folder, use the yc config set folder-id <folder_ID> command. You can also set a different folder for any specific command using the --folder-name or --folder-id parameter.

To get a list of Trino catalogs in a Managed Service for Trino cluster, run this command:

yc managed-trino catalog list \
    --cluster-id <cluster_ID>

You can request the cluster ID with a list of clusters.

Result:

+----------------------+---------+----------------+---------------+
|          ID          |  NAME   | CONNECTOR TYPE |  DESCRIPTION  |
+----------------------+---------+----------------+---------------+
| c9qimrjgi9os******** | catalog |   postgresql   | Trino catalog |
+----------------------+---------+----------------+---------------+

1. Get an IAM token for API authentication and put it into the environment variable:

   export IAM_TOKEN="<IAM_token>"
   

2. Use the Catalog.List method and send the following request, e.g., via cURL:

   curl \
       --request GET \
       --header "Authorization: Bearer $IAM_TOKEN" \
       --url 'https://trino.api.cloud.yandex.net/managed-trino/v1/clusters/<cluster_ID>/catalogs'
   

   You can request the cluster ID with the list of clusters in the folder.

3. View the server response to make sure the request was successful.

1. Get an IAM token for API authentication and put it into the environment variable:

   export IAM_TOKEN="<IAM_token>"
   

2. Clone the cloudapi repository:

   cd ~/ && git clone --depth=1 https://github.com/yandex-cloud/cloudapi
   

   Below, we assume the repository contents are stored in the ~/cloudapi/ directory.

3. Use the CatalogService.List call and run the following request, e.g., via gRPCurl:

   grpcurl \
       -format json \
       -import-path ~/cloudapi/ \
       -import-path ~/cloudapi/third_party/googleapis/ \
       -proto ~/cloudapi/yandex/cloud/trino/v1/cluster_service.proto \
       -rpc-header "Authorization: Bearer $IAM_TOKEN" \
       -d '{
               "cluster_id": "<cluster_ID>"
           }' \
       trino.api.cloud.yandex.net:443 \
       yandex.cloud.trino.v1.CatalogService.List
   

   You can request the cluster ID with the list of clusters in the folder.

4. View the server response to make sure the request was successful.

If you do not have the Yandex Cloud CLI installed yet, install and initialize it.

By default, the CLI uses the folder specified when creating the profile. To change the default folder, use the yc config set folder-id <folder_ID> command. You can also set a different folder for any specific command using the --folder-name or --folder-id parameter.

To get detailed information about a Trino catalog, run this command:

yc managed-trino catalog get <Trino_catalog_name_or_ID> \
    --cluster-id <cluster_ID>

You can get the Trino catalog ID and name together with the list of Trino catalogs in the cluster.

You can request the cluster ID with a list of clusters.

Result:

id: c9qimrjgi9os********
name: my-catalog
connector:
  postgresql:
    connection:
      connection_manager:
        connection_id: a5968k5e1cpn********
        database: my-db

1. Get an IAM token for API authentication and put it into the environment variable:

   export IAM_TOKEN="<IAM_token>"
   

2. Use the Catalog.Get method and send the following request, e.g., via cURL:

   curl \
       --request GET \
       --header "Authorization: Bearer $IAM_TOKEN" \
       --url 'https://trino.api.cloud.yandex.net/managed-trino/v1/clusters/<cluster_ID>/catalogs/<Trino_catalog_ID>'
   

   You can request the cluster ID with the list of clusters in the folder and the folder ID with the list of Trino catalogs in the cluster.

3. View the server response to make sure the request was successful.

1. Get an IAM token for API authentication and put it into the environment variable:

   export IAM_TOKEN="<IAM_token>"
   

2. Clone the cloudapi repository:

   cd ~/ && git clone --depth=1 https://github.com/yandex-cloud/cloudapi
   

   Below, we assume the repository contents are stored in the ~/cloudapi/ directory.

3. Use the CatalogService.Get call and run the following request, e.g., via gRPCurl:

   grpcurl \
       -format json \
       -import-path ~/cloudapi/ \
       -import-path ~/cloudapi/third_party/googleapis/ \
       -proto ~/cloudapi/yandex/cloud/trino/v1/cluster_service.proto \
       -rpc-header "Authorization: Bearer $IAM_TOKEN" \
       -d '{
               "cluster_id": "<cluster_ID>",
               "catalog_id": "<Trino_folder_ID>"
           }' \
       trino.api.cloud.yandex.net:443 \
       yandex.cloud.trino.v1.CatalogService.Get
   

   You can request the cluster ID with the list of clusters in the folder and the folder ID with the list of Trino catalogs in the cluster.

4. View the server response to make sure the request was successful.