Query Builder
Query the data ..
Workshop - Query Editor
After investing time and effort building a metadata domain with tables, relationships, and business views, you need to validate that your semantic layer works correctly before deploying it to production or sharing it with end users. The Query Editor in Pentaho Metadata Editor provides a built-in testing environment that allows you to construct queries using your business-friendly categories and columns, then immediately see the generated SQL and resulting data—ensuring your metadata model produces accurate results.
In this hands-on workshop, you'll learn to use the Metadata Query Editor to test and validate the OrderStarCustomer domain. You'll select columns from business categories, execute queries, and review the preview data—experiencing the same intuitive interface that business users will encounter when building reports. This quick validation process helps you identify any issues with relationships, aggregations, or column definitions before publishing your domain to the Pentaho Server.
What You'll Accomplish:
Open an existing metadata domain in the Metadata Editor
Launch the Query Editor from the domain workspace
Navigate the Categories/Columns pane to explore available business fields
Select multiple columns from business categories for query construction
Execute metadata queries and review preview data
Understand how the Query Editor translates business selections into SQL
Validate that relationships and joins work correctly across tables
By the end of this workshop, you'll understand how to use the Query Editor as a testing and validation tool during metadata development. This quick preview capability allows you to verify your domain's behavior before deployment, catching potential issues with relationships, data types, or business logic early in the development cycle. Rather than waiting for end users to discover problems, you'll proactively test your metadata layer using the same intuitive interface they'll experience.
Prerequisites: Completion of OrdersME workshop or access to OrderStarCustomer.xmi domain file; Pentaho Metadata Editor installed and configured
Estimated Time: 15 minutes
File > Open from the menu options, Select: OrderStarCustomer.
Click: OK.
To open the Query Editor, in the top toolbar, click the Query Editor button.
In the Query Builder window, in the Categories / Columns pane, click to expand the Orders category.
Hold down the Ctrl key & in Categories / Columns pane, Select:
Click the top green arrow to move the columns to the Selected Columns pane.
To execute the query, on the toolbar, Click: Run (green arrow head).
Review the preview data and then Click: Close.
Close the Query Builder, Click: OK.
Was this helpful?