Creating tables

You can generate, configure, and run DDL from the Data manager page by using the web console.

IBM watsonx.data stand-alone

IBM watsonx.data developer edition

Procedure

  1. Log in to IBM® watsonx.data console.
  2. From the navigation menu, select Data manager.
  3. Select engine from the Engine menu. Catalogs that are associated with the selected engine are listed.
  4. There are two ways to import a file into a table. Select the required option:
    Option 1: To import file to any available schema under a catalog, do the following steps:
    1. Click Create drop-down.
    2. Click Create table from file. The Create table from a file page opens.
    3. Go to step 5.
    Option 2: To import file to a particular schema under the catalog, do the following steps:
    1. Select a schema under a catalog where you want to import a file to create table.
    2. Click the overflow menu of the selected schema and select Create table from a file. The Create table from a file page opens.
    3. Go to step 5.
  5. In the Create table from file form, drag a file to the box or click to upload.
    Note: CSV, Parquet, JSON, TXT are the supported data file formats.

    The default file format for Hive is ORC and for Iceberg is Parquet.

    For JSON file, you must enclose the content in [].

    Use a comma (,) for the delimiter when you create table from a data file . Comma (,) is the only supported delimiter.

  6. Click the data type and choose the required data type for each column. Click Next.
  7. In the Target form, select the Engine, Catalog, and Schema in which the table is created.
  8. Enter a name for the table in the Table name field and click Next. Do not use special character such as question mark (?) or asterisk (*) in table or column name.
  9. Verify the details in the Summary page and scroll down to view the DDL preview.
  10. Click Create.
  11. Go to the Data manager page and select the schema under which you created the table and click the refresh icon. The newly created table is listed.