Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at


Hitachi Vantara Lumada and Pentaho Documentation

Use the Database Explorer

Parent article

The Database Explorer allows you to explore configured database connections. The Database Explorer also supports tables, views, and synonyms along with the catalog, schema, or both to which the table belongs.

A right-click on the selected table provides quick access to the following features:

Preview first 100Returns the first 100 rows from the selected table.
Preview x RowsPrompts you for the number of rows to return from the selected table.
Row CountSpecifies the total number of rows in the selected table.
Show LayoutDisplays a list of column names, data types, and so on from the selected table.
DDLGenerates the DDL to create the selected table based on the current connection type, the drop-down.
View SQLLaunches the Simple SQL Editor for the selected table.
Truncate Table

Generates a TRUNCATE table statement for the current table.

NoteThe statement is commented out by default to prevent users from accidentally deleting the table data
Data ProfileProvides basic information about the data.

You can open the Database Explorer in the Database Connections dialog box. In the PDI client, navigate to the View tab in the Explorer pane, and then double-click on the Database connections folder.