Querying data

Querying data in IBM watsonx.data involves writing and running SQL queries to explore, transform, and summarize your datasets. You can use the Data workbench to query your data.

Data workbench

Data workbench is a tool or user interface that is designed for writing, running, and managing SQL queries across diverse data sources. It provides a unified environment for querying, analyzing, and visualizing data. You can explore datasets, format and run queries, view results, and create visualizations by using a single, interactive workspace.

The Data workbench tool is available only in the watsonx.data experience. To switch between experiences, click the Switch platform icon next to your avatar, and select the experience.

To query data by using the Data workbench:

  1. Log in to the watsonx.data experience.

  2. From your project's Assets page, click New Asset.

  3. Under Data engineering, select the Manage, curate and query data with SQL workbench tile. The Workbench page appears.

  4. Click New worksheet.

  5. Select an engine from the Engine drop-down.

  6. Select the catalog, schema, or table in which you want to run the query.

  7. Click the overflow menu and select the required query.

    • For a catalog and schema, you can run the Generate Path query.
    • For a table, you can run the Generate path and Generate SELECT query.

  8. Click Run script to run the query. The results appear in the Result tab.

  9. Click the Save icon to save the worksheet. A Save worksheet window appears.

  10. Click Save.

Watch the quick video for a visual walkthrough: Querying data.