Writing SQL can sometimes be challenging when you have to remember every function name. That’s why we’ve introduced a new feature allowing you to quickly search and insert functions using a Slash Command. With this addition, your SQL coding will be significantly faster and smoother.

• Slash Command + f (func) for Instant Search

  • In an SQL block, type /, followed by f (short for func), and press Enter. This automatically brings up the function search window.

• Automatic Insertion on Selection

  • Simply pick the function you need from the search results, and it will be inserted right into your SQL statement. This saves you from extra typing and potential typos.

• No Need to Memorize Exact Names

  • Typing just part of the function name will display the relevant suggestions, making it easy to find what you need without worrying about spelling or full function names.

• Faster Coding, Higher Efficiency

  • Quickly calling up commonly used functions boosts both your development speed and accuracy, making SQL queries much smoother to write.

By leveraging the function search feature in SQL blocks, you can instantly find and insert functions as you code, drastically improving both your speed and precision. Give it a try and experience more efficient query creation!

We plan to roll out more features and improvements to enhance productivity. If you have any feedback or requests, feel free to get in touch!

We’ve released a new feature IP Access Control that limits access to your Codatum workspace to specific IP addresses (or ranges) you approve.

Because access is controlled at the network level, this feature is ideal for companies with strict security policies or compliance requirements. You can tailor access to meet your organization’s needs, striking the perfect balance between security and convenience.

• Supported Formats

  : Supports IPv4/IPv6 addresses and CIDR ranges.

• Multiple Entries

  : You can register multiple IP addresses and IP ranges at once for your workspace.

• Important Note

  : To save your changes, you must be accessing Codatum from at least one of the IP addresses you’ve specified.

Try out our new IP Access Control feature and enjoy a more secure Codatum environment! For more details, check out our docs here.

Currently, IP Access Control is being offered as a private preview. If you’d like to try it or have any questions, please reach out to us!

We've implemented Undo/Redo functionality (Ctrl+Z and Ctrl+Shift+Z) when changing the position or size of Charts and other elements on Grid Page. This makes screen layout adjustments more intuitive and helps you recover from operational mistakes.

• Undo/Redo now works for position and size changes of Blocks such as Charts

• Adding or deleting Blocks is currently not supported

  • After these operations, your change history will be reset, making Undo ineffective

  • We plan to support these operations in the future

• Changes to internal Block settings are not supported

  • Chart configuration changes are confirmed with individual "Save" buttons and are separate from overall Grid Page operations

Important Note for Collaborative Editing:

• When another user makes changes during collaborative editing, your edit history will be reset. This is because it's difficult to selectively restore only your operations when, for example, another user deletes a parent container.

Many users naturally try to use Ctrl+Z in Grid Page, and this addition helps align with that expected behavior. Please try it out with these limitations in mind, and we welcome your feedback for future improvements.

We have implemented a color palette feature for charts, similar to Tableau or Power BI. With simple operations, you can freely customize color schemes and bring a sense of unity to your chart information. Please give it a try!

• Ability to create a chart color palette

  (Workspace settings > General)

• Select and apply the palette in the Notebook

• A wide variety of color scheme templates

• Automatic color scheme generation feature

Although this is a minor update, it is a very important improvement for visually conveying data. We will continue to refine the UI/UX, and we look forward to your feedback!

We've improved the display of collaboration cursors when editing notebooks together, making them easier to see and less intrusive. Now, teamwork can be even smoother, so give it a try!

• Cursors are now displayed on the left edge

• Resolved the issue where overlapping cursors made it difficult to read during multi-user editing

Although this is a minor update, it’s a crucial improvement for enhancing collaboration efficiency. We’ll continue refining the UI/UX, so we’d love to hear your feedback!

We’ve improved the member search functionality in the workspace, making it easier to find and collaborate with team members effortlessly. Give it a try!

• Keyword search for members

• Filter by role

• Filter by groups

• Sort by last active (date added)

Although this is a minor update, it’s a crucial improvement for enhancing collaboration efficiency. We’ll continue refining the UI/UX, so we’d love to hear your feedback!

We have created new use cases for Codatum. These use cases leverage public data from Google Analytics, Google Trends, and GitHub to perform data analysis, providing insights applicable to SaaS, E-commerce, and more. They serve as great examples of data analysis, so be sure to check them out!

• UX in Ecommerce

  • A use case for analyzing user behavior and applying insights to E-commerce.

• World Trends Analysis

  • A use case for analyzing trends in products and companies to drive business decisions.

• Programming Trends in Open-Source Files

  • A use case for analyzing programming trends and applying them to SaaS development.

Although this is a minor update, we hope it supports your data analysis strategies. We will continue refining the UI/UX, so we’d love to hear your feedback.

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!