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.

Who can unlock the Notebook?

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.

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 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.

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

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.

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