Notebook FAQ

important specifications related to Codatum Notebook

Notebook

Are changes to parameters and charts independent for each user?

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.

Is the cache used when executing Run all ?

Available caches are used when executing Run all.

For more details, please refer to the SQL Block Cache 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.

Are there any limitations on Notebooks?

The maximum size per Notebook is 10MB.

Having a large amount of content may impact performance, particularly loading times and conflict resolution. To maintain smooth performance, we recommend keeping Notebooks concise. If a Notebook becomes too large, consider creating a new Notebook instead of adding more Pages.

Recommended ways to manage large Notebooks:

• Export a Notebook and import Pages into a new Notebook If a Notebook is growing too large, you can export the original Notebook, create a new Notebook, and import some Pages there. When moving Pages, ensure that referenced SQL Blocks are properly managed to avoid breaking dependencies.

• Archive old Notebooks If you no longer need to edit a large Notebook but still want to keep its content, you can duplicate it and set the duplicate as read-only for archival purposes. After that, you may delete unnecessary Pages from the original Notebook to reduce its size.

Doc Page

When the content of a Doc Page becomes lengthy, how do I know when to split it into multiple Pages?

As the content of a Doc Page becomes lengthy, the difficulty in understanding the analysis increases.

As SQL Blocks can reference SQL Blocks from other pages, you can continue the analysis by splitting the Doc Page at any time.

Similarly, parameters can also be created and referenced across different Pages.

As the number of Pages increases, how do I know when to split the Notebook?

When the number of Pages increases, finding where specific analyses were done becomes difficult.

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 increases considerably, save only the reusable SQL statements as Query and create a new Notebook.

SQL Block

Column names of tables referenced within an SQL Block are not being suggested.

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