Changelog

New features, improvements, and fixes from the Supersimple team.

Invalid variable warnings

Variables whose types don't fit a certain use case are now clearly marked as disabled, and show a tooltip outlining the issue.

Mark invalid variables with helpful tooltips

Auto-adjust filter operators based on variable type

Filter operators now automatically switch to match the variable type you're working with. Less manual work, hooray!

Other improvements

  • We reworked our entire unstructured data retrieval system. Expect to see more relevant search results!
  • When AI references the same file or link multiple times, those are now collapsed into one footnote.

Introducing Research Mode (beta)

Our new Research agent can run a large number of searches across both your data warehouse & unstructured data sources. Currently only available to select accounts – contact us for access!

Other improvements

  • AI responses now cite sources more naturally, using inline quotes for single sources and footnotes for multiple sources.

Chat remembers your last data source selection

AI now remembers your last used data source(s) and defaults to that for the next message.

Other improvements

  • When editing a previous message, we now default to that past message's enabled data sources.

Filter by hasOne columns without selecting them

You can now filter for fields from related hasOne models without first "bringing them into" the table via New Column.

Each relation's fields are under a relevant subheading in the Filter field dropdown.

Organize explorations into folders

You can now organize explorations into folders in the sidebar by prefixing their names with a parenthesised name, e.g. (My Folder Name) My Exploration.

Exploration update metadata

Hovering explorations in the left sidebar now displays information on when they were last edited. And, even more details in the right sidebar once you open up an exploration.

Show exploration update metadata

Drill down from charts

You can now click directly on chart elements to drill down into the relevant data on a row level.

net_work_days formula function

The new net_work_days(start_date, end_date) function calculates the number of business days between two dates, excluding weekends.

Dynamic enum options

Enum options can now be loaded dynamically from queries, instead of having to hardcode every value. See docs for more!

models:
  user:
    properties:
      country_code:
        type: Enum
        enum_options:
          load: distinct_values

Enum discovery commands in CLI

New CLI commands discover bigquery enum and discover postgres enum make it easier to document enum values in your database schema.

Other improvements

  • AI can now use the native date range functionality; it previously loved to use separate filters for start & end date.

Dynamic AI reasoning effort

Supersimple's AI now dynamically determines the amount of reasoning that's required to answer a question. This means significantly faster responses and requests for clarification in many cases, while allowing the AI to think deeper when needed.

Query optimization

We now prune unused no-op no-code steps from your blocks. This leads to more easily readable compiled SQL and, in many cases, more performant queries.

Other improvements

  • We now auto-scroll you to the selected block when switching to Notebook.
  • Links in text blocks can be clicked/followed without selecting the text block itself.

Filter dates with range support

Date filtering now supports date ranges with 'is' and 'is not' operators, in addition to single dates with 'is after' and 'is before'.

Filter dates with range support

Sort bar charts

Bar charts now support manual sorting – find it in the chart settings sidebar.

Other improvements

  • When saving an exploration, your layout of choice (Notebook or Canvas) is saved for the entire team.