This time, as a Feature Spotlight, we'd like to introduce Codatum's Report feature!

Codatum offers various sharing methods, but among them, the Report feature is a very powerful and unique function that allows you to share only the necessary insights internally and externally while maintaining data security.

What is the Codatum Report?

Codatum's Report converts a notebook into a report that can be accessed by guests (users who only have permission to view the shared report). The report can be shared by sharing a URL or embedding it on a website. The Report allows you to select which pages to share and display different values for each user.

Specifically, you can do the following:

• Share notebook output with guests without giving them access to connection information or the ability to edit queries .

• Select and share only specific pages.

• Choose whether to allow re-execution.

• Choose whether to display fixed SQL results or allow viewers to edit parameters.

Furthermore, while the Notebook itself can be collaboratively edited in real-time by editors with permissions, it can be difficult to edit while sharing. By using Reports, the content within the Notebook is "fixed" at the time of publishing, allowing you to share a completed version at a certain point in time and have it viewed while you continue editing the Notebook itself with peace of mind.

Benefits of the Report

• Secure collaboration with external guests:

  Share only the necessary information with external partners and clients without granting access to connection information. For example, when reporting analysis results to a client, you can use the Report to create and share a report of the notebook page summarizing the analysis results. This allows clients to access and easily understand the analysis results without having a Codatum account.

• Smooth sharing within the company:

  Sharing reports that summarize only the necessary information facilitates smooth communication with stakeholders. For example, when the marketing team reports the latest campaign results to management, they can use the Report to create and share a report of the notebook page containing key metrics and graphs. This allows management to easily access and understand the campaign results without having a Codatum account.

• Improved security:

  Restricting access to connection information reduces security risks. Even when sharing notebooks containing highly confidential data, the Report allows you to share only the necessary information while restricting access to connection information.

For more details, please refer to the Docs.

How to Use the Report

For instructions on how to use the Report, please refer to the following Docs:

• Report

• Sharing Overview

Summary

Codatum's Report feature is a powerful tool for sharing notebook content safely and easily. By allowing you to share only the necessary information while restricting access to connection information, it promotes information sharing within and outside the company while reducing security risks.

The Report can help promote understanding through data visualization, speed up decision-making, and accelerate business growth. We encourage you to utilize this new feature and hope it contributes to your business.

We welcome your feedback.

We’ve released a new Run Stats feature that shows you the overall execution status of your Notebook when you run “Run all”. You can now see dependency order, execution times, whether cache or in-memory processing was used, and even the total execution time and Total Bytes for the entire Notebook—all in one place.

• Dependency Visualization

  • Understand the order in which SQL Blocks are executed, including any dependencies.

  • Even complex Notebooks with many interdependent blocks are easier to track.

• Execution Times

  • Each block’s runtime is displayed in a bar format for quick comparison.

  • Easily identify bottlenecks that might slow down your workflow.

• Cache / In-memory processing

  • Check if queries used caches.

  • See if smaller data sets were processed in-memory.

  • Helps with optimizing queries and reducing costs.

• Total Time & Total Bytes

  • The feature also provides overall execution time and Total Bytes for the Notebook.

  • This overview supports performance tuning and cost estimation.

Use the new Run Stats feature to optimize Notebook performance and keep track of execution costs. We’ll continue updating the platform to help you work faster and smarter—stay tuned!

We welcome your feedback—let us know what you think!

Notebook sharing methods have greatly expanded!

Until now, collaboration and viewing were limited to within your team. However, with Public Link and Embedding, you can now easily share Notebooks outside your organization as well. Whether you’re sharing reports with clients or partners, or embedding a Notebook into a blog or internal wiki, these new options open up a wide range of possibilities.

• Generate a public URL for a specific Notebook or page so it can be viewed on the web.

• Anyone with the link can view the Notebook without needing an account.

• Set an expiration date to automatically disable the link after a certain period.

• Embed a Notebook or page into other websites, blogs, or internal wikis as an iframe.

  • Viewers can check the Notebook without leaving the embedded page, keeping information in one place and improving readability.

Performance and Security

• The Notebook’s display is provided in a pre-built state, so there’s no database access at viewing time.

• This minimizes database load and reduces potential security concerns.

• Since viewers see a pre-built result, rendering is faster and content can be accessed smoothly.

For more details, please visit our docs. We’ve also published videos on how to create Public Links and embed Notebooks, so be sure to check them out!

Previously, when you exported a Notebook, you could only create a new one. With this update, you can now import pages into an existing Notebook. This is especially handy if you want to reorganize an oversized Notebook or just reuse specific pages from one Notebook in another. Give it a try!

How to Use:

1. Export the Notebook that contains the page(s) you want to move.

2. In the target Notebook, open the menu in the upper-right corner and select “Import Page.”

3. Choose the pages you need and import them.

Whether you’re splitting a large Notebook or rearranging content in an existing one, be sure to take advantage of this new feature. We’ll continue improving the UI/UX, so please share your feedback!

We’ve added a new feature to SQL Block that lets you quickly select entire lines by dragging or clicking on the line number area—just like in IDE! This makes everyday tasks like code editing and copying/pasting much faster, so we hope you’ll give it a try.

• Drag on the line number to select the entire line

• Click on the line number to select a single line

• Similar behavior to Visual Studio Code for intuitive operation

Although it might seem like a small update, it’s a crucial improvement for boosting development efficiency. We’ll continue to enhance the UI/UX, so please share any feedback you may have!