🚀

Release note - KAWA 1.31

1) New Features

1a) Control panel with filters

  • You can now create filter controls for your sheets, dashboards, and applications directly from the new Control Panel.
  • image
  • Filters can be enabled/disabled with a simple click on the filter icon.
  • image
  • Here’s an example of filters in Applications:
  • image

1b) Lakehouse integration

Our Lakehouse integration now supports Hive and Apache Iceberg, expanding your data compatibility options.

For complete documentation and setup details, please visit: Lakehouse Integration Documentation

1c) Scatter plot

We’ve enhanced scatter plot visualizations for advanced insights.

Here’s what’s new:

  • Display 2 groups within a single scatter plot for deeper comparisons.
  • Choose custom colors for better visual differentiation.
  • Flexible size mode and color mode for enhanced data exploration.
🎨

Color Mode Example

image
🔎

Size Mode Example

image

1d) Script parameters in ETL

Parameter in script now support an array of values:

image
image

1e) Data source from knowledge

We’ve introduced a powerful new capability: datasources from unstructured data! You can now easily transform unstructured documents—like PDFs—into structured, queryable datasources.

Here’s how it works

  1. Add your data:
  2. Head over to the Knowledge section and upload your unstructured data (for example, PDF files).

    image
  3. Initiate datasource creation:
  4. In the Datasource section, select Create datasource from knowledge.

    image
  5. Configure your extraction:
    • Choose the knowledge source you uploaded.
    • Enter a prompt to specify exactly what information you want to extract from the files.
    • image
  6. Define the schema:
    • You can either define the schema yourself or have it generated automatically from your prompt.
  7. Finalize:
  8. Click Next and Save. That’s it! You’ve now created a structured datasource from your unstructured data.

This new feature makes it easier than ever to harness the value of your documents. Enjoy exploring!

1f) Multi-Column Aggregations

You can now compute aggregations that rely on two columns. This update includes support for the following aggregation types:

  • ArgMin
  • ArgMax
  • Weighted Average
  • Count If
  • Count Unique If
  • Sum If
image
image

2) Improvements & Bugs fixes

  • Pivot table & charts:
    • Be able to format columns and rows.
    • New algorithms to compute % of totals in pivot tables.
    • Charting improvements.
    • Improved pivot table functionality.
  • AI:
    • AI workspaces now integrated with the App Co-Builder.
    • Alpha release of AI mapping with scheduling.
  • Data:
    • Improved introspection of warehouse tables (lazy instead of greedy loading).
    • Knowledge: be able to download the original file.
    • Smarter load of data statistics.
  • Other:
    • Application color editing capability.
    • Better handling of frozen column formatting.
    • Enhanced Python runner (scalable out).