Contact UsGet started
© 2024 Iron Hive LLC Belgrade

Information about existing Greenplum® clusters

Written by
Updated at October 29, 2024

You can request detailed information about each Managed Service for Greenplum® cluster you created.

Getting a list of clusters in a folder

Go to the folder page and select Managed Service for Greenplum.

If you do not have the Yandex Cloud command line interface yet, install and initialize it.

The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name or --folder-id parameter.

To request a list of Greenplum® clusters in a folder, run the following command:

yc managed-greenplum cluster list

To get a list of DB clusters in a folder, use the list REST API method for the Cluster resource or the ClusterService/List gRPC API call.

Getting detailed information about a cluster

  1. Go to the folder page and select Managed Service for Greenplum.
  2. Click the cluster name.

If you do not have the Yandex Cloud command line interface yet, install and initialize it.

The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name or --folder-id parameter.

To get information about a Greenplum® cluster, run the following command:

yc managed-greenplum cluster get <cluster_name_or_ID>

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

To get cluster details, use the get REST API method for the Cluster resource or the ClusterService/Get gRPC API call and provide the cluster ID in the request.

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

Viewing operations with clusters

All actions with Managed Service for Greenplum® clusters are logged as a list of operations. Each operation is assigned a unique ID.

Getting a list of operations

To get a list of operations for a cluster:

  1. In the management console, open the folder with the cluster.

  2. Select Managed Service for Greenplum.

  3. In the left-hand panel, select Clusters.

  4. Select the cluster you need.

  5. Go to the Operations panel for the selected cluster.

    You will see a list of operations with the selected cluster.

If you do not have the Yandex Cloud command line interface yet, install and initialize it.

The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name or --folder-id parameter.

To get a list of operations for a Managed Service for Greenplum® cluster, run this command:

yc managed-greenplum cluster list-operations <cluster_name_or_ID>

Result:

+----------------------+---------------------+----------------------+---------------------+--------+--------------------------+
|          ID          |     CREATED AT      |      CREATED BY      |     MODIFIED AT     | STATUS |       DESCRIPTION        |
+----------------------+---------------------+----------------------+---------------------+--------+--------------------------+
| dqh0ntf6batm******** | 2024-09-07 16:36:46 | aje9k8luj4qf******** | 2024-09-07 16:44:12 | DONE   | Create Greenplum cluster |
+----------------------+---------------------+----------------------+---------------------+--------+--------------------------+

You can get the cluster ID and name with a list of clusters in the folder.

By default, information about operations is provided as text. To get detailed information, specify the yaml or json output data format using the --format flag:

yc managed-greenplum cluster list-operations c9qk2926qqu9******** --format yaml

Result:

- id: dqh0ntf6batm********
  description: Create Greenplum cluster
  created_at: "2024-09-07T16:36:46.816682Z"
  created_by: aje9k8luj4qf********
  modified_at: "2024-09-07T16:44:12.944302Z"
  done: true
  metadata:
    '@type': type.googleapis.com/yandex.cloud.mdb.greenplum.v1.CreateClusterMetadata
    cluster_id: c9q13q0acgv7********
  response:
    '@type': type.googleapis.com/google.rpc.Status
    message: OK

Use the listOperations REST API method for the Cluster resource or the ClusterService/ListOperations gRPC API call and provide the cluster ID in the request.

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

Getting detailed information about an operation

  1. Get a list of operations for the cluster.

  2. Copy the ID of the operation.

  3. Get detailed information about the operation:

    If you do not have the Yandex Cloud command line interface yet, install and initialize it.

    The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name or --folder-id parameter.

    Run this command:

    yc operation get <operation_ID>

    Result:

    id: dqh0ntf6batm********
description: Create Greenplum cluster
created_at: "2024-09-07T16:36:46.816682Z"
created_by: aje9k8luj4qf********
modified_at: "2024-09-07T16:44:12.944302Z"
done: true
metadata:
  '@type': type.googleapis.com/yandex.cloud.mdb.greenplum.v1.CreateClusterMetadata
  cluster_id: c9q13q0acgv7********
response:
  '@type': type.googleapis.com/yandex.cloud.mdb.greenplum.v1.Cluster
...

    Use the get REST API method for the Operation resource or the OperationService/Get gRPC API call and provide the operation ID in the request.

See also

Greenplum® and Greenplum Database® are registered trademarks or trademarks of VMware, Inc. in the United States and/or other countries.

Previous
All guides
Next
Calculating the cluster configuration