Skip to main content

View CelerData clusters

CelerData displays all of the clusters created within your CelerData cloud account on its console. You can get an overview of all clusters or dive down into the details of each individual cluster.

Get an overview of all clusters

Sign in to the CelerData Cloud BYOC console.

The Clusters page appears, presenting an overview of all clusters created within your CelerData cloud account. The overview includes the cloud provider region, creation time, status, and type (classic or elastic) of each individual cluster.

Clusters page

View the details of a cluster

Sign in to the CelerData Cloud BYOC console, and on the Clusters page click the cluster that you want to view. Then the cluster details page that consists of the following tabs appears:

  • Overview
  • Warehouses (This tab is displayed only for elastic clusters.)
  • Cloud Settings
  • Resource Scheduling
  • Deployments

Overview

The Overview tab consists of three sections: Cluster properties, Connection, and Cluster size.

View Clusters - Overview

The Cluster properties section displays the basic information of the cluster, including the following properties.

PropertyDescription
Cluster nameThe name of the cluster.
Cloud providerThe cloud provider that hosts the cluster.
RegionThe region that hosts the cluster.
Cluster typeThe type (classic or elastic) of the cluster.
VersionThe version of CelerData that is run by the cluster.
Created byThe name of the CelerData cloud user who created the cluster.
StatusThe status of the cluster. Valid values:
  • Failed: The cluster failed to be deployed.
  • Running: The cluster is running.
  • Stopped: The cluster has been released.
  • Updating: The configuration of the cluster is being changed.
  • Deploying: The cluster is being deployed.
Created atThe time at which the cluster was created.

The Connection section displays the information that you can use to connect to the cluster, including the following properties.

PropertyDescription
EndpointThe endpoint that is used to connect to the cluster.
Query portThe port that is used to connect to the cluster. The port is the query_port of the cluster.

The Cluster size section displays the size information of the cluster, including the following properties.

PropertyDescription
FE node countThe number of FE nodes in the cluster.
FE node typeThe instance type of the FE nodes in the cluster.
FE storage typeThe storage type of the FE nodes in the cluster.
BE node countThe number of BE nodes in the cluster.
BE node typeThe instance type of the BE nodes in the cluster.
BE storage typeThe storage type of the BE nodes in the cluster.

In addition to the preceding three sections, the Overview tab also displays the following information:

  • The number of CCUs per hour
  • The used storage and the total storage
  • The size of delta data for today and the size of delta data for yesterday

Warehouses

The Warehouses tab is displayed only for elastic clusters. On this tab, you can:

  • Create new warehouses.

  • View and manage existing warehouses.

Create new warehouses

Follow these steps to create a warehouse:

  1. Click Create warehouse.

  2. In the dialog box that appears, enter a name and optionally a description for the warehouse, select the instance type and number of compute node for the warehouse, and then click Create.

    CelerData immediately starts deploying the warehouse, during which the warehouse stays in the Deploying state. This may take a few minutes. After deploying the warehouse is complete, the warehouse enters the Running state.

View and manage existing warehouses

You can view all warehouses created within the cluster. Each warehouse is presented as a card which displays the following warehouse information:

  • Status
  • Size
  • Disk usage
  • Compute resource usage over the most recent seven days

You can also manage these warehouses, including:

  • Click Quick suspend or Quick resume in the lower-left corner of the card for a warehouse to suspend or resume the warehouse.

    NOTE

    The Quick suspend or Quick resume button is displayed only when the cluster is in the Running state. Additionally, you can suspend and resume only the warehouses that you create after the cluster deployment. You cannot suspend or resume the default warehouse that is created along with the cluster.

  • Move the cursor to the lower-right corner of the card for a warehouse to display the View more details button. Click the button to open the warehouse details page on which you can manage the warehouse as needed. For more information, see Manage warehouses.

View Clusters - Warehouses

Cloud Settings

The Cloud Settings tab consists of three sections: Deployment credential, Network configuration, and Data credential. The information in these sections varies depending on the cloud provider of the cluster.

AWS

The Deployment credential section displays the information about the deployment credential that is associated with the cluster, including the following properties.

PropertyDescription
Credential methodThe type of deployment credential that was used to control the permissions of CelerData to launch and manage resources in your AWS cloud.
Trust account IDThe account ID that you used to create the IAM role associated with the cluster.
NOTE
The trust account ID and the external ID are used together to identify the account that can use the IAM role.
External IDThe external ID that you used to create the IAM role associated with the cluster.
NOTE
The trust account ID and the external ID are used together to identify the account that can use the IAM role.
IAM role ARNThe ARN of the IAM role that you created to grant CelerData permission to launch and manage resources in your AWS cloud.

The Network configuration section displays the information about the network configuration that is associated with the cluster, including the following properties.

PropertyDescription
Subnet IDThe ID of the subnet in which the cluster nodes are deployed for data analysis.
Security group IDThe ID of the security group that enables connectivity between cluster nodes within your own VPC and between CelerData's VPC and your own VPC over TLS.
VPC endpoint IDThe ID of the VPC endpoint that you created by using PrivateLink to allow direct, secure connectivity between CelerData's VPC and your own VPC. The connectivity is for AWS VPCs in the same AWS region. Valid values:
  • For the Asia Pacific (Singapore) region: com.amazonaws.vpce.ap-southeast-1.vpce-svc-02073213663648027
  • For the US East (N. Virginia) region: com.amazonaws.vpce.us-east-1.vpce-svc-0d1c58972a96cb283
NOTE
A VPC endpoint ID is displayed only when you have configured one for the cluster during the deployment process.

The Data credential section displays the information about the data credential that is associated with the cluster, including the following properties.

PropertyDescription
Bucket nameThe name of the bucket that is referenced in the data credential.
Instance profile ARNThe instance profile ARN of the service IAM role for EC2 that you created to grant CelerData permission to access the referenced bucket.

Azure

The Deployment credential section displays the information about the deployment credential that is associated with the cluster, including the following properties.

PropertyDescription
Directory (tenant) IDThe directory (tenant) ID of the registered application.
Application (client) IDThe application (client) ID of the registered application.
Client secret valueThe value of the client secret of the registered application.
SSH Key resource IDThe resource ID of the SSH key pair.
Updated atThe most recent date and time when the client secret value in the deployment credential was updated.

The Network configuration section displays the information about the network configuration that is associated with the cluster, including the following properties.

PropertyDescription
Virtual network resource IDThe resource ID of the virtual network.
Subnet nameThe name of the subnet that hosts the cluster within the virtual network.

The Data credential section displays the information about the data credential that is associated with the cluster, including the following properties.

PropertyDescription
Managed identity resource IDThe resource ID of the managed identity.
Storage account nameThe name of the storage account.
Container nameThe name of the container that stores the data of the cluster within the storage account.

Resource Scheduling

On the Resource Scheduling tab, you can:

  • View and manage the Auto Suspend feature.

  • View and manage scheduling policies.

View Clusters - Resource Scheduling

View and manage the Auto Suspend feature

In the Auto suspend on idle section, you can view the setting of the Auto Suspend feature, including the following properties.

PropertyDescription
Auto suspend on idleThe status of the Auto Suspend feature. Valid values: Enabled and Disabled.
Idle suspend after (min)The maximum amount of time during which the cluster can stay idle.

You can click Edit in the upper-right area of the Auto suspend on idle section to edit the setting of the Auto Suspend feature.

For more information about the Auto Suspend feature, see Auto suspend on idle.

View and manage scheduling policies

In the Scheduling policy section, you can view the information about the scheduling policies that are created on the cluster, including the following properties.

NOTE

Scheduling policies are supported only for classic clusters.

PropertyDescription
Policy nameThe name of the scheduling policy.
Active daysThe week days on which you want the cluster to be on.
Active timeThe period of time during which you want the cluster to be on.
Time zoneThe time zone of the scheduling policy.
Latest runThe most recent date and time at which the cluster was run according to the scheduling policy.
EnabledThe status of the scheduling policy. You can click the switch to enable or disable the policy.
ActionThe actions that you can take on the scheduling policy. Currently you can only delete the policy.

You can click Create scheduling policy in the upper-right area of the Scheduling policy section to create a scheduling policy. You can also click a scheduling policy to edit it.

For more information about scheduled suspend and scheduled resume, see Scheduled suspend and Scheduled resume.

Deployments

On the Deployments tab, you can:

  • Track cluster events.

  • View cluster nodes.

Track cluster events

Click View cluster event in the upper-right area of the tab. A dialog box is displayed, showing all operations that were performed on the cluster. You can click OK to close the dialog box.

View cluster nodes

The node information displayed varies depending on the type (classic or elastic) of the cluster.

For a classic cluster, the Deployments tab displays the information about the FE nodes and BE nodes in the cluster, including the following properties.

PropertyDescription
Node hostThe IP address of the FE or BE node in the cluster.
Node sizeThe instance type of the FE or BE node in the cluster.
StatusThe status of the FE or BE node in the cluster. Valid values:
  • Unknown: The FE or BE node is disconnected.
  • Running: The FE or BE node is running.
  • Terminated: The FE or BE node is manually terminated.
  • Failed: The FE or BE node failed to start.
vCPU (core)The number of vCPU cores provided by the FE or BE node in the cluster.
Memory (GB)The amount of memory provided by the FE or BE node in the cluster.
Volume countThe number of volumes provided by the FE or BE node in the cluster.
Volume size (GB)The size per volume provided by the FE or BE node in the cluster.

View Clusters - Deployments - Classic cluster

For an elastic cluster, the Deployments tab displays the information about the coordinator nodes and the compute nodes of each warehouse in the cluster, including the following properties.

PropertyDescription
Node hostThe IP address of the coordinator or compute node in the cluster.
Node sizeThe instance type of the coordinator or compute node in the cluster.
StatusThe status of the coordinator or compute node in the cluster. Valid values:
  • Unknown: The coordinator or compute node is disconnected.
  • Running: The coordinator or compute node is running.
  • Terminated: The coordinator or compute node is manually terminated.
  • Failed: The coordinator or compute node failed to start.
vCPU (core)The number of vCPU cores provided by the coordinator or compute node in the cluster.
Memory (GB)The amount of memory provided by the coordinator or compute node in the cluster.
Volume size (GB)The size per volume provided by the coordinator or compute node in the cluster.

View Clusters - Deployments - Elastic cluster

What's next

With the connection information you have obtained from the cluster details page, you can connect to the cluster from a JDBC driver or a MySQL client or by using the SQL Editor. For more information, see Connect to a CelerData cluster.

You can also operate the cluster to your needs in the CelerData Cloud BYOC console: