You can generate, configure, and run DDL from the Data manager
page by using the web console.
Procedure
- Log in to watsonx.data
console.
- From the navigation menu, select Data manager.
- Select engine from the Engine menu. Catalogs that are associated
with the selected engine are listed.
- Click Create and select Create table from
file menu.
- 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.
For JSON file, you must
enclose the content in []
.
- Click the data type and choose the required data type for each column. Click
Next.
- In the Target form, select the Engine,
Catalog, and Schema in which the table is
created.
- Enter a name for the table in the Table name field and click
Next.
- Verify the details in the Summary page and scroll down to view the
DDL preview.
- Click Create.
- 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.