Creating schemas using the web console

You can create schema from the Data manager page by using the web console.

watsonx.data Developer edition

watsonx.data on IBM Software Hub

Before you begin

  • You must have at minimum a User access with data access policy for catalogs. See Data policy.

Procedure

  1. Log in to IBM watsonx.data console.
  2. From the navigation menu, select Data manager, click Browse data.
  3. Select the engine from the Engine drop-down. Catalogs that are associated with the selected engine are listed.
  4. There are two ways to create a schema. Select the required option:
    Option 1: To create a schema under any catalog, do the following steps:
    1. Click Create.
    2. Click Create schema. The Create schema page opens.
    3. Go to step 5.
    Option 2: To create a schema under a particular catalog, do the following steps:
    1. Select a catalog where you want to create a schema.
    2. Click the overflow menu of the selected catalog and select Create schema. The Create schema page opens.
    3. Go to step 5.
  5. In the Create schema form, provide the following details:
    • Select the catalog
    • Enter the schema name.
      Important: Schema naming guidelines:
      • Do not wrap the schema name in quotation marks. (Example: Use test instead of “test”.)
      • Do not use semicolon [;], colon [:], single quotation mark ['], or double quotation mark ["] in the schema name.
      • Do not use leading space in the schema name.
    • Enter the schema path. For example, /test1/schema1.
  6. Click Create. The schema is created under the selected catalog.