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.