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.