Hologres:Manage schemas

Create a schema

1. Log on to the Hologres console.

2. In the top navigation bar, select a region from the drop-down list.

3. In the left-side navigation pane of the Hologres console, click Go to HoloWeb to go to the HoloWeb console.

4. In the HoloWeb console, click the Metadata Management tab. On this tab, click Instances Connected in the left-side navigation pane. Click the desired instance, right-click the desired database, and then select Create Schema.

5. Configure Schema Name and click OK. The default value of Instance Name is the name of the instance, and the default value of Database Name is the name of the database. You do not need to modify the configurations.

   The newly created schema is displayed in the database in the left-side navigation pane.

Manage a schema

You can perform multiple operations on a schema, such as refreshing information about the schema, editing the schema, creating internal tables, creating foreign tables mapped to MaxCompute, creating foreign tables mapped to Object Storage Service (OSS), creating views, and deleting the schema.

1. In the HoloWeb console, click the Metadata Management tab. On this tab, click Instances Connected in the left-side navigation pane.

2. Click the desired instance and the desired database. All the created schemas are displayed.

   Note

   After you log on to a database, a schema named public is automatically created.

3. Right-click the desired schema and manage the schema based on your business requirements.

   You can perform the following operations on the schema:

   • Refresh the information about the schema

     After you modify the schema, you can refresh the information about the schema.

   • Edit the schema

     Right-click the schema and select Edit Schema. You can modify only the Schema Name parameter.

   • Create an internal table, create a foreign table mapped to MaxCompute, and create a foreign table mapped to OSS

     Right-click the schema and select the type of the table that you want to create. On the tab that appears, configure the parameters. For more information about how to configure each type of table, see Create a foreign table mapped to MaxCompute.

   • Create a view

     Right-click the schema and select Create View. On the Create View tab, configure the parameters. For more information, see Manage views.

   • Delete the schema

     Right-click the schema and select Delete Schema. In the Delete Schema message, click OK.