About Data manager

The Data manager page in IBM® watsonx.data is the entry point for you to browse the schemas and tables by engine. You can select an Engine by selecting the Browse data tab in the Data manager page to view the associated catalogs, schemas, and tables. You can search for tables that are loaded under the engine.

watsonx.data Developer edition

watsonx.data on Red Hat® OpenShift®

From the Data manager page, you can create new schemas and tables by using the Create option. You can also select a catalog or schema, click the overflow menu, and use the corresponding Create option to create a schema or table. Create table from file option in the overflow menu of schema is also used to ingest a data file into watsonx.data. Similarly, schemas and tables can be dropped from the catalogs.

Note: Wait for a few minutes to view the changes after a schema or table is dropped.

You can Ingest data from the Data manager page.

Other tasks that can be performed in the Data manager page include adding, renaming, or dropping a column.

Note: You must add PostgreSQL and MySQL to watsonx.data network to browse the PostgreSQL database from your own PostgreSQL container (not IBM-LH-PostgreSQL) using watsonx.data Data Manager.

You can browse the Table schema and up to 10 rows of Data sample for some tables. You can view the Time travel snapshots and use the Rollback feature to rollback or rollforward to any snapshots for Iceberg tables.

watsonx.data provides pre-defined Sample and benchmarking data, such as tpch and tpcds, to test the performance of a database system under controlled conditions. It also provides System monitoring data that uses jmx and system metrics to collect data about the system's health and performance during benchmark testing to understand how the system responds to the workload. Sample and benchmarking data, tpch and tpcds can only be queried using the Presto engines.

Related API: For information on related API, see