Use the database

This topic describes how to connect to and use a database in a Flagship Edition cluster instance.

Prerequisites

• You have created a Flagship Edition cluster instance. For more information, see Create a cluster instance.
• You have created a tenant. For more information, see Create a tenant.
• You have completed the application and network configurations, such as configuring a public endpoint allowlist and outbound rules or a private endpoint.

Create an account

Before connecting to the database, you must create a database account:

1. Log in to the OceanBase Cloud console.

2. In the left-side navigation pane, click Instances.

3. In the instance list, find the target Flagship Edition cluster instance and click its name to enter the cluster instance workspace.

4. In the left-side navigation pane, click Tenants.

5. Find the target tenant and click its name to enter the tenant workspace.

6. In the left-side navigation pane, click Accounts.

7. Click Create Account and specify the account name, password, authorized database, and other information.

8. Click Create to complete the account creation.

Import and query data

1. On the instance list page, click the instance name to go to the instance workspace. Click the More icon next to the instance, and then click Load Sample Data. Under Benchmarking, select the TPC-H sample dataset and the database that you created, and then click Import.

2. Go to the SQL Console page.

3. Select the account you created and enter the password to log in. Click OK.

4. The information_schema database is opened by default. In the database list on the left, click the database that you created, such as default_database, to open a new SQL window.

5. Execute the following SQL statement to view customers in the customer table.

   SELECT * FROM customer;
   

6. Click to execute the SQL statement. The Execution Records tab displays all customer information from the customer table.

7. Execute the following SQL statement to filter customers based on specific conditions. For example, generate a list of customers whose birthday month is December.

   SELECT *
   FROM customer
   WHERE c_birth_month = '12';
   

8. Click to execute the SQL statement. The corresponding results are displayed on the Execution Records tab.

   You can enter different SQL statements at any time to develop and use the database through the SQL console.