A quick tour of the CelerData Cloud Serverless console

This topic walks you through a quick tour of the CelerData Cloud Serverless console, helping you understand what features you can achieve with the console.

Homepage

After signing in to the console, you land on the homepage.

The homepage provides brief descriptions and links to the CelerData services, account details, and private and public query endpoints.

In the lower-left area of the homepage, you can view the following details about the logged-in account:

• Account name: the name of the account.
• Account ID: the ID of the account. The account ID is automatically generated by CelerData and is unique within the organization.
• Provider/region: the cloud provider and region in which your CelerData deployment resides.
• Engine version: the default StarRocks version you are using.
• Created by: the name of the user who created the logged-in account.
• Created at: the date and time when the logged-in account was created.
• Service role ARN: the ARN of the AWS IAM role used for cross-account authentication. You will need it when configuring a trust relationship between your CelerData cloud account and your AWS account. See Create an IAM integration.
• AWS External ID: the external ID used to create an AWS IAM role for cross-account authentication. You will need it when configuring a trust relationship between your CelerData cloud account and your AWS account. See Create an IAM integration.

In the lower-right area of the homepage, you can view the private and public endpoints, and can click Help me connect to obtain information about how to connect your client application to the logged-in account. See Connect via MySQL client. By default, the public query endpoint is displayed.

SQL Editor

The console provides a SQL Editor with which you can perform ad-hoc SQL debugging without integrating with local IDEs.

In the SQL Editor, you must select a catalog and a database on the Data explorer tab in the left-side pane and a running warehouse in the upper-right corner before executing SQL queries. See Run queries using SQL Editor and Manage warehouses.

After compiling and running a SQL query, you can view the return result in the lower area of the page. CelerData saves all SQL queries you have run, and you can view them on the Saved queries tab in the left-side pane.

Catalog

The Catalog page provides an overview of all catalogs, including the internal catalog default_catalog and all external catalogs you have created within the logged-in account. You can use these catalogs to view both internal and external data, or connect your client application with the console to run queries against the data.

You can also create more external catalogs on this page.

For each catalog, you can click it to view the databases within it, and then click a database to view the tables, materialized views, and views within that database. CelerData does not support other data objects. For details, see Organize data objects.

Integration

The Integration page provides an overview of client applications that can be integrated with CelerData. Note that CelerData supports more applications than listed on the console. Theoretically, CelerData supports integration with all MySQL-compatible client applications.

NOTE

The Streaming API is supported only in Premium Edition. For differences between the features supported by Standard Edition and Premium Edition, see Feature comparison.

You can click an application to learn how to integrate the application with CelerData.

You can also refer to this page if you need to know how to perform across-account authentication using AWS IAM.

Activities

By default, the Activities page displays all SQL queries run within the logged-in account and the query profiles. You can filter the queries by SQL statement, user, query status, warehouse, and time range.

Based on the query details, you can audit the SQL queries, identify slow SQL queries, and analyze the reasons causing slow SQL queries.

Warehouse

The Warehouse page provides an overview of all warehouses (including default_warehouse) within the logged-in account. Warehouses are compute resources in your CelerData cloud. For details, see Overview of warehouses.

You can manage the warehouses as needed. For example, you can suspend, resume, delete, scale, and set Idle on Suspend for a warehouse. You can also create more warehouses on this page. Currently, CelerData supports managing warehouses only through the console. You cannot manage warehouses by using SQL statements. For details, see Manage warehouses.

User&Role

The User&Role page displays all users and roles within the logged-in account:

• On the Users tab, you can create new users and manage existing users. For example, you can reset a user's password, delete a user, and grant or revoke roles and privileges for a user.
• On the Roles tab, you can create new roles and manage existing roles. For example, you can grant or revoke privileges and other roles for a role and can grant or revoke a role for users.

This is the implementation of role-based access control (RBAC) in CelerData. You need to create roles, define privileges for each role, and then grant different roles to different users to achieve access control. For details, see Manage user privileges.

NOTICE

A new role can take effect only after it is activated. You need to click your user profile in the upper-right corner of the console and choose Activated roles settings to activate a new role.

Usage&Billing

The Usage&billing page consists of two tabs:

• If you have logged in by using the root account, you can view two sections: Overview and Usage.
  • The Overview tab displays the payment type, the CelerData edition, and the monthly resource consumption of one or all accounts within the organization. You can edit the payment type if needed.
  • The Usage tab displays the compute resource usage of all accounts within the organization as a summary and in graphs or listed details. You can filter the usage by account, warehouse, time range, and time granularity (hour, day, or month). You can also download the usage data as a CSV file to your computer.
• If you have logged in by using a common account, you can view only the Usage tab, which displays the compute resource usage of the logged-in account as a summary and in graphs or listed details. You can filter the usage by warehouse, time range, and time granularity (hour, day, or month). You can also download the usage data as a CSV file to your computer.

For details, see Understand usage and billing.

Org&Account

The Account&Org page is displayed only when you have logged in by using the root account of the organization. It provides an overview of the organization and all accounts created within the organization (note that accounts that are deleted will not be displayed here). You can create and delete accounts as needed.

For more information about organization and accounts, see Organization and account.

Security settings

The Security settings page consists of three tabs:

• Audit log: records all user operations that are not SQL-based within the logged-in account. You can filter the log records by object type, user, and time range.
• Private link: displays the VPC endpoints with which you can connect to different AWS accounts and VPCs. You can also create new VPC endpoints. For details, see Connect to CelerData Cloud Serverless with a Private Link.
• Firewall: displays the firewall rules applied to the logged-in account. By default, the query endpoint of the logged-in account is accessible from all IP addresses on public networks. If you want to limit the IP addresses from which the logged-in account is accessible, you can create rules to whitelist only the authorized IP addresses. For details, see IP Firewall.

Edition and menu options

In the lower-left corner, the console displays the CelerData edition you are using and provides menu options for you to expand or collapse the menu items in the navigation pane.

Help documentation and user profile

In the upper-right corner, the console provides two capabilities:

• Help documentation: You can click the Help documentation icon to go to CelerData Cloud Serverless documentation.
• User profile: You can click the user profile icon to view and manage your user profile and role status settings, switch to another account, and log out.