The reference view feature in SQL blocks has been updated! It’s now easier than ever to check relevant information while writing queries — give it a try!

• Popups for reference information can now be pinned automatically by dragging them

• You can now scroll back to the origin from a pinned reference popup

• Execution results from other SQL blocks can now be displayed

Codatum continues to enhance features that improve the efficiency and accuracy of data analysis. We look forward to your feedback on this new functionality!

We're excited to announce the release of Amazon Redshift connection functionality in Codatum. Customers currently using Amazon Redshift can now access their data directly from Codatum's notebook environment.

Key Features

Support for Both Provisioned Clusters and Serverless

• Provisioned Clusters: Compatible with RA3 node cluster configurations

• Serverless: Also supports Redshift Serverless

Available for your existing environment setup.

Getting Started

Setup is completed in 3 steps:

1. AWS Preparation: Create necessary permissions and IAM users

2. Secrets Manager Setup: Securely manage connection information

3. Connect in Codatum: Add connection from Workspace Settings

For detailed instructions, please refer to our docs.

Redshift | Codatum Docs How to set up the Redshift connection and additional notes on using it

docs.codatum.com

To use this feature, please contact our support team in advance as prior inquiry is required.

To provide smoother service delivery in Japan, Codatum's admin interface now supports Japanese. Previously available only in English, we've created a more accessible interface for a broader range of users.

• Automatic Language Switching

  • Automatically displays Japanese UI when browser locale is set to ja

  • Displays English UI for all other locale settings

• Manual Language Toggle

  • Language can be freely switched in the account settings screen

  • Even with browser locale set to ja, you can change to English display within Codatum

  • Flexible language selection based on project or team requirements

With the introduction of Japanese UI, Japanese users can now use Codatum more smoothly and accessibly. Please try out the new Japanese interface.

We've enhanced our AI Assistant functionality. With more accurate responses, request modification capabilities, and real-time interactions, your data analysis workflow is now smoother.

• Revamped Backend and Prompts

  • Enhanced accuracy and performance along with improved output quality

  • Redesigned backend architecture to prepare for future extensibility

  • Better handling of complex data analysis tasks with greater precision

• Modify & Resubmit Existing Requests

  • You can now retry incorrect requests with modifications

  • Edit previously submitted questions to provide more accurate instructions

  • Faster trial and error cycles, reducing the time needed to achieve ideal results

• Streaming Response Support

  • Conversations are now more real-time than ever

  • Answers appear gradually, reducing perceived waiting time

  • Interact with the AI Assistant in a more natural conversational rhythm

With these AI Assistant improvements, data analysis has become more intuitive and efficient. Try out these new features and take your data utilization to the next level.

Grid Page now has an image component, and components can be added via drag & drop from the sidebar. Create dashboards more intuitively and beautifully than ever before.

• Add Components via Drag & Drop from Fixed Sidebar

  • Browse and add components to your Grid more intuitively than ever before!

  • See all available components at a glance in the new fixed sidebar

  • Drag & drop components directly from the sidebar to your Grid Page

• Image Component

  • You can now upload images to Grid Pages

  • Display relevant images alongside your data graphs and charts

  • Freely add corporate logos, explanatory images, screenshots, and more

  • Create more visual and compelling data dashboards

With the new fixed sidebar and image component, you can create Grid Pages more intuitively. Try out these new features and enhance your data visualization today.

We’ve made two major enhancements to Codatum’s charting features—both designed to improve flexibility and expressiveness in your day-to-day data visualization.

Sort by Any Field

Previously, charts could only be sorted by limited fields such as label or value, making it difficult to control the order of data precisely. With this update, you can now sort by any field or expression.

This is particularly useful in scenarios like:

• Preserving logical order in categories

  When displaying days of the week or months of the year, you can now sort by a predefined numeric field (e.g., day_index, month_order) instead of relying on the label itself.

• Following business-defined ordering

  In cases where you’ve previously added numbers to your labels (like “1. Category A”, “2. Category B”) just to control their order, you can now use a dedicated category_order field and keep your labels clean.

• Controlling sort order without exposing sort values

  You can display only store names while sorting by hidden fields like revenue or internal priority.

You can also define multi-level sorting, with intuitive controls to add, remove, or rearrange sort conditions.

Bubble Option for XY Charts: More Insight in a Single View

While Bubble charts have long been supported in XYZ charts, you can now also choose Bubble display in XY charts.

In XYZ charts, aggregation is typically applied only to the Z axis. With this update, XY charts now support using two different aggregation functions simultaneously—one for the Y axis and another for bubble size. This makes it easier to represent both primary and supporting metrics in a single chart.

Additionally, this update is compatible with combo charts and other advanced chart types, expanding the possibilities for flexible, data-rich visualizations.

• Example: Balancing Sales and Number of Orders

  • X-axis: Product category

  • Y-axis: Total sales

  • Size: Number of orders

This allows you to visually distinguish between categories that generate similar revenue in very different ways—such as those with high volume and low unit price, versus those driven by a few large orders.

With these updates, Codatum charts are now more powerful for both exploring your data and sharing it with others. We hope you enjoy the improved experience!

We're excited to announce that Codatum charts now include a zoom feature that allows for more detailed data analysis. This enhancement makes it possible to focus on specific time periods when viewing long-term data, enabling more precise analysis.

Key Features

• Drag to Zoom

  : Select and drag across a specific area of the chart to zoom in on that region

• Shift + Scroll to Zoom

  : Hold the Shift key while scrolling to smoothly zoom in and out

• Zoom Reset Button

  : Easily return to the original view with a single click

• Slider Zoom Control

  : Enable the slider in chart settings for more intuitive zoom navigation

When to Use

When displaying long-term KPI bar charts or other data visualizations, data points can become crowded, making it difficult to see detailed fluctuations. This feature is particularly useful when you want to:

• Analyze recent subtle trend changes in detail

• Examine data variations before and after specific events

• Investigate anomalies by magnifying specific time periods

How to Use

1. Open any chart component

2. Use any of these zoom methods:

   • Drag to select a specific area (area zoom)

   • Hold Shift while scrolling to zoom in and out (smooth zoom)

   • Enable and use the slider in chart settings (slider zoom)

3. Click the "Zoom Reset" button to return to the original view

Future Developments

Codatum continues to enhance features that improve the efficiency and accuracy of data analysis. We look forward to your feedback on this new functionality!

We've introduced Multi-Factor Authentication (MFA) to enhance account security in Codatum. This feature can be set up as an additional security layer for both Google authentication and Email + password authentication methods.

Key Features

• Authenticator App Support

  : Compatible with Google Authenticator, Microsoft Authenticator, and similar apps

• SMS Verification

  : Authentication via verification codes sent to your registered phone number

• Unauthorized Access Prevention

  : Even if account information is compromised, login is not possible without the second authentication factor

How to Set Up

1. Click the profile icon (bottom-left) > "Account settings" > "Sign-in & security"

2. Follow the on-screen instructions to complete setup

We especially recommend users with Email + password authentication to consider enabling MFA for enhanced security.

Codatum's GridPage uses responsive design that automatically optimizes layouts based on screen size. When the screen width is below 600px, components automatically stack vertically in a mobile layout.

This functionality is available across all display formats:

• Notebooks

• Public links

• Reports

• Signed embeds

The order of components in mobile layout is automatically determined based on the Grid configuration, eliminating the need for separate mobile-specific settings.

What's New in This Update

With this update, you can now easily preview how your content will appear in mobile layout and check the stacking order of your components before sharing. This allows you to ensure an optimal viewing experience for mobile users.

How to Use

1. Open any GridPage

2. Click the three-dot menu in the top right corner

3. Select Mobile Layout

4. Choose from the following options:

   • Preview: See how your content will look in mobile layout

   • Order index: Verify the vertical stacking order of components

Practical Applications

When sharing GridPages via Slack, email, or other platforms, recipients often view the content on mobile browsers. This new feature allows you to identify and fix any display issues or unintended component ordering before sharing, ensuring a seamless experience for all users.

Future Developments

At Codatum, we're committed to continuously improving the mobile experience. We'll be rolling out more mobile-focused updates in the future. We welcome your feedback on this and other features!

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!