Visual Query Builder

Visual Query Builder provides a visual interface for building complex SQL queries in the Read from DB stage.
Note: To work with Visual Query Builder, you need basic knowledge of SQL concepts.

To access Visual Query Builder, click the Build SQL button in Read from DB.

Understanding your Visual Query Builder page

The Visual Query Builder window has these two options:
  1. Select Columns: It allows you to:
    • Use Query Building Canvas to define source database objects, define links between them, and configure properties of tables and links. This is the main area where the visual representation of the query will be displayed.
    • Use Select Table/View tree pane located on the left to browse your query and quickly find any part of it. You can also use search to choose any particular table from the database selectively.
  2. Apply Operations: It allows you to perform all necessary operations with query output columns and expressions. You can select an aggregate from the dropdown, define field aliases, sorting, grouping, and criteria. If you want to add any additional expression from your datasource field list, click ADD.