Data Drawer

In the Data Drawer, you can see the preview of the model result. To ensure the preview is fast and not using unnecessary resources, these settings are specified:

  • The result set is limited to 100 rows.
  • The text [data type, data size] is displayed instead of all columns with Binary content. For example: [Binary, 12 Bytes].
  • Other data types are limited to display the first 100 characters.

You can switch between Grid view and Output format view and display the SQL code that is generated by the AnySQL modeler. Use the buttons on the right-hand side to select the required view.

Data Drawer is minimized by default. Select the Model Results tab to extend Data Drawer to a normal size. You can change the Data Drawer size manually by dragging the top border to the preferred position. If more space is required, use the buttons to decrease the font size and expand Data Drawer to the full size of AnySQL Modeler.

Click Refresh to refresh the data to match with the current status of the model.