Changelog

​

Performance, new functionality and bug fixes

​

New features

• Millisecond, nanosecond and microsecond precision added to Date Math and Date Difference (both for Syntax and the tools).
• We added a warning to the Group By tool if users aggregate columns with nulls as this can lead to unexpected results. We will continue to release automated data quality checks in the future.
• We added a visual cue to Sources and Destinations in the Folder overview to quickly identify which type they are (e.g. Google Sheet)
• We added Syntax support for Titlecase (TITLE)
• We added tooltips to all disabled actions due to missing permissions to make it clearer why you can’t perform an action.

​

Bug fixes

• Fixed a bug where wrapping other Syntax expressions with type conversion (e.g. INT, DATE, DATETIME) failed to convert the result
• Fixed dark mode colors on the Home page graph
• Fixed that sorting columns with nulls in Sort tool now puts nulls at the end of the list for descending order
• Truncated long asset names on Browse page
• Fixed that single quotes inside double quotes text literals now work without throwing an error

​

Rebuilding Sources

​

Bug fixes and reliability

• We thought it might be a good idea to limit the row limit on the Input and Limit tool to 1.000.000 rows. It seemed like a good threshold as anything else might be counterproductive. It wasn’t a good idea so we removed the limits.
• Fixed that the “Stop process” on the Canvas doesn’t show an “out of resources” error when the session is temporarily stopped
• Fixed an unhandled error that would occur when deleting permissions from an asset that you would then no longer have access to.
• Removed the “undefined” from Tool annotations before configuring them
• Added optional default schema for Snowflake Destinations and Sources
• Fixed a wrong error message when deleting assets you don’t have the right to delete (only applicable to multi-deleting)
• Ensured that the root folder is always present in the breadcrumbs

​

Quality-of-life improvements

• Improved the Group tool so it now auto-expands when you add multiple tools to it
• We opened the permission modal for all on Folders to view granular permissions
• Added more information on the permission tooltip to include the relevant groups and their roles
• Added an improved visual cue for the when jobs have no logs
• Better styling for response message from Snowflake on the Snowflake Destination
• Added the instance size to job log items
• Added support for duplicating assets
• Removed the option to delete default roles (Manager, Editor, Viewer)
• Fixed that reset filters did not function as expected on the datagrid
• Added support for moving assets to the root folder

​

Refined permissions and unhandled errors

• AND/OR syntax gave an unhandled error when not writing to boolean statements inside them
• DATE/DATETIME syntax gave unhandled errors when not using the appropriate format (YYYY-MM-DD for DATE and YYYY-MM-DD HH:MM:SS for DATETIME). Both also gave unhandled errors when using text literals without double quotes (e.g. 2025-01-01 instead of “2025-01-01”)
• Forward slashes were almost exlcusively used in text literals for URLs in the API tool. That lead to an unhandled error when using text literals and integer columns. This is fixed now.
• DATEDIFF gave unhandled errors not using right interval (e.g. ‘days’)
• The Filter tool didn’t check correctly for columns that no longer existed leading to unhandled errors
• The Combine tool didn’t handle adding a default suffix (right) when there already was a column with that name. For example, ID and ID_right in the left dataset and ID in the right dataset would give an error because it would try to add ID_right again leading to a duplciate column name. This is fixed now.

• We added a more detailed message when a Canvas session runs out of resources
• We added the ability to test a Snowflake Destination before creating it
• THe Group tool had problems handling 50+ tools. This is fixed now.
• We fixed the schedule modal for models so this now reflects that models without a published version cannot be scheduled
• Fixed a couple of remove logics: removing a user now gives the person that removes the user ownership of their assets, deleting a group now removes all permissions with that group too and deleting folders now delete all children assets
• Added a better description to the Snowflake Destination tool form to highlight the need for a schema
• The Combine tool now auto-selects new columns
• We fixed a bunch of edge cases with the Stack tool
• There was a problem showing data on the datagrid when columns names included .. This is fixed now.
• Fixed that changing a schedule on an asset should not trigger a rerun
• The asset log summary has been polished and now shows more information
• Publish a model version from the Folder View now works as expected
• There was a problem jumping between datasets on the datagrid with tools that had multiple anchors. This is fixed now.

​

Charts and sessions

• Fixed a problem in dark mode where the tabs on the Settings page were not visible
• Fixed the width of the schedule form when editing an asset
• Fixed the you can now delete tools and connection lines on backspace (primarily for Windows users)
• Removed the ability to use strings columns in the Close Combine tool
• Adjusted pagination on the datagrid to not show “100 of xx” rows when less than 100 rows are available
• Fixed an error causing change of workspace to redirect to same workspace
• Reworked copy/paste on the Canvas so that copy/paste in the Manual Input tool works as expected
• Fixed the drop tool on top of other tools resets cache downstream
• Fixed that it was impossible to remove Admin rights from users
• Fixed a problem where copy/pasted tools could not run before opening their tool configuration
• Fixed that restarting a session remembers your previous instance size

​

Bug fixes and reliability

• Fixed publish request emails for models
• Fixed that deleted assets were not shown on credit spending
• Fixed open links to previous versions on the “Compare Versions” page
• Fixed a ton of unhandled errors in the new syntaxing
• Fixed tool annotations on the Destination tool
• Fixed that the holidays anchor on the Count Business Days tools were not casting to the correct data type
• Fixed the View Data modal on the Browse page that were not always showing all data
• Fixed that the Rank tool was ranking in descending order

• Append and Upsert added to the Snowflake Destination
• Added the ability to remove OAuth connectivity with Snowflake
• Added a toast when restarting a session on the Canvas
• Added parameter support to Destination table names
• Implemented a 250 tool limit on the Canvas
• Restricted column names to be only alphanumeric and underscores
• Added the option to remove alphanumeric characters in the Transform tool
• Added the option to overwrite a specific table from another model in the Save Table tool
• Fixed that show selected columns in the Column tool resets the search term

​

Less 2.0

• We redesigned the entire platform with a focus on user experience and productivity
• Destinations to support sending data from Less to any other tool - whether databases like Snowflake, worksheet like Google Sheets, or even emails via Gmail.
• Customizable vertical scaling that allows you to select how much computation power you want. We already supported horizontal scaling enabling as many users to work without affecting performance. Now we’ve added vertical scaling to allow you to scale up to handle even the most complex datasets.
• Complete rebuild of the Canvas to support multiple anchors, draft and publish modes, syntaxing, new Group, Loop and Comment tools and much more. All tools have also been overhauled for a significantly better experience and increase in performance.
• We added Parameters to allow you to create and pass in variables to your models. It’s one of our favorite new features that allows you to create more dynamic and reusable models.
• Built our own geospatial tools so you don’t have to rely on external tools.
• You can now choose which assets you want to subscribe to notifications about. You can get emails, or you can choose to get Slack or Teams notifications.
• Completely customizable roles and permissions to allow you to control who built exactly that structure that fits your team’s needs.
• Audit logs for those people that just love to know everything about everything.
• Cron jobs for more customizable scheduling
• Built-in orchestration for running multiple models and sources in sequence
• And much, much more…