Workbench

Metatron Workbench provides an environment for data preparation and analytics based on SQL. Its main functions are as follows:

• Various external databases can be loaded in one space.

• The user can conveniently navigate/select linked tables and columns and view their details.

• Query edit tools are embedded and query results can be viewed interactively and available for various uses:

  • Query results can be downloaded into a local file or exported to an online Excel.

  • Query results can be interactively visualized to help the analyst see an outline of the resulting data table.

  • Query results can be stored as a data source available for analytics in a workbook or notebook.

Each document that stores SQL-based analytic queries is called a “workbench.” This chapter introduce how to create and use workbenches.

• Create a workbench
• Use a workbench
  • Basic information section
  • Schema and table section
  • Query editor section
  • Query results section
  • Extra tools section
  • Schema browser