Notebook FAQ
important specifications related to Codatum Notebook
Last updated
Was this helpful?
important specifications related to Codatum Notebook
Last updated
Was this helpful?
Changes to parameters, SQL, and charts are immediately reflected and displayed to all users viewing the same Page. These changes are saved as the state within the notebook.
However, settings related to the appearance of the Page, such as toggle states of SQL Blocks or List items, are not synchronized between users.
Run all
?Available caches are used when executing Run all
For more details, please refer to the page.
If you do not wish to use the cache, for instance, after updating the data source, please execute all SQL Blocks from the top-right corner of the page by selecting Run all without cache
.
Notebooks can be locked to prevent editing, and only users with editing permissions for the Notebook can unlock it.
The lock function is designed to prevent accidental changes.
If you want to ensure changes cannot be made, share the Notebook with other users or groups with View permissions only.
Additionally, Notebook snapshots are automatically created by the Notebook Version. Even if accidental changes are made, you can restore to a certain extent and re-execute past SQLs to get the execution results.
As the content of a Doc Page grows longer, it becomes harder to understand the analysis.
Since SQL Blocks can reference SQL Blocks from other pages, you can continue analysis by splitting the Doc Page at any time.
Similarly, parameters can also be created and referenced across different Pages.
When the number of Pages increases, it becomes difficult to find where specific analyses were done.
Additionally, as the number of elements within a Page or the number of Pages increases, the performance of the entire Notebook may slow down.
If you want to share SQL statements across Notebooks, you can store them using the Query and refer to them from multiple Notebooks.
If the number of Pages becomes too large, save only the reusable SQL statements as Query and create a new Notebook.
Column name suggestions, along with metadata and schema displays, are limited to Table Ref or executed SQL Block Ref.
Please note that suggestions and schema displays are not available when using table IDs as strings or when referring to Saved Queries