What is a workbook?
A workbook is a file that contains one or more queries that can be run against a database connection. Workbooks can be accessed from the workbook panel on the left-hand side of the screen.
Creating a new workbook
To create a new workbook, click the plus button at the top of the workbook panel on the left-hand side and select
New Workbook. Give your workbook a memorable name and press enter to finish creating your workbook. This will also load it's content in the query editor.
Using the query editor
After selecting a workbook from the workbook panel on the left-hand side, the contents of this workbook will be loaded into the query editor. Use this editor to modify the contents the workbook. Changes to the workbook are saved automatically as you type.
Using query completions
While writing queries in the query editor, use
Ctrl + Space to display query completions for the current context. See the connection guide for your specific database for more information on what APIs are available.
Workbooks with multiple queries
It is possible to have multiple queries in a single workbook. Expressions in your workbook separated by the
; character will be run in serial as separate queries to the database, but as part of the same execution on Ezfire.
Running your workbook
To run your workbook, click the pink
Run button in the top-right corner. The selected workbook will be run against the currently selected connection. The result of your workbook will appear in the result pane on the right-hand side. This will be the final result of running all queries in the workbook.
Deleting a workbook
To delete a workbook, right-click the workbook in the workbook list on the left-hand side and select
Delete from the context menu.