LogoLogo
codatum.comSign InStart for free
  • Introduction
  • Getting Started
    • Quick Start
    • Concept (Further reading)
      • Why did we a choose Block Editor over Cell-based Editor?
  • Connect and Manage Data
    • Connection
      • Sync Table Metadata
    • Supported Warehouses
      • BigQuery
      • Snowflake
      • Other Warehouses
    • Catalog
    • Search
  • Data Exploration
    • Data Exploration Overview
    • Notebook
      • Doc Page
      • Grid Page
      • SQL Block
      • Version
      • Notebook FAQ
    • Chart
    • Explorer
    • Parameter
    • (Appendix) Cache
  • AI Assist
    • SQL Assistant
  • Sharing
    • Sharing Overview
    • Teamspace
    • Shared Notebook
    • Report
    • Public Link
    • Signed Embed
      • How to Set Up Signed Embed
  • Account Management
    • Account
    • Account Settings
  • Workspace & User Management
    • Workspace
  • User Management
    • Invitation
    • Group
  • Security
    • Security Overview
  • Audit logs
  • IP Access Control
  • Access control
    • Access Control Overview
    • Access Control for Workspace
    • Access Control for Resources
      • Access Control for Group
      • Access Control for Teamspace
      • Access Control for Notebook
      • Access Control for Connection
      • Access Control for Report
  • [Under Construction] Plan and Billing
    • Limit and usage
    • Downgrade and cancel
  • Best Practices
    • Advanced Control Structures in SQL
  • Other considerations
    • System requirements
Powered by GitBook

Reference

  • Privacy policy
  • Terms of service
  • JP Docs Site
On this page
  • Notebook
  • Doc Page
  • SQL Block

Was this helpful?

  1. Data Exploration
  2. Notebook

Notebook FAQ

important specifications related to Codatum Notebook

PreviousVersionNextChart

Last updated 3 months ago

Was this helpful?

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

SQL Block Cache